topic mysql setup in linux in Operating System - Linux

mysql setup in linux

Vinayak_HPUX — Wed, 09 Apr 2008 09:36:22 GMT

I have done setup of mysql server/client but not able to access getting as below plz help......?
[root@linuxguru.symantec.com][ /root ]mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

What to do?

Re: mysql setup in linux

Vinayak_HPUX — Wed, 09 Apr 2008 09:47:44 GMT

Even following is not working
[root@linuxguru.symantec.com][ /root ]mysql -u linuxguru -p
Enter password:
ERROR 1045 (28000): Access denied for user 'linuxguru'@'localhost' (using password: YES)
[root@linuxguru.symantec.com][ /root ]

Re: mysql setup in linux

Aashique — Wed, 09 Apr 2008 10:43:54 GMT

hi,
Grant the user

mysql>GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Thanks & Regards

Aashique

Re: mysql setup in linux

Vinayak_HPUX — Wed, 09 Apr 2008 10:56:49 GMT

Dear I have forgotten my password .....!
now not getting mysql> prompt to execute Query ???

Re: mysql setup in linux

Vinayak_HPUX — Thu, 10 Apr 2008 06:33:50 GMT

Hay I got solution.............
ITS ASSUMMED THAT CLIENT/SERVER SETUP IS DONE WELL BUT FORGOT PASSWORD / NOT ABLE TO ACCESS mysql> prompt

1>kill all previous process belongs to mysql server
kill -9

2>Open 2 separate terminals login as a root and VLU [valid linux user] or sql user

ON root :
# mysqld_safe --skip-grant-tables

ON VLU :
# mysql mysql

mysql> UPDATE user SET Password=PASSWORD('redhat')WHERE Host='localhost' AND User='root';

so ur password will be "redhat"

then
login as sql user say linuxguru
and do

mysql -u root -p
passwd: redhat

u will have mysql> prompt

and enjoy

Re: mysql setup in linux

Vinayak_HPUX — Mon, 31 Aug 2009 05:39:27 GMT

I got the solutions