i'm having some trouble with my MySQL server where i can't log in or connect to it from the terminal , phpmyadmin or my server control panel. the password is correct , i have reset it a number of times but still get the same message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y
does anybody know what might cause this (please don't say the password is wrong)
Depending on the platform "localhost" might connect via a Unix domain socket. If this is the case, then it might be that there is a mismatch between where the socket is really located in the filesystem (as specified in my.ini) and where the MySQL client (whatever you are using as a client) expects it.
To test that, I would try the connection using the mysql command line client and use the identical my.ini file.