Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Kevin H. Phillips]

This is probably a dead horse but let me post a followup to let everyone 
know what I did and what has happened since.  Maybe I should list it 
under some other error number.

Before Paul posted his message I uninstalled (using rpm -e) version 
4.0.13.  I then got the RedHat installation CDs and reinstalled the 
version that came boxed with it and then got the update which makes it 
3.23.56-1.9, I believe.

The server would start fine.  I copied the my.cnf file to /etc and added 
a user mysql to the mysqld section.

Using mysqladmin, I can find version and status but cannot set the 
password for the root user and can't get processlist.  When I try 
setting the password, I get this:

[root@mail root]# mysqladmin -u root -p password 'password'
Enter password:
mysqladmin: unable to change password; error: 'Access denied for user: 
'@localhost' to database 'mysql''


I can't use FLUSH PRIVILEGES either:

[root@mail root]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.56-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> FLUSH PRIVILEGES;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)


I can't grant privileges:

[root@mail root]# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 3.23.56-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL ON *.* TO root@localhost IDENTIFIED BY 'password' WITH 
GRANT OPTION;
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)
mysql>

I notice that when the small my.cnf file that is in place when the 
packages first install (just 193K, I think) is used the server will stop 
and start just fine.  When I replace that with a larger version 
(/usr/share/doc/mysql-server-3.23.56 on my installation) then the server 
will not stay running; will show "Failed" when I try to restart.

Kevin Phillips