Re: [cobalt-users] mysql 4 package? - password problem

[Jim Dory <jdory@xxxxxxxxxxxxxx>]

Arthur Sherman wrote:

> Was that .RPM? If so do:
>
> Rpm -qa | grep mysql
>
> You may uninstall the old release. 
>
> Rpm -ev mysql-VER
>
> If you run in to troubles send me output of rpm-qa above
>
> And you definitely should take mysql-VER.tar.gz source.
>
> Arthur Sherman
>
>
>
>  
No, it was not an rpm. It was: mysql-standard-4.0.18-pc-linux-i686.tar.gz
I got impatient and just deleted the directory structure since I didn't have to do any configure, make, or make install.

Then I got the correct download and followed your instructions and got everything working. Then the next day I upgraded to php-4.3.4 and that seems to work. I went back to mysql and now I can't log in. I had previously given a new root password, and wrote down that password. It no longer works.

I get a ERROR 1045: access denied for user: 'root@localhost'.


I've searched google and mysql.com but their technique is not working for me. I'm about to try to start researching how to uninstall mysql and try it again. What I have tried and does not work is this:

shell> kill `cat /mysql-data-directory/ourdomain.org.pid`

then I try a killall -9 mysql or mysqld and it says no service killed. I also try /etc/rc.d/init.d/mysql stop just to make sure and it say it could not find a pid. If I ps -aux | grep mysql it only finds the 'grep mysql', so I'm fairly confident no other mysql is running.

Then I try starting with --skip-grant-tables
and I get this error:

[root bin]# kill `cat /home/mysql/data/ourdomain.org.pid`
[root bin]# /home/mysql/bin/mysqld start --skip-grant-tables
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
040223  9:21:46  Aborting

040223  9:21:46  /home/mysql/bin/mysqld: Shutdown Complete

I've read the security section of the mysql.com manual and it basically restates what I have been trying, unless I'm missing something.

If I try /etc/rc.d/init.d/mysql start --skip-grant-tables 
mysql starts but still no access.

So before a uninstall/reinstall.. any thoughts on what I'm doing wrong?

I've also made sure the /etc/my.cnf file has the password commented out, as well as trying that with the /root/.my.cnf file that I had copied over from /etc. (After all these other attempts didn't work.)

Jim D.