View source for MySQL user creating and allow connecting from custom IP

<br><br>
=About=
MySQL user creating and allow connecting from custom IP
<br><br>
=='''Login'''== 
At first login to mysql database as root <br>
type this into terminal:<br>
 mysql -u root -p 
When issue such commands:
<br><br>
=='''To create user'''==
                                enter ip
 CREATE USER 'enterusername'@'xxx.xxx.xxx.xxx' IDENTIFIED BY 'enterpassword';
To set all privileges 
<br><br>
=='''To set Privileges '''== 
                                                      enter ip
 GRANT ALL PRIVILEGES ON mor.* TO 'enterusername'@'xxx.xxx.xxx.xxx' WITH GRANT OPTION ;<br>
Now you can connect from your entered ip to mysql.<br>
If you still can not connect check or port 3306 is open <br>
 nmap -sS -O 127.0.0.1<br>
if port 3306 is not open. You need open port:
<br><br>
=='''Open MySQL port '''== 
 iptables -I INPUT -p tcp --dport 3306 -j ACCEPT<br>
Save iptables configuration:<br>
 service iptables save<br>
<br><br>
=='''Connecting from remote server '''== 
 mysql -u <enter username> -h <database server ip address> -p
<br><br>

= See also =

* [[Mysql read only User]]