MySQL problem, localhost access deleted

MySQL problem, localhost access deleted

am 06.03.2005 01:14:51 von Webmaster Otau Games

------=_NextPart_000_0029_01C521E9.E5828540
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I've installed in my Windows Server 2003 dedicated server Apache 2.0.53, =
PHP 5.0.3, and MySQL 4.1.10.

To test it, I've put PHPMyAdmin, and try to access this one. All was =
fine as PHPMyAdmin was running fine.

But I've make a big mistake : in PHPMyAdmin, instead of adding a new =
user, I've deleted all the users. And now MySQL refuse that localhost =
access to the service. I've tried to uninstall/reinstall MySQL but when =
I try to launch the service there is an error : n°106

How can I solve this problem ?

Thank you.

------=_NextPart_000_0029_01C521E9.E5828540--

Re: MySQL problem, localhost access deleted

am 06.03.2005 20:01:47 von Bill Schwab

Read about --skip-grant-tables. Keep in mind that while you have root =
access w/o a password, so does the rest of the world. If possible, you =
should either disconnect or ideally you already have a firewall in place.

Bill



Wilhelm K. Schwab, Ph.D.
University of Florida
Department of Anesthesiology
PO Box 100254
Gainesville, FL 32610-0254

Email: bills@anest4.anest.ufl.edu
Tel: (352) 846-1285
FAX: (352) 392-7029

>>> "Webmaster Otau Games" 03/05/05 7:14 PM >>>
Hi,

I've installed in my Windows Server 2003 dedicated server Apache 2.0.53, =
PHP 5.0.3, and MySQL 4.1.10.

To test it, I've put PHPMyAdmin, and try to access this one. All was fine =
as PHPMyAdmin was running fine.

But I've make a big mistake : in PHPMyAdmin, instead of adding a new user, =
I've deleted all the users. And now MySQL refuse that localhost access to =
the service. I've tried to uninstall/reinstall MySQL but when I try to =
launch the service there is an error : n°106

How can I solve this problem ?

Thank you.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org