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

[DeepSun]

Hi All can u help to create a database , I am getting the error in logging or when creating database

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

Entering mysql like below

[p ~]$ mysql --user=root -p
Enter password: ========> (what password should be given here ??)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

(OR)


[p ~]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27 to server version: 5.0.27

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database abc;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'abc'


Can any one help how to resolve this, thanks in advance..

[richei]

this one should be obvious. you entered the wrong password.

[DeepSun]

Hi richei,,,

thanks for the reply...
Actually i want to know the password when logging for the first time.

ERROR 1045 (28000): u mean to say this is due to wrong p/w.
can u tell me what should be the password when logging for the first time ??


ERROR 1044 (42000): here , can't we create a database by entering mysql by providing "mysql" as mentioned below.

Thanks again.

[richei]

if this is a default install with no other configuration done, then there wouldn't be a password, so nothing would be entered.

but, if you messed with the configuration ini, then you need to sort through that to find the password.