granting all privileges to my phpmyadmin user in cpanel does not add the INSERT privilege, and when I want to insert privileges to a database in phpmyadmin it tells me without privileges and # 1045 - Access denied to user: 'root '@' localhost '(Using password: NO) how can I solve this? I would appreciate your help friends I have been trying to solve this for weeks but nowhere do you know how to solve this.
Access denied to user: 'root' @ 'localhost' (Using password: NO)
You may be able to access it in the following way from the console:
sudo mysql
If you have root access from the console you should be able to do this by using the following command.
GRANT INSERT PRIVILEGES ON nombredb.tabla TO 'phpmyadmin'@'localhost';
where dbname is the name of the database and table the desired table. It is also possible to use an asterisk to assign all the tables in the database or all the databases.
In turn it is necessary to refresh the permissions by FLUSH PRIVILEGES; .
I add you a link that can be of help.