You need to kill the mysql process, then you can startup MySQL from the
command line with the --skip-grant-tables option. MySQL will then load
without checking for any passwords, it will be completely open. You can
then "log" in as a guest and change the root password.
>sudo /usr/local/mysql/bin/mysqld --user=mysql --skip-grant-tables
>mysql
mysql>
On Mar 8, 2005, at 2:47 PM, Jeff Justice wrote:
So, I installed MySQL. Accidentally locked myself out of the database
trying to make it secure. Tried to re-install MySQL, now every time I
tell it to "Start MySQL Server" through the control panel, it asks for
authentication, then immediately goes back to "stopped". It won't
launch.
Is there a way to un-install this and start COMPLETELY from scratch?
It did work once.
Jeff J.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]