Re: Error 1044 & Error 2003 on 4.0.13 and RH9

[Nils Valentin]

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:
>
> [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

-- 
---
Valentin Nils
Internet Technology

 E-Mail: nils@stripped
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils