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.
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...