Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Tyrone Miles on December 10, 2001, 03:16:35 AM

Title: MYSQL
Post by: Tyrone Miles on December 10, 2001, 03:16:35 AM

How do you change the root password in mysql? It is crazy trying to use the 75 digit password in the ldap.pw file.

Title: Re: MYSQL
Post by: Dan G. on December 10, 2001, 03:25:17 AM

I didn't change it, I adapted to it :)  It's a bit unwieldy, but it's not manipulated very often.  I am starting to get the hang of MYSQL admin, so I'm opting for the creation of a "master user" accounts for new installations -- and they'll have nice, elegant passwords ;)

Dan

Title: Re: MYSQL
Post by: Rob Hillis on December 10, 2001, 05:37:47 AM

Dan G. wrote:

> I didn't change it, I adapted to it :)  It's a bit unwieldy,
> but it's not manipulated very often.  I am starting to get
> the hang of MYSQL admin, so I'm opting for the creation of a
> "master user" accounts for new installations -- and they'll
> have nice, elegant passwords ;)

Don't go changing the default root password - it breaks things like backups...

My installation of MySQL includes an admin account with the same password as root/admin, and that's the one I use when I need to.

Mind you, I have gone playing with MySQL before, so it is possible I created this account and then forgot about it...