Connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user

Hello, Error code : Error: Connection to the database server has failed because the supplied account does not possess administrative privileges:Access denied for user ‘admin’@’localhost’ to database   This error means that MySQL administrator account that is used in Plesk does not have enough privileges to manage database/users in the MySQL server. Solution :   […]

How to reset the mysql root password from mysql safe?

Steps to reset mysql root password from mysql safe: # service mysqld stop # mysqld_safe –skip-grant-tables & That should start up mysql without the need for a root password. Once in, type >use mysql >UPDATE user SET password=PASSWORD(‘newpass’) WHERE user=’root’; >FLUSH PRIVILEGES; >quit That will reset the root password for you. Kill all old processes […]