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'.Note the security.
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
also am not a developer so can you please help me to create the all privileges in the database
like a video or something
Please help me in this
aapanel_power where is the MySQL terminal on aapannel?
Aap_Sidney in /www/server folder
aaP_mdestafadilah_simrs please provide complete information. I accessed this path and could not find terminal
My SQL terminal
Hello, is the problem solved? You can click on the terminal to directly use commands to access mysql
aaPanel_Kern what is the command to run and access mysql to changer user pemission?
Aap_Sidney why so hard using terminal if aapanel provide GUI to change root password?? like below.
aaP_mdestafadilah_simrs This is not my issue. I am talking about User privileges for databases.
Aap_Sidney so it's not about aapanel, it's about your os's configuration. please read manual of your os's.
aapanel_power USE THIS !! it's your trouble resolved.
Hello aapanel_power
When i run this command i'm getting error access denied
