Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

MySQL question



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




BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org