Sql error after move from cpanel to plesk

Portal Home > Knowledgebase > Articles Database > Sql error after move from cpanel to plesk

Posted by 0senjed0, 11-14-2008, 12:58 PM
Sql error after move from cpanel to plesk Hi every body after i move my accounts from cpanel to plesk all of my websites used sql gives me error similar this in php-nuke : There seems to be a problem with the MySQL server, sorry for the inconvenience. what should i do exactly ?
Posted by nasir5, 11-14-2008, 01:50 PM
Can you please paste the exact error message you are getting?
Posted by 0senjed0, 11-14-2008, 02:19 PM
There seems to be a problem with the MySQL server, sorry for the inconvenience. We should be back shortly.
Posted by barry[CoffeeSprout], 11-14-2008, 04:23 PM
Can you make sure MySQL is actually running? It looks as if your sites can no longer connect to it. Check this in Plesk (not sure how)
Posted by gillyjames, 11-14-2008, 04:36 PM
I think, the accounts to get grant all privileges to solve this issue.
Posted by jphilipson, 11-14-2008, 04:39 PM
You may need to verify the MySQL user names for the scripts are correct. I've had to correct names when transferring sites between cPanel and Plesk before, due to the way each system creates user names. __________________I perform System Administration
Posted by 0senjed0, 11-15-2008, 03:49 PM
Quote: Originally Posted by gillyjames I think, the accounts to get grant all privileges to solve this issue. yes it will be solve with this update but how can i do it in plesk ? is there any SSH command ? Last edited by 0senjed0 : 11-15-2008 at 02:53 PM.
Posted by majoosh, 11-16-2008, 07:14 PM
Quote: Originally Posted by 0senjed0 yes it will be solve with this update but how can i do it in plesk ? is there any SSH command ? First you need to check the phpnuke configuration script and see if the username and password are set correct. Then try to login to mysql via command line with the same username and password. i.e ssh to the server then use the syntax below to get mysql prompt, mysql -u username -p username should be replaced by the username in the configuration script. You will be prompted for the password, enter the password from the configuration script. If you are not able to login and gives error like access denied, then login to mysql prompt with root. i.e mysql -u root -p then give the commands below, mysql> use database; mysql>grant all privileges on database.* to username@"localhost" identified by 'password'; replace database,username and password accordingly. Hope this will fix the problem. Majoosh
Posted by jaseeey, 11-16-2008, 07:27 PM
If it is an import issue and it says there are no privellages to the user to create the database, simply change the two instances of the old database name in the SQL file, to the new one which is made in cPanel. It is generally just the database name which is the issue because the SQL file is trying to create a new database with the old name, but cPanel uses a different naming scheme.
Posted by 0senjed0, 11-19-2008, 04:37 PM
yes it shows me there are no privellages to the user to create the database . can you please reply me what should i do exactly step by step ?
Posted by jphilipson, 11-19-2008, 04:58 PM
Quote: Originally Posted by 0senjed0 yes it shows me there are no privellages to the user to create the database . can you please reply me what should i do exactly step by step ? You can remove the user, then recreate the mysql user in Plesk, then it will get all permissions back. __________________I perform System Administration
Posted by 0senjed0, 11-19-2008, 05:23 PM
if i remove the user i don't lost my data ?
Posted by jaseeey, 11-19-2008, 05:40 PM
Open the SQL file which you created from the MySQL dump. Locate the two instances of the old database name. You will see one in the CREATE DATABASE function, and another in the USE function. Replace these two instances of your old database name, to your new database name which is the one you created in cPanel. Then save the file, and import it. It should work fine.

Add to Favourites Print this Article