Problems connecting to MySQL

**tech291083** · 09-29-2007, 11:22 AM

Hi,

I am Linux Fedora and having problems connecting to MySQL despite being root. Here is the error when I type mysql at the prompt/terminal.

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

Can any one help? Thanks...

**Kernel_Killer** · 10-04-2007, 04:25 PM

Did you recently change the users? If its a fresh install of MySQL, try logging in with root, without a password. I'm not sure if FC has you set a password on install, but some do not, leaving the password blank for root.

**tech291083** · 10-20-2007, 09:19 AM

Originally Posted by Kernel_Killer

Did you recently change the users? If its a fresh install of MySQL, try logging in with root, without a password. I'm not sure if FC has you set a password on install, but some do not, leaving the password blank for root.

Thanks you...its working now for some weired reason it stopped...

**dharmdeep** · 08-29-2008, 11:00 AM

hi

**sekhar.12484** · 05-08-2009, 08:35 AM

just type

#mysql

mysql>

grant the permissions to localhost

mysql> grant all on * to root@localhost identified by "passwd";

u can login with

#mysql -u root -p