I have installed it successfully on Ubuntu, after creating the database I need to create the privilege to all privileges. But there is no option for me in phpadmin panel

aaP_support2 Hello, granting all privileges to a database account is not a secure access to the database, what is your database version? You can refer to this official MySQL documentation to do this (here is an example for MySQL version 5.7): https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

Authorization is done as follows. Go to a MySQL terminal and execute the following command. Format: grant permissions on database name. table name to user@loginhost identified by "user password". USE mysql; GRANT ALL PRIVILEGES ON *. * TO 'youeruser'@'%' IDENTIFIED BY 'password'. if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } Note the security.

create users prevelege to All

aaP_support2

aapanel_power yeah it's not for all users we needed to create a database with all privileges then only we will be able to install a PHP script

aaP_support2

also am not a developer so can you please help me to create the all privileges in the database
like a video or something

aaP_support2

Please help me in this

Aap_Sidney

aapanel_power where is the MySQL terminal on aapannel?

aaP_mdestafadilah_simrs

Aap_Sidney in /www/server folder

Aap_Sidney

aaP_mdestafadilah_simrs please provide complete information. I accessed this path and could not find terminal

aaPanel_Kern

Hello, is the problem solved? You can click on the terminal to directly use commands to access mysql

aaP_preciousapene88

Aap_Sidney

aaP_preciousapene88

My SQL terminal

Aap_Sidney

aaPanel_Kern what is the command to run and access mysql to changer user pemission?

aaP_mdestafadilah_simrs

Aap_Sidney why so hard using terminal if aapanel provide GUI to change root password?? like below.

Aap_Sidney

aaP_mdestafadilah_simrs This is not my issue. I am talking about User privileges for databases.

aaP_mdestafadilah_simrs

Aap_Sidney so it's not about aapanel, it's about your os's configuration. please read manual of your os's.

aaP_mdestafadilah_simrs

aapanel_power USE THIS !! it's your trouble resolved.

aaP_m23328586

Hello aapanel_power
When i run this command i'm getting error access denied