• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

MySQL Admin All Privileges

EnderK

New Pleskian
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.
 

Attachments

  • grant1.jpg
    grant1.jpg
    123.4 KB · Views: 3
  • grant2.jpg
    grant2.jpg
    215.6 KB · Views: 4
Back
Top