MySQL user creating and allow connecting from custom IP

About

MySQL user creating and allow connecting from custom IP

Login

At first login to mysql database as root
type this into terminal:

mysql -u root -p 

When issue such commands:

To create user

                               enter ip
CREATE USER 'enterusername'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'enterpassword';

To set all privileges

To set Privileges

                                                     enter ip
GRANT ALL PRIVILEGES ON mor.* TO 'enterusername'@'xxx.xxx.xxx.xxx' WITH GRANT OPTION ;

Now you can connect from your entered ip to mysql.
If you still can not connect check or port 3306 is open

nmap -sS -O 127.0.0.1

if port 3306 is not open. You need open port:

Open MySQL port

iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

Save iptables configuration:

service iptables save

Connecting from remote server

mysql -u <enter username> -h <database server ip address> -p

See also

• Mysql read only User