MySQL question

[John Abreau]

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 blu.org / URL: http://www.blu.org
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 blu.org (Subject line is ignored).