[Help]MySql Connection limited

[Bobi]

any know how to limited connection to sql server ?

i mean only from my pc to can be connect to DB  if any other try to connect to my DB to be not allowed

[Zoey76]

Try creating a user binded to specific IP:

CREATE USER 'Bobi'@'YOUR_FIXED_IP' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'Bobi'@'YOUR_FIXED_IP' WITH GRANT OPTION;

[Bobi]

Try creating a user binded to specific IP:

CREATE USER 'Bobi'@'YOUR_FIXED_IP' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'Bobi'@'YOUR_FIXED_IP' WITH GRANT OPTION;

can u give me more info how to do that because i never have work with mysql

[josecarlosfl18]

use mysql console, and copy/paste that code...

 

Or into Query in Navicat

 

replace your:

bobi for your username and

some_pass for your password and

Your_fixed_ip for your ip (xxx.xxx.xxx.xxx)...

[Zoey76]

can u give me more info how to do that because i never have work with mysql

 

[Trance]

Try creating a user binded to specific IP:

CREATE USER 'Bobi'@'YOUR_FIXED_IP' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'Bobi'@'YOUR_FIXED_IP' WITH GRANT OPTION;

 

Also firewall exception for his IP.

[Bobi]

 

 

 

tnx