Difference between revisions of "MySQL user creating and allow connecting from custom IP"
From Kolmisoft Wiki
Jump to navigationJump to search
(Created page with '<br><br> =About= MySQL user creating and allow connecting from custom IP.<br> =='''Login'''== At first login to mysql database as root <br> type this into terminal:<br> mysql -…') |
|||
Line 17: | Line 17: | ||
GRANT ALL PRIVILEGES ON mor.* TO 'enterusername'@'xxx.xxx.xxx.xxx' WITH GRANT OPTION ;<br> | 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> | 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><br> | <br><br> | ||
=='''Open MySQL port '''== | =='''Open MySQL port '''== | ||
iptables -I INPUT -p tcp --dport 3306 -j ACCEPT<br> | iptables -I INPUT -p tcp --dport 3306 -j ACCEPT<br> | ||
Save iptables configuration:<br> | Save iptables configuration:<br> | ||
service iptables save<br> | service iptables save<br> |
Revision as of 16:13, 25 November 2011
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