Topic: 5.0 changes mySQL pw - how do i get it back!

[John Lewis]

Just upgraded to 5.0.  Everything went smoothly.  However, it has reset all the permissions in the ibays  to the default, and has apparently changed the root password to mySQL.

I checked /home/.my.cnf, and the pw in that file is hashed.

HELP, I have several sites which are php/mysql based, and need to get them back up and running...

Thanks.

[Chaloner Hale]

I just got myphpnuke going after installing SME 5.0. In order for me to get the MYSQL password into config.php, I used vi. Once inside config.php, I read in /root/.my.cnf and copied the password to $dbpass and added the quotes at the begining and end.

It worked...

Good luck

[John Lewis]

OK, after looking at the mysql documentation on www.mysql.com, I found the following at: http://www.mysql.com/doc/D/e/Default_privileges.html

Because your installation is initially wide open, one of the first things you should do is specify a password for the MySQL root user. You can do this as follows (note that you specify the password using the PASSWORD() function):

shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
mysql> FLUSH PRIVILEGES;

I ran these, setting the root password to be the 4.1.2 one, and reset the required priv's for my primary ibay to allow my geeklog app to work, and all is well.

[Dan Brown]

Are you sure it's hashed?  I think it's just a very long, random string.

If you'd created separate database users for each of these apps, you wouldn't have had this problem.

[John Lewis]

Yeah, yeah, I know.  I've tried several times to get users set up for databases.  Never worked for me...

I'm in the middle of reading the doc's now.  Its looking like I needed to restart mysql, or at least flush the current permissions.

Thanks though.  Not sure about the hash, but the DB password for root was changed back to being empty.

And the phpMyAdmin no longer seems to be available.  I'm working on installing phpMyAdmin in a secure ibay at this point...

[Charlie Brady]

Dan Brown wrote:
 
> If you'd created separate database users for each of these
> apps, you wouldn't have had this problem.

You wouldd also have a more secure system. Every application should have its own database - period.

Charlie

[Mark Farey]

My root password also got changed to a very long random character string, but rather than restoring the old password I modified my applications to use the long string. More secure that way!

Mark.
Ottawa, Canada.

[Thor Anthrax]

[root@broe1452 /root]# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

What's next?

[Dan Brown]

Thor, did you even read the rest of this thread?  Your question would seem to be answered here, though you haven't given any indication of what you've done to this point.

[ChS]

Hi there,
I am trying to use mysql, but am about to give up : I must say, I think i have done THE mistake : I changed the .my.cnf password and restarted the server. I never got access before. Can not go any lower, can I. Now, the password the config.inc.php file in phpmyadmin is the same one, but I still get the "Access denied for user: 'root@localhost' " message. How can I repair the install. Should I re-install the whole thing, or is there a way to get this to work anyway ?