Mysql error 1045(28000)

[cooldude9119]

i recently baught a vps from veeble.org

4-core processor
2gb ram
150gb hd
centos


im getting this error when i try to acess mysql
ERROR 1045 (28000): Access denied for user (Using password: YES)

even when i login from root ,
pls help me here

pm me for more details or reply here , i need this help urgent

thanks in advance

cooldude9119 Reviewed by cooldude9119 on 5th Feb 2011. Mysql error 1045(28000) i recently baught a vps from veeble.org 4-core processor 2gb ram 150gb hd centos im getting this error when i try to acess mysql ERROR 1045 (28000): Access denied for user (Using password: YES) Rating: 5

[soft2050]

your datbase settings are not correct
Means, your username/password or dbname is wrong.

Change your databse name, user pass in your script and server also.

[Lock Down]

1) Login to mysql server, type following command at shell prompt:

mysql -u root -p

2) Use mysql database (type command at mysql> prompt):

mysql> use mysql;

3) Change password for user Your_USERname:

mysql> update user set password=PASSWORD("NEWPASSWORD") where User='Your_USERname';

4) Reload privileges:

mysql> flush privileges;
mysql> quit

[cooldude9119]

your datbase settings are not correct
Means, your username/password or dbname is wrong.

Change your databse name, user pass in your script and server also.

i dont know how to do this

1) Login to mysql server, type following command at shell prompt:


2) Use mysql database (type command at mysql> prompt):


3) Change password for user Your_USERname:


4) Reload privileges:

when i type mysql -u root -p
same error i displayed

[cooldude9119]

guys still havent solved this pls help me

[accyuklad]

best downloading your sql and files then reinstall then upload again

[Lock Down]

You have pm.