Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 947
  • Last Modified:

Grant access to remote IP address using (SSH)

hi experts,

how can I Grant access to remote IP address lets say (33.33.33.33) to mysql ?

regards,
0
uk1900
Asked:
uk1900
  • 2
1 Solution
 
raminhosCommented:
Try the code above..

but, y ou must insure that you have port 3306 open in firewall and / or router..



#mysql -u root -p mysql
 
mysql> GRANT ALL ON foo.* TO bar@'33.33.33.33' IDENTIFIED BY 'PASSWORD';
 
mysql> update db set Host='33.33.33.33' where Db='webdb';
 
mysql> update user set Host='33.33.33.33' where user='webadmin';
 
mysql> exit

Open in new window

0
 
uk1900Author Commented:
thx man
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now