Make sure that the
admin user has all privileges:- Log into MySQL server:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql - Check admin privileges:
mysql> SHOW GRANTS FOR 'admin'@'localhost'\G - Grant all privileges to
adminif required:GRANT ALL ON *.* TO 'admin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; - check
/var/log/mysqld.log.
If you see a message such as:[ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create itthis probably means that MySQL was reinstalled or was not upgraded completely. Run the following command to update MySQL:MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin- check