[Debian]How to allow(only ip) remote connection to mysql?

Ivo2

How to allow remote connection to mysql

Valentine

Hello,
first you have to comment out this line in "/etc/mysql/my.cnf":
#bind-address = 127.0.0.1

Then you have to login to your MySQL server:
mysql -u root -p

And grant privileges to connect remotely to database for user from IP with password:

mysql> GRANT ALL ON database.* TO user@’1.2.3.4’ IDENTIFIED BY ‘password’;

Ivo2

Valentine said:

Hello,
first you have to comment out this line in "/etc/mysql/my.cnf":
#bind-address = 127.0.0.1

Then you have to login to your MySQL server:
mysql -u root -p

And grant privileges to connect remotely to database for user from IP with password:

mysql> GRANT ALL ON database.* TO user@’1.2.3.4’ IDENTIFIED BY ‘password’;

IP 1.2.3.4 on my other server or host mysql ip?
my vps(mysql) = 1.1.1.1
my other server(gaming host) = 2.2.2.2

Valentine

You should change 1.2.3.4 IP to your remote host IP address which will connect to you MySQL server.