Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 MySQL Error Number:1130

Author  Topic 

siji44
Starting Member

1 Post

Posted - 2010-08-04 : 12:28:11
Hi,

Im new to MySql. I was trying to install MySql server 5.1. In the MySql Server Instance configuration wizard, got an error.

The security settings could not be applied.
Error Number 1130.
Host 'localhost' is not allowed to connect to this MySql Server.

I tried to access the user table by
C:\install-dir\bin> mysql -u root

Again im getting the error
ERROR 1130 (HY000):Host 'localhost' is not allowed to connect to this MySql Server.

How can I correct this? Please Help.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-04 : 12:32:42
SQLTeam.com is a Microsoft SQL Server site. We don't specialize in MySql here, so I'd highly recommend that you post your question on a MySql forum such as the over at dbforums.com or mysql.com which is the vendor's web site.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -