• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

Migration Database Problem - My fix

L

lpittman

Guest
I have just been working on a migration from a Plesk 7.5.4 / RH 7.3 server to a Plesk 8.0.1 / CentOS 4.2 server and ran into a couple small issues. One of which seems to be a common issue for a lot of people I have talked with, which is your database not being copied over.

This is the error:

Failed deployment of database mydatabase (domain mydomain.com)

This is the related entry in the log file:

Runtime error during 'db': (1, '', "ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: NO)\n")

Everything seemed like it should work (my admin password was correct and I could login fine via 'mysql -uadmin -pmypass') but it just wouldn't insert the .sql file into the new database.

I had a somewhat complex password, something like #9F8VjFx3 (no, thats not my password) and found that if i changed it (temporarily) to something simple like setup the database insert ran perfectly and my migration continued with no issues what-so-ever.

I hope this little discovery can help someone else ...

Luke
 
Back
Top