Need help getting excell to connect to sql server on another machine.

[rforeman]

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.

[Ric]

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

[rforeman]

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