I have MySQL 3.23.52 server running on 192.168.1.1. This behavior seems to be strange for me: In mysql client runned on 192.168.1.1 I set these commands:
CREATE DATABASE pokus1; GRANT ALL PRIVILEGES ON pokus1.* TO [EMAIL PROTECTED] IDENTIFIED BY 'heslo'; GRANT ALL PRIVILEGES ON pokus1.* TO pokus1@'%' IDENTIFIED BY 'heslo'; Then I leave the client and I try to call mysql client under new created user: mysql -u pokus1 -pheslo pokus1 It connects succesfully to server. So I try this: mysql -h 192.168.1.1 -u pokus1 -pheslo pokus1 it gives: ERROR 2013: Lost connection to MySQL server during query but from another machine the same command connects. How to set up GRANT permissions to be able to connect with IP both locally and remotely? Thanx in advance P.S.: this works on Linux RedHat 8.0 and IRIX 6.5.x (but on SGI I have some 4.x version of MySQL). On AIX 4.3 with MySQL 3.23.51 the mysql command with -h option connects. -- Potrebujete vice prostoru pro vase stranky? Ptejte se na http://sluzby.volny.cz/cs/product/ftp_paid -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
