Aric,
Are you running the linux version of your database on a shared web host?
Some web hosts prevent you from using % as a host identifier for security
reasons. I would also check to see if the permissions were defined at the
proper level (in other words, have you set up access prvis for a specific
database only, or did you grant access to all databases?) Globally-defined
privileges will be listed in the user table of the mysql database and
permissions set for a specific DB will be in the db table.
You might also check that the mysql server is not protected by a firewall
(ask your web host.) One last thing to check: The hostname identifier must
be surrounded by either single or double quotes, NOT backticks. The
following is an example that works under MySQL 4.0.13:
grant all on *.* to myusername@'%' identified by 'mypassword';
I hope that helps--I don't normally connect to MySQL through ODBC.
-Rob
-----Original Message-----
From: Aric Cheah [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 3:36 AM
To: [EMAIL PROTECTED]
Subject: Connection problem!!! Windows to Linux
Hi there:
I need URGENT help about this ..
I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under linux, and create the same database, same
user and password. But when I connect the error message said:
[MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to
connect to this MYSQL Server.
But form the database, I added the host "%", means hsould be allow any
host... anyone can help me on this? the application I wrote will be
using with dynamic IP everytime user dial-up to the internet connect..
wish to hear some help soon..
--
Best,
Aric Cheah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
