« What are new or updated features in Oracle 10g that are directly related to database performance?Techniques to Manage Remote Workforce »

MySQL Error 1130 when connecting from MySQL Control Center

10/03/04 | by Clarise | Categories: Databases

I am running MySQL control center on a Windows 2000 box and trying to connect to a newly installed mysql database on a Linux box. How do I solve this error:
[mysql] ERROR 1130: Host 'HOSTNAME' is not allowed to connect to this MySQL server ?

Answer:
Issue the following:

$ mysql -uUSERNAME -pPASSWORD mysql
mysql> grant all on * to 'USERNAME' identified by 'PASSWORD';

This will give the user, specified by 'USERNAME', all the privileges on all the tables and be able to connect from any host. Hence, if you issue:

mysql> select user, host from user;

The result will be something like:
+--------------+-----------+
| user | host |
+--------------+-----------+
| admin | % |
| admin | localhost |
| blogmaster | localhost |
| horde | localhost |
| surveymaster | localhost |
+--------------+-----------+

So, you may want to modify the SQL statement if you don't want to grant the user all the privileges. :)

Send feedback »
 

No feedback yet

June 2019
Mon Tue Wed Thu Fri Sat Sun
          1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
 << <   > >>
This blog contains thoughts that range from non-technical to technical. Its name is derived from "Yakity Blah Blah" a column I once had that discussed a cornucopia of ideas. Who am I? I'm Clarise Z. Doval Santos, providing Project Management and Technical Leadership for data management and analytic, data science, IoT and sensor analytics ecosystems 37.652951177164 -122.490877706959

Search

  XML Feeds

Multiple blogs done right!