[CLUE-Tech] mysql initialization problem: access denied for user: root

Young, Ed Ed.Young at echostar.com
Wed Apr 30 09:45:19 MDT 2003



When trying to run any mysqladmin command I get: 
mysqladmin: connect to server at 'localhost' failed 
error: 'Access denied for user: 'root at localhost' (Using password: NO)' 

System: RH8.0 
mysql-3.23.56-1.80 
perl-DBD-MySQL-2.1017-3 
mysql-server-3.23.56-1.80 
php-mysql-4.2.2-8.0.7 

I ran the install_mysql_db script to initialize it 
It started the server and set up the test database I guess. It then told me
to set the password for the root user: 
[root at gerakina ed]# mysqladmin -u root password 'mypassword' 
[root at gerakina ed]# mysqladmin -u root -h gerakina password 'mypassword' 

The second one didn't return for a long time and I accidentally killed my x
session. 

Now here is a sample of the errors I get when I try to run any mysql calls: 
[root at gerakina ed]# safe_mysqld & 
[1] 1403 
[root at gerakina ed]# Starting mysqld daemon with databases from 
/var/lib/mysql 

[root at gerakina ed]# mysqladmin version 
mysqladmin: connect to server at 'localhost' failed 
error: 'Access denied for user: 'root at localhost' (Using password: NO)' 
[root at gerakina ed]# 


[root at gerakina ed]# mysqladmin -u root password 'mypassword' 
mysqladmin: connect to server at 'localhost' failed 
error: 'Access denied for user: 'root at localhost' (Using password: NO)' 
[root at gerakina ed]# 


[root at gerakina ed]# cd /var/lib/mysql/ 
[root at gerakina mysql]# ls 
Jekyll mysql mysql.sock test 
[root at gerakina mysql]# 

How can I fix this? 

 Thanx.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue-tech/attachments/20030430/3e109ef5/attachment.html


More information about the clue-tech mailing list