Problems after MySQL upgrade

[juyas]

Hello to everybody.

I've been running one major problem since we upgraded our database from 3.23 to 4.1.

Through Plesk, we can do the usual stuff like create domains, etc. The problem arise when we deal with database. We can created databases, with user and password. But the user and password that has been create cannot connect to the database that it has been set for.

Can someone help me with this?

 

[hardweb]

Run the following command:

mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`