Hi.

Using mySQL 4.1.22 on Linux, I got this error message suddenly this
morning (it worked ok yesterday):
---------
[EMAIL PROTECTED] /usr/local/mysql/bin/mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
----------

I created a '/root/root.sql' file:
--------
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxx');
--------

And killed the process and restarted:
--------
[EMAIL PROTECTED] ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql 
&
[1] 2494
[EMAIL PROTECTED] ~]# Starting mysqld daemon with databases from 
/usr/local/mysql/var
--------

But I get the same error message :(

In my '/usr/local/mysql/var/server.err' file there's no error message:
--
070220 07:03:40  mysqld started
070220 07:03:40  InnoDB: Started; log sequence number 0 3758734
/usr/local/mysql/libexec/mysqld: ready for connections.
Version: '4.1.22'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
-------

What am I doing wrong?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to