Mysql connect Topic is solved
Mysql connect
Hello, how to connect a mysql database from only two with a specific ip?
Re: Mysql connect
You can use hostname in grant statements as well, as you are using shared ip then you can limit it with hostname specific grant such as below
To allow from all IP's/hosts
For localhost only
Code: Select all
grant all on db.* to 'user'@'hostname' identified by 'password';
Code: Select all
grant all on db.* to 'user'@'%' identified by 'password';
Code: Select all
grant all on db.* to 'user'@'localhost' identified by 'password';