#1130 - Host '%$' is not allowed to connect to this

Problems with the Windows version of XAMPP, questions, comments, and anything related.

#1130 - Host '%$' is not allowed to connect to this

Postby twentyfour24 » 13. December 2011 22:42

PROBLEM DESCRIPTION:
When I select the phpMyAdmin hyperlink from the "XAMPP For Windows" page, I get a page displayed thats says:

ERROR
MySQL said:
#1130 - Host '%$' is not allowed to connect to this MySQL server

BACKGROUND:
I am using a Windows Vista PC and I am just using this PC to learn php, it is not a "real" server environment.

I just installed XAMPP 1.7.7 on my Windows Vista machine. I am able to enter "localhost" and the "XAMPP For Windows" page displays just fine.

When I access the XAMPP control panel, Apache says "running" and is button to the right is green and MySQL is running and the button next to it is green.

When I attempt to take the phpMyAdmin link on the "XAMPP For Windows" page, I get the above error.

Please advise me as to how to get past this error message.
twentyfour24
 
Posts: 2
Joined: 13. December 2011 20:25
Operating System: Windows Vista

Re: #1130 - Host '%$' is not allowed to connect to this

Postby Sharley » 13. December 2011 23:36

Have you changed any settings in any configuration files at all?

Have you had a previous phpMyAdmin or MySQL installed before XAMPP

Have you uninstalled and reinstalled XAMPP a few times before this last installation?

Did you use the installer version or an archive version to install XAMPP?

Are you an Administrator in Vista?


When I researched this I found that it could be related to a setting in the MySQL my.ini file.

If you open \xampp\mysql\bin\my.ini file in your text editor and uncomment, remove the # from this line so it looks like this
Code: Select all
bind-address="127.0.0.1"
save the file and restart MySQL then try again to access.

Also make sure that in your Windows hosts file this line is the first line after all the comments
Code: Select all
127.0.0.1 localhost



Just as an addition try using the new Version 3 control panel found in the xampp folder as it has more helpful features:
xampp-control-3-beta.exe
First close the older 2.5 version then right click on the above exe and select to run as admin.

The latest version XCPv3 can be found in a link in my signature.
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: #1130 - Host '%$' is not allowed to connect to this

Postby twentyfour24 » 16. December 2011 06:08

Thank you so very much for your help.

I am still not having success after implementing the changes that you suggested.

Your suggestions were very easy to understand and implement which I really appreciate because I am new to XAMPP and MySql and pHp.

I love the XAMPP3 control panel beta you suggested for many reasons. It is so well organized and has so many useful features.

Using the beta3 version of the control panel I was able to locate the mysql log file and that log file contains lots of error messages.

I think I am going to research the errors and see if they lead me to a solution to the issue.

Here is a portion of the MYSQL error log:

111215 18:22:49 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
111215 18:22:59 InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
twentyfour24
 
Posts: 2
Joined: 13. December 2011 20:25
Operating System: Windows Vista

Re: #1130 - Host '%$' is not allowed to connect to this

Postby Sharley » 16. December 2011 06:15

The 2nd and 3rd question in my first post may be related as I suspected that you may have another instance of MySQL or had another instance perhaps in a PHP IDE or some other program like Eclipse or similar and may be a place to start looking.

Also do a file search on your PC for my.ini as there should be only the one in the \xampp\mysql\bin folder.

Good look and best wishes. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 62 guests