Linux Mandrake 9.0 Allow MySQL Remote connect

toro

I installed Mandrake 9.0, including php/ mysql / apache.
Problem: I cannot connect to the mysql database remotely.
The only way to connect is through the machine where MySQL is installed.
Things I did:
- forwarded port 3306 on the router to the local machine with mysql installed;
- through a terminal I requested the status of skipnetworking with the command mysql variables, skip networking is off.;
- also I have made a user with all priviliges who may connect from any host %.

I see that MySQL default uses a socket connection. Should this be tcp/ip? If yes, how can I change this?
Or is the cause of the problem something else?

This is driving me nuts for 1 month now.... Arrh

Please help.

Roy

marconi8

hi, i have same problem, i cannot to connecto to my remote server, connect to mysql.db where all permisions is normally setted like all hosts

maybe you have some solutions

toro

You should flush the priviliges for access.
First add a user for example yourname@%
This means the user: 'yourname' has access to mysql from all ip's/ domains. Don't forget to put in a password. Than you should flush the priviliges, so the user activates.

If it doesn't work try again. Best thing is that you flush the priviliges through a terminal. For instruction look at mysql.com

If you want to use a graphical interface for mysql i recommend Mascon from Scibit, www.scibit.com.

Good luck.