Hello,
MySQL admin user accidentally until the "All Privileges" powers I broke
nano -w /etc/my.cnf
File;
skip-grant-tables
add;
MySQL -uadm the -p`cat / etc / psa / psa .psa.shadow`
I can enter with the command mysql console. However;
http://kb.odin.com/en/116916
I want to apply the commands in the address;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it can not execute this statement
Comes the warning. So the admin user of the "All Privileges" How can I give powers back again. I appreciate if you can help.
Panel version 5.11.30
Operating System: CentOS release 6.5 32Bit
MySQL version: 1.5.73 - Source distribution
Thank you.
MySQL admin user accidentally until the "All Privileges" powers I broke
nano -w /etc/my.cnf
File;
skip-grant-tables
add;
MySQL -uadm the -p`cat / etc / psa / psa .psa.shadow`
I can enter with the command mysql console. However;
http://kb.odin.com/en/116916
I want to apply the commands in the address;
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it can not execute this statement
Comes the warning. So the admin user of the "All Privileges" How can I give powers back again. I appreciate if you can help.
Panel version 5.11.30
Operating System: CentOS release 6.5 32Bit
MySQL version: 1.5.73 - Source distribution
Thank you.