jason... did a fresh mysql install..

simply type

foo> mysql

and mysq will start, assuming you have the mysq daemon started.

to start the mysql daemon,
 /etc/init.d/service/mysql start

(check it first, but it's something like the above..)


-----Original Message-----
From: Jason Todd Slack-Moehrle [mailto:mailingli...@mailnewsrss.com]
Sent: Monday, April 27, 2009 9:46 AM
To: mysql@lists.mysql.com
Subject: Resetting MySQL Root Password


Hi All,

CentOS 5.3

I installed MySQL Server via yum and started it.

I tried entering:

mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword

But I get:

r...@server1 ~]# /usr/bin/mysqladmin -u root -h localhost password
mypassword
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

How can I reset this and allow Root access, otherwise nobody has access!

Thanks,

-Jason

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=bedoug...@earthlink.net


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to