[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