database problem in plesk

Portal Home > Knowledgebase > Articles Database > database problem in plesk

Posted by aria33, 02-23-2012, 09:59 PM
Hi, I have created a database in my plesk and created a username and password for it, but when im testing it i see this error: could not connect to server Access denied for user 'paulb'@'localhost' (using password: NO) , Im using "parallels Plesk 9.5.4" Plese help
Posted by foobic, 02-24-2012, 12:49 AM
I'm not a Plesk user but I'd say there's a good clue in that error message. You're not providing the password. How exactly are you trying to connect?
Posted by rockgeeks, 02-24-2012, 01:53 AM
If you have shell access then you can reset password of your database using the following commands MySQL administrator must be 'root' user with the empty password. If you know current 'root' MySQL password, please login with it and continue with the query from the step 2. If you do not know the password, begin from the step 1: 1.Add the 'skip-grant-tables' option into /etc/my.cnf in '[mysqld]' section and restart MySQL: 2. Set the empty password for MySQL 'root' user: # mysql -uroot -Dmysql -e 'update user set password="" where user="root"' 3. Comment out or remove string 'skip-grant-tables' in /etc/my.cnf and restart MySQL
Posted by aria33, 02-24-2012, 10:17 PM
Hi, im trying to check my database as following: I have created a php file "SQLtest.php" and specified the password of database in the code provided in the knowledge base of my provider. they dont have good support thats why im posting the problems here.
Posted by aria33, 02-24-2012, 10:23 PM
I dont have shell access cause my plan is shared, i can change my password from databases>database name> database username after this there will be a place to change the password and the username i tried this but still the problem persists.

Add to Favourites Print this Article