Koozali.org: home of the SME Server
Legacy Forums => Experienced User Forum => Topic started by: ldavies on April 18, 2004, 12:13:43 AM
-
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 :)
-
...
-----------
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.
-
This worked perfectly - thanks