• 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

Trying to login to mysql with MySql Administrator.

M

MarcusInMd

Guest
Keep getting an error Access denied for user such and such using passowrd YES.

I am using the username and password that I use to login to plesk control panel on our server. I have also tried various DB usernames and passwords.

Anyone have an idea of why this is not working?

Using the lastest windows version of mysql Adminsitrator on a remote computer.

Mysql version 4.0.24
 
Did you run mysql_fix_privilege_tables after the MySQL upgrade?
 
Hi

Im not a Plesk Guru but have some Mysql experience.

My guess would be that as you are trying to access mysql from a remote computer that computer does not have permission to access it.

If you have ssh access type

mysql -u admin -p
Type your admin password

You get to a mysql> prompt

type

mysql> use mysql
mysql> select * from user;

This will show the user privilage table - take a look at the host column, I would guess yours will say localhost which means that only users from the localhost can connect.

Take a look at http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html for an explanation of how privlages work in mysql

Hope this helps

Paul
 
Back
Top