hi... saw your post with your remote mysql issues...
a number of issues/question need to be answered... to begin, are your machines (client/server) linux/windows boxes? is iptables/firewall app running on either or both boxes? what version of linux/windows/mysql are you running? how are you attempting to connect to the mysql/server from the client? do you have complete access to change/modify the mysql database tables on the mysql server machine? i'm not sure of your background, but when you understand the issues surrounding remote database access, it's really not that hard to setup. you just need to be careful, because there are things that can screw you up. when you get the answers to the above questions, i can try to help you get everything setup to do a remote access. basically, to setup mysql for remote access, requires that you grant permission/privs to a given user(s) for a given database/table. this process can be as restrictive/open as you want!! which for security, means you have to start knowing what you're doing, if you're going to allow the mysql server/your client app access to the outside world! in the mean time, check out >>http://dev.mysql.com/doc/mysql/en/Default_privileges.html. it discusses the art of setting privs/granting privs for users/databases. good luck/let us know the answers.... -bruce -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 2:27 AM To: [EMAIL PROTECTED] Subject: i cant connect to mysql from other machine hello people.. i have a curious problem with mysql. i configure root user acount to enable access from other machines but i cant connect.. my user table is: mysql> select * from user; +-----------+------+------------------+-------------+-------------+--------- ----+-------------+-------------+-----------+-------------+---------------+- -------------+-----------+------------+-----------------+------------+------ ------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+------+------------------+-------------+-------------+--------- ----+-------------+-------------+-----------+-------------+---------------+- -------------+-----------+------------+-----------------+------------+------ ------+ | localhost | root | 1595fd346d9734fe | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | root | 1595fd346d9734fe | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | +-----------+------+------------------+-------------+-------------+--------- ----+-------------+-------------+-----------+-------------+---------------+- -------------+-----------+------------+-----------------+------------+------ ------+ 2 rows in set (0.00 sec) i execute the flush privileges sentence. i try to connect from another machine and this is the error: $ mysql --host linuxready -uroot -p Enter password: ERROR 2003: Can't connect to MySQL server on 'linuxready' (111) Maybe is it possible that I have to configure some attribute in my.cnf? thanks in advance d2clon -- 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]
