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

[Nathan Hokanson]

Try:
mysqladmin version -u root -p

You should be prompted for the root password (for mysql).  The version
information should be given after that.

If that doesn't work, when you do `ps aux` do you see mysqld running?

On Wed, 2003-04-30 at 09:45, Young, Ed wrote:
> 
> 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.
-- 
Nathan Hokanson
-- 
Nathan Hokanson                          nathan at redfactor.com
Partner/Lead Architect                   303-549-7652
RedFactor                                http://www.redfactor.com