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: [EMAIL PROTECTED] / 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.
-----------------------------------------------------------------------
**********************************************************
To unsubscribe from this list, send mail to
[EMAIL PROTECTED] with the following text in the
*body* (*not* the subject line) of the letter:
unsubscribe gnhlug
**********************************************************
