Topic: MYSQL

[Tyrone Miles]

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

[Dan G.]

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

[Rob Hillis]

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...