Topic: phpmyadmin access from local network

[ldavies]

Some background info

Using MySQL Administrator to access mysql on e-smith server running in server-gateway mode version 6.01

Network:

Internet
|
|
e-smith server-gateway 6.01
(note: has been set up to identify local network 192.168.0.XXX)
192.168.1.1
|
|
192.168.1.2
wireless router, DHCP enabled
192.168.0.1
|
|
192.168.0.2
Windows xp pc, mysql admistrator installed

The error message I get when I try to connect to 192.168.1.1 with user 'mysqladmin' is as follows:
-----------
Could not get to the specified host
MySQL Error Nr. 1045
Access denied to the user 'mysqladmin@pc-00002.mydomainname.com'
(Using password: YES)
---------------

I had previous set up full privileges for the following users in mysql using the command prompt (GRANT PRIVILEGES..... WITH GRANT OPTION;) which seemed to work OK :
mysqladmin@localhost
mysqladmin@mydomainname.com

I tried to set up a "full privilege" user with the name 'mysqladmin@pc-00002.mydomainname.com' but got an error message about there being a SQL syntax error near '-0002.boldwellies.com' presumably because MySQL did not like the dash.

Also I can ping 192.168.1.1.

Does anyone have any ideas on how to solve this.  Help much appreciated.

Please don't suggest using phpmyadmin instead.  I really like the gui stuff.

Thanks very much for help

[bobk]

...
-----------
Could not get to the specified host
MySQL Error Nr. 1045
Access denied to the user 'mysqladmin@pc-00002.mydomainname.com'
(Using password: YES)
---------------

I had previous set up full privileges for the following users in mysql using the command prompt (GRANT PRIVILEGES..... WITH GRANT OPTION;) which seemed to work OK :
mysqladmin@localhost
mysqladmin@mydomainname.com

I tried to set up a "full privilege" user with the name 'mysqladmin@pc-00002.mydomainname.com' but got an error message about there being a SQL syntax error near '-0002.boldwellies.com' presumably because MySQL did not like the dash...

From the mysql documentation

In order to accommodate granting rights to users from arbitrary hosts, MySQL supports specifying the user_name value in the form user@host. If you want to specify a user string containing special characters (such as -'), or a host string containing special characters or wildcard characters (such as %'), you can quote the user or host name (for example, 'test-user'@'test-hostname').

Recheck how you entered mysqladmin@pc-00002.mydomainname.com when granting permissions. It should be mysqladmin@'pc-00002.mydomainname.com' because of the special character "-". Take note of the single quote marks.

[ldavies]

This worked perfectly - thanks