[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 958
  • 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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