If you manually updated the tables, use flush privileges to inform the DB server of your changes.
Cheers /rudy -----Original Message----- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:23 To: [EMAIL PROTECTED] Subject: Re: Connection problem!!! Windows to Linux Aric Cheah <[EMAIL PROTECTED]> wrote: > > 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.. How did you give permissions? Did you use GRANT statement or edit system tables manually? Show me the output of SHOW GRANTS for this user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
