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
create users prevelege to All
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
- Edited
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
3 years later
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.
3 months later
Hello aapanel_power
When i run this command i'm getting error access denied