Problems connecting to MySQL

[tech291083]

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]

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]

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]

hi

[sekhar.12484]

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

[countach44]

don’t forget to run "FLUSH PRIVILEGES" after editing mysql grant tables.