S
sieb@
Guest
Access to the client instance of mysql as admin is denied. This just happened randomly. I had this problem once before and fixed it per Botsman's instructions in this thread (http://forum.plesk.com/showthread.php?s=&threadid=25369&highlight=mysql+access+denied) but its not working now.
Stop mysql, change my.ini to "skip_grant_tables", restart mysql, clear admin password, restart, access denied. Or, if I clear the admin password and set a new one, access is denied again. I check the 'misc' table in PSA's db and the password is correct, but no access. Even if I try to connect with Mysql Control Center, I get access denied. This is getting to be annoying because we cannot create user databases, nor can we run psadump.
Stop mysql, change my.ini to "skip_grant_tables", restart mysql, clear admin password, restart, access denied. Or, if I clear the admin password and set a new one, access is denied again. I check the 'misc' table in PSA's db and the password is correct, but no access. Even if I try to connect with Mysql Control Center, I get access denied. This is getting to be annoying because we cannot create user databases, nor can we run psadump.