Acessing The MySQL Command Line

[uwa45]

Hi, i install Fedora core 3 on my machine and also MySql to play with database.but am having problems accessing The MySql Command line.
i Keep getting Error 1045: Access denied for user ' root@localhost. what do i do pls?
am a newbie.

[trickster]

mysqladmin -u root password yourrootsqlpassword
mysql -u root -p

[uwa45]

thanks for your prompt reply. i tried access the command line with mysql -u root -p with -u being the user(root) and -p(password) which is my root sql password.but i still get the error msg.what do you think would be wrong or what am i doing wrong?

[dambar]

Initially, no password is set for the root account
Plz, try using one of the following commands

mysql -u root

mysql -u username

mysql

:and don't forget to change the password

[Compunuts]

I don't know about Fedora but Ubuntu will take main sudoer's password and put it as mysql's root password. I thought fedora was more technically advanced in terms of security (or so some have claimed).

[arunr110]

You can try the below method also
use

#/usr/sbin/mysqladmin -u root password 'new-password' and change the root user password for MySQL.

Then restart the Mysql server.(service mysqld restart)

#mysql -u root -p (hit enter)

Mysql will ask for password...
Enter the password and login...

Even if you get the same error ... some other problem..