12 replies to this topic

[byron3]

Ok mysql works on test server, mysqladmin allows access to databases. When trying to connect from a workstation on my LAN via SQLyog I recieve an error message no. 1130 "host is not allowed to connect to the MySQL server". I know this has to be a permission problem, so where do I go and what do I do to correct it?

[Ritesh]

http://webyog.com/fa...ion=show&cat=23

[byron3]

Ritesh, on Sep 13 2005, 11:27 AM, said:

http://webyog.com/fa...ion=show&cat=23

<{POST_SNAPBACK}>

[byron3]

Thanks for the quick reply, unfortuneatly I had already searched the faq's for this error problem. Did not find it. Perhaps you could make it simple for me and tell what exactly what I need to configure to make this work. My computer is running Windows XP Pro, what do I need to do to grant permisssion to my workstation to allow acces to MySQL through SQLyog?

[peterlaursen]

http://webyog.com/fa...d=18&artlang=en

says:
* User is not allowed to connect from the actual host. Note that MySQL by default only allows connection from 'localhost'. To specify from where a user may connect SQL wildcards (% and _) can be used. Simply 'someuser@%' means that user 'someuser' may connect from everywhere.

Please reply back if that was it. If it was I will add the error no. 1130 to the FAQ.

[byron3]

peterlaursen, on Sep 13 2005, 12:13 PM, said:

http://webyog.com/fa...d=18&artlang=en

says:
* User is not allowed to connect from the actual host.  Note that MySQL by default only allows connection from 'localhost'.  To specify from where a user may connect SQL wildcards (% and _) can be used. Simply 'someuser@%' means that user  'someuser' may connect from everywhere.

Please reply back if that was it.  If it was I will add the error no. 1130 to the FAQ.

<{POST_SNAPBACK}>

Added new user granted all permissions on all tables, MySQLadmin would not allow the '%' wildcard, error message that it was a syntax error. Used the "username@_', still have same error message on workstation, " host 'workstation's network name' is not allowed to connect to the MySQL server."

[peterlaursen]

well it is the solution!

On which OS does the server run?
If it is windows, why not install SQLyog on it and manage usrs with it?
If it is not Windows, did you check if MySQL Administrator is available for that platform? http://dev.mysql.com.../administrator/

is "MySQLadmin" the the commandline MySQLadmin.exe? I don't know how to set up user privileges with this one!

This error message "host 'workstation's network name' is not allowed to connect to the MySQL server" is mysterious! You won't need "network names". SQLyog connects through TCP-IP - not named pipes.

[peterlaursen]

And you should ALLWAYS tell which MySQL version and SQLyog version you are using!

[byron3]

peterlaursen, on Sep 13 2005, 01:08 PM, said:

well it is the solution!

On which OS does the server run?
If it is windows, why not install SQLyog on it and manage usrs with it?
If it is not Windows, did you check if MySQL Administrator is available for that platform? http://dev.mysql.com.../administrator/

is "MySQLadmin" the the commandline MySQLadmin.exe?  I don't know how to set up user privileges with this one!

This error message "host 'workstation's network name' is not allowed to connect to the MySQL server" is mysterious!  You won't need "network names".  SQLyog connects through TCP-IP - not named pipes.

<{POST_SNAPBACK}>

OS system is Windows XP Professional, SQLyog is Free MySQL GUI v4.1, MySQL is 5.0.0-alpha-nt.
Set up another user "Username@workstation's network name" and now have access. For some reason the wildcard "%" was rejected as valid syntax, and the "_" was not accepted as a wildcard.
Thanks to everyone for the help.

[peterlaursen]

Then I learned something too!

I did not know that MySQL allowed the use of Windows Network network names.
But I just tested on my own network and it does!


Are you serious that you are using 5.0.0 ?
Not 5.0.11 or 5.0.12 or 5.0.14 for instance ?

[byron3]

peterlaursen, on Sep 13 2005, 01:51 PM, said:

Then I learned something too!

I did not know that MySQL allowed the use of Windows Network network names.
But I just tested on my own network and it does!
Are you serious that you are using 5.0.0 ?
Not 5.0.11 or 5.0.12 or 5.0.14 for instance ?

<{POST_SNAPBACK}>

That version number is correct 5.0.0-alpha-nt, it came off of a CD that came with a book "PHP and MySQL Web Development" by luke welling and Laura Thomson.
Would love to have the latest version of MySql but I am still using a dial up connection and do not have the luxury of downloading large files, my buisness only has one phone line and the download time would be excessive. Can I download the newest binary files and upgrade to the newest release version? Any ideals why the "%" wildcard was invalid syntax or why the "_" was not parsed as a wildcard? When looking at my users I have three that I did not create, one is a blank user @ localhost, one is a blank user@grande, and one is a blank user@grande with no passwords can I delete these three user?

[peterlaursen]

You should upgrade.
Is this so bad: http://dev.mysql.com.../mysql/5.0.html

The list of bugfixes from 5.0.0 to 5.0.12 is no less than 20 pages.
If you want to learn MySQL it would be a bad idea to learn with a version full of bugs.

I have no idea of that wildcard issue. Never used that client.

My advice is that you use SQLyog for manipulation your databases and MySQL Administrator for manipulationg the server environment.

[peterlaursen]

You can safely delete any user except for root@localhost.

Don't forget the password of root@localhost and don't attempt to change the privileges of root@localhost. Then you can always get back.

But maybe the version that came with that book has some prefigured settings to work with exercises.

You should always get your MySQL from MySQL, I think!