I am using Uniformserver 4 and I am trying to set up an ODBC connection so I can import the data to Excel. I have downloaded and installed the Mysql ODBC 5.1 driver but when I try to add the connection it give me an error "Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Host Games' is not allowed to connect to this MySQL server". I have an older version ov excel running on the computer running uniformserver 4 but I have MS Office Home & Student edition on my game machine. How can fix this?
Thanks.
It looks as if your set-up is OK! You receive a response from the server.
User root has been locked down for local access only, if you are not connected to the Internet set root privilege using phpMyAdmin to have a “Host” of any.
Preferably create a new user with restricted privileges and to have a “Host” (note set this when setting name and password) of any. Set this user to have access to the database you wish to use.
Check out this Wiki page (7.1 Add new user) page for details.
All the best
Ric
User root has been locked down for local access only, if you are not connected to the Internet set root privilege using phpMyAdmin to have a “Host” of any.
Preferably create a new user with restricted privileges and to have a “Host” (note set this when setting name and password) of any. Set this user to have access to the database you wish to use.
Check out this Wiki page (7.1 Add new user) page for details.
All the best
Ric
Thanks Ric I will give that a try.
That worked great
Thanks again.
It looks as if your set-up is OK! You receive a response from the server.
User root has been locked down for local access only, if you are not connected to the Internet set root privilege using phpMyAdmin to have a “Host” of any.
Preferably create a new user with restricted privileges and to have a “Host” (note set this when setting name and password) of any. Set this user to have access to the database you wish to use.
Check out this Wiki page (7.1 Add new user) page for details.
All the best
Ric
That worked great
Thanks again.
QUOTE(Ric @ Mar 26 2009, 01:22 PM) 
It looks as if your set-up is OK! You receive a response from the server.
User root has been locked down for local access only, if you are not connected to the Internet set root privilege using phpMyAdmin to have a “Host” of any.
Preferably create a new user with restricted privileges and to have a “Host” (note set this when setting name and password) of any. Set this user to have access to the database you wish to use.
Check out this Wiki page (7.1 Add new user) page for details.
All the best
Ric
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.