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:
[EMAIL PROTECTED] 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:
[EMAIL PROTECTED] 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:
[EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
