13 messages in com.mysql.lists.win32RE: cant connect to DB
FromSent OnAttachments
Meghna Agrawal21 Jul 2003 07:54 
Wohlberg, Jonathan21 Jul 2003 07:55 
Mike Hillyer21 Jul 2003 07:57 
Meghna Agrawal21 Jul 2003 08:01 
Meghna Agrawal21 Jul 2003 08:09 
Joe Harkins21 Jul 2003 11:01 
Melle de Jong21 Jul 2003 11:27 
Mike Hillyer21 Jul 2003 11:35 
J.A. Jones Tyler III21 Jul 2003 15:05 
Xu, Qiang (XSSC SGP)22 Jul 2003 20:58 
Leo G. Divingracia III22 Jul 2003 20:59 
Jeff Ferris23 Jul 2003 08:27 
Virginia R. Hetrick23 Jul 2003 13:05 
Subject:RE: cant connect to DB
From:Meghna Agrawal (magr@innovationplus.com)
Date:07/21/2003 08:09:05 AM
List:com.mysql.lists.win32

The problem is I am locked out of the database since I cant connect using any of the three user entries. So I cant add anything to the user table.

So I tried MySQL control centre and tried to access as root@127.0.0.1 and as root@localhost. Both of them don't work.

Please help...

-----Original Message----- From: Mike Hillyer [mailto:mhil@rinax.com] Sent: Monday, July 21, 2003 10:58 AM To: Meghna Agrawal; win@lists.mysql.com Subject: RE: cant connect to DB

Well, I see root@localhost on your list of users, but not root@127.0.0.1

Without getting into the details of why localhost != 127.0.0.1 you simply need to add another entry for root@127.0.0.1 that matches your root@localhost entry, or just change localhost to 127.0.0.1

Regards, Mike Hillyer www.vbmysql.com

-----Original Message----- From: Meghna Agrawal [mailto:magr@innovationplus.com] Sent: Monday, July 21, 2003 8:54 AM To: win@lists.mysql.com Subject: cant connect to DB

Hi

I recently installed MySQL. I had three users in the user table - root@localhost, user1@localhost, user2@% . all three had passwords. Now when I restarted the system, it gives me the following error -

C:\mysql\bin>mysql -u root ERROR 1130: Host '127.0.0.1' is not allowed to connect to this MySQL server

I am running the server and the client on a windows xp machine.

Please let me know if you know how to correct this.

Meg.