sql error

[babarmughal]

hi,

 

I am following the WIKI documants and getting this messge............

 

[root@localhost root]# mysqladmin create osCommerce -u mySQLuserName -p

Enter password:

mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user: 'mySQLuserName@localhost' (Using password: YES)'

 

 

Can someone help me please..........what do i do.........

 

Thanks

 

Babar :(

[phpro]

First of all... what part of the docs are you referring to? The error message you are getting means that you are trying to connect to mysql as a user that either doesn't exist or your password is wrong. If you haven't created the user mySQLuserName, this won't work.

 

Generally, when creating a database, you need to log in as some one with lots of privileges. Since you are root, try logging in as root and creating that database and then granting some other user privileges to that database.

 

For example:

 

mysql -u root -p

[root password]

create database osCommerce;

grant all privileges on osCommerce.* to oscuser@localhost identified by [oscuser password];

\q

 

This will create a database called osCommerce and give oscuser full rights to it.

 

If this is a fresh install of mysql, remember that there is no password for root, so set one!

 

Good Luck!

phpro

[babarmughal]

Hi

 

I have done what u said and it gave me this........

 

 

[root@localhost //]# mysql -u root -p

Enter password:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

 

Thanks

 

Babar