HI: I need some help on table's privileges, I've read the manual but still don't get it working. Background: I'm working on a windows program which needs to connect to a MySQL database on a linux server using MyODBC32. I've installed and configured MyODBC and MySql as follows: Supposing my linux server has the IP address 192.168.3.1 , my windows client has the IP address 192.168.3.2 and ODBC32 (on windwos client) has the following parameters under User DSN tab: Driver: MySQL WindowsDSN: linuxsvr MySQL host: 192.168.3.1 MySQL database name: water After Installing MySQL on linux I set it up like this: #Installing the grant tables ./scripts/mysql_install_db #Starting daemon ./safe_mysqld --user=mysql & #Setting root password ./mysqladmin -u root password hello #Creating database .-mysqladmin -u root -phello create water #grant all privileges to a user called mortz conected from any node ./mysql -u root -pwater mysql>grant all privileges on water.* to mortz@'%' identified by 'hello' with grant option; This way didn't work, whenever I try to connect from my windows program, after the login prompt from MyODBC a message appears telling me "access denied for user mortz". I tried this way too: mysql>grant all privileges on water.* to mortz@'192.168.3.0/255.255.255.0' identified by 'hello' with grant option; but still doesn't work After I tried to connect from the linux server using the client and same user mortz: ./mysql -u mortz -phello water and I did connect, it means the local privileges are OK but I can't connect from outside. I know there are no tables in the database "water" but that's precicely what I want because I'm creating a program which uploads data (and tables) from dbase4 to MySQL how ever I can't even create tables if I don't get access first... Any help would be appreciated... <Rodrigo Morteo Ortiz> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
