Hi Kevin, In this case the error log file (hostname.err) in f.e /var/lib/mysql should give you an idea whats going on.
Perhaps the settings inside the my.cnf from the newer version are very different then from the older version. Best regards Nils Valentin Tokyo/Japan 2003年 7月 10日 木曜日 11:23、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: > > [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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
