<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.19">
<TITLE>mysql initialization problem: access denied for user: root</TITLE>
</HEAD>
<BODY>
<BR>
<BR>
<P><FONT FACE="Arial">When trying to run any mysqladmin command I get: </FONT>
<BR><FONT FACE="Arial">mysqladmin: connect to server at 'localhost' failed<BR>
error: 'Access denied for user: 'root@localhost' (Using password: NO)'<BR>
<BR>
System: RH8.0<BR>
mysql-3.23.56-1.80<BR>
perl-DBD-MySQL-2.1017-3<BR>
mysql-server-3.23.56-1.80<BR>
php-mysql-4.2.2-8.0.7<BR>
<BR>
I ran the install_mysql_db script to initialize it<BR>
It started the server and set up the test database I guess. It then told me to set the password for the root user:<BR>
[root@gerakina ed]# mysqladmin -u root password 'mypassword'<BR>
[root@gerakina ed]# mysqladmin -u root -h gerakina password 'mypassword'<BR>
<BR>
The second one didn't return for a long time and I accidentally killed my x session.<BR>
<BR>
Now here is a sample of the errors I get when I try to run any mysql calls:<BR>
[root@gerakina ed]# safe_mysqld &<BR>
[1] 1403<BR>
[root@gerakina ed]# Starting mysqld daemon with databases from<BR>
/var/lib/mysql<BR>
<BR>
[root@gerakina ed]# mysqladmin version<BR>
mysqladmin: connect to server at 'localhost' failed<BR>
error: 'Access denied for user: 'root@localhost' (Using password: NO)'<BR>
[root@gerakina ed]#<BR>
<BR>
<BR>
[root@gerakina ed]# mysqladmin -u root password 'mypassword'<BR>
mysqladmin: connect to server at 'localhost' failed<BR>
error: 'Access denied for user: 'root@localhost' (Using password: NO)'<BR>
[root@gerakina ed]#<BR>
<BR>
<BR>
[root@gerakina ed]# cd /var/lib/mysql/<BR>
[root@gerakina mysql]# ls<BR>
Jekyll mysql mysql.sock test<BR>
[root@gerakina mysql]#<BR>
<BR>
How can I fix this? </FONT>
</P>
<P><I><FONT SIZE=2 FACE="Arial"> Thanx.</FONT></I>
</P>
</BODY>
</HTML>