Help needed in connecting another mysql server from asp

Hi group,

I created a asp program to connect the mysal database server which is in another machine(workingserver) which is connected in our network itself. in the machine i am working i am having a mysql db server (albert). when i am running the program i am getting the error message which is specified below

-2147467259[MySQL][ODBC 3.51 Driver]Host 'ALBERT' is not allowed to connect to this MySQL server.

I am in need of connecting the database server which is running in different server and web application in different server in web. i am using MyODBC-standard-3.51.8-win and the connection string i used is

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=workingserver;DATABASE=mysql; UID=root;PWD=;port=3306"

both database server are running in port 3306( default port ) of their own machines.

Please help me in solving this

"Driver={MySQL}; SERVER=albert; DATABASE=mysql; UID=root; PWD="
when i gave the above connectionstring i can't even connect the localhost because it is telling the error as no default driver found

Please help me. send me email personally or reply to this message
my email id is albertindian2001@yahoo.com

Albert

Have you checked your privileges on the mysql server running on albert? This error often means that the user doesn't have access from the particular location. Check out the privileges system in the docs at mysql.com to get this straightened out.

Hi,

I have given all the previlages by the GRANT sql to the user named root by using the following sql

GRANT ALL on mysql to root IDENTIFIED BY 'password';
It returned no error. when i again tried to connect the server it didn't allowed me to connect.

actually "workingserver" is the name of the server and "albert" is also a name of the server where "albert" is residing in my desktop and "working server" is residing in another desktop which is used by my friend. in my desktop albert server is running on port 3306. i have provided all previlaged for the root again. root is the super user so it has all the previlages by default. I am having some asp files in my desktop virtual directory from which i am connecting the MYSQL server which is in my friends machine. both machines are in the same network. after setting all also i am not getting any result. I am a novice programmer. i used to use SQL Server but now i am turning to mysql after seeing the speed and stablity. This is the first time i am programming for mysql.

Thank you
ALbert

If the mysql server is on your friend's machine, then you'll need to make sure the privileges are correct on his system. Also, you'll need to check not only that the grants are correct, but that the point of origin for connections includes your system. Select * from the users table in the "mysql" database. One of the first few columns should govern where someone can connect from. If your friend is only allowing your user to connect from localhost but you're trying to connect from another system, there's your problem. Update localhost to "%" and flush privileges.