Author Topic: Can MySQL running on RHEL from a PC remotely?  (Read 629 times)

akash.datasoft

  • Green Belt
  • *****
  • Posts: 216
  • Karma: +0/-0
Can MySQL running on RHEL from a PC remotely?
« on: October 17, 2013, 05:00:36 PM »
Can MySQL running on RHEL from a PC remotely?


toad is good, and FREE.

but first, you'll need permission to connect, so on the db host, open mysql as root and once there issue this or a similar command:


grant all on <dbname>.* to '<your_connect_id_or_name>'@'<yourip>' identified by '<dbpassword_to_connect_here>'; flush privileges; exit;


so...
to illustrate the example using:
Code:

grant all on openfire.* to 'jessejames'@'My.hou.se.ip' identified by 'ranoutofbullets'; flush privileges;exit;



then you'd connect from your host as
mysql -ujessejames -pranoutofbullets -h<ip_of_db_server>

or setup Toad using
user: jessejames
pass: ranoutofbullets
db: openfire
dbhost: <Ip_of_db_server>


Your dbname will be the one you want to work with.
Have fun.

silgy

  • Green Belt
  • *****
  • Posts: 224
  • Karma: +1/-0
Re: Can MySQL running on RHEL from a PC remotely?
« Reply #1 on: October 18, 2013, 03:29:27 AM »
Hello.......

toad is good, and FREE.

but first, you'll need permission to connect, so on the db host, open mysql as root and once there issue this or a similar command:
Code:
grant all on <dbname>.* to '<your_connect_id_or_name>'@'<yourip>' identified by '<dbpassword_to_connect_here>'; flush privileges; exit;
so...
to illustrate the example using:
Code:
grant all on openfire.* to 'jessejames'@'My.hou.se.ip' identified by 'ranoutofbullets'; flush privileges;exit;
then you'd connect from your host as
mysql -ujessejames -pranoutofbullets -h<ip_of_db_server>

or setup Toad using
user: jessejames
pass: ranoutofbullets
db: openfire
dbhost: <Ip_of_db_server>

Thanks
Silgy