MySQL question

John Abreau jabr at
Tue Feb 22 15:32:03 EST 2000

On Tue, 22 Feb 2000, Paul Lussier wrote:

> Hi all,
> Does anyone know how to log into a MySQL database if the password you though 
> you set doesn't work ?
> I'm getting ready to re-install the thing! :)

Look in the scripts/mysql_install_db in the mysql directory. This is the
script that creates the initial authorization tables.

To re-run this, rename data/mysql to something like data/mysql_old, then
run scripts/mysql_install_db. You'll then be able to connect to mysql.

If the old access tables need to be restored, you can edit the mysql_old
to fix your password, and then shutdown the database again, remove the new
data/mysql rename the previously saved data/mysql_old to data/mysql.
Restart the database and you're all set.

John Abreau / Executive Director, Boston Linux & Unix 
Email: jabr at / URL:
ICQ#28611923 / AIM abreauj
"Working with NT is like trying to tune a watch wearing oven mitts.
 You can't get your fingers inside like you can with UNIX.

Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at (Subject line is ignored).

More information about the Discuss mailing list