[byron3]

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

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=”7159″]<{POST_SNAPBACK}>[/post]

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?

[byron3]

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

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/downloads/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=”7156″]<{POST_SNAPBACK}>[/post]

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.

[byron3]

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

http://webyog.com/faq/index.php?sid=105&la…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=”7153″]<{POST_SNAPBACK}>[/post]

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.”

[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?

[byron3]

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

http://webyog.com/faq/index.php?action=show&cat=23

[post=”7150″]<{POST_SNAPBACK}>[/post]

[Author]

Posts