Can you administer MySQL running on RHEL from a PC remotely?

anon091 · 10-17-2013, 12:48 PM

I'm not very db savvy, so this is probably an easy question. But we have an apache server that also runs MySQL that stores data from some web forms.

I'm assuming there's something I could install on my Windows machine to connect to the database with the same credentials the .php web page forms do, but I'm really not sure what I would download and install to do that?

dugan · 10-17-2013, 12:50 PM

phpmyadmin
adminer

Habitual · 10-17-2013, 01:32 PM

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>

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

anon091 · 10-17-2013, 02:15 PM

Thanks guys. Is one better, or more popular/widely supported, than the other? I only heard of phpmyadmin before (not like I knew what it did though obviously)

anon091 · 10-17-2013, 03:41 PM

One other question as I look at these, do they require that you have MySQL and Apache running on your local machine that you would use to connect to the servers?

Habitual · 10-17-2013, 03:55 PM

Using toad, you can access either remote or local.

myPhpAdmin would run on the same host as the database and you'd access that from your home pc over http or https.
There's Security to consider as vuln scans frequently try to scan for default installs and then try to attack those installs.

I suppose it is possible to have myPhpAdmin installed locally and run it against a remote db, but I don't use that tool. Sorry.

Maybe someone else can chime in on that issue...?

anon091 · 10-17-2013, 04:04 PM

oh ok, I had myphpadmin backwards then kinda, you put it on the server then just access it through a browser.

out of fear of messing anything on the server up, maybe toad is the way to go, that sounds like more what I was looking for, something to put not on the server to access the db on the server.

Habitual · 10-17-2013, 04:36 PM

Yeah, toad as a mysql client would be my advice.

anon091 · 10-17-2013, 04:42 PM

Cool, thanks. I'll give it a shot.

Habitual · 10-18-2013, 09:25 AM

You are very welcome.

Doug G · 10-18-2013, 11:42 AM

You can also use mysql's own mysql workbench.

anon091 · 10-18-2013, 01:33 PM

Does that let me do everything remotely like Habitual said toad does?

Habitual · 10-18-2013, 01:40 PM

probably, and just as Free.

https://dev.mysql.com/downloads/tools/workbench/

anon091 · 10-18-2013, 01:42 PM

Cool. I will install both, see how they go. thanks for the ideas guys.

Habitual · 10-18-2013, 01:46 PM

Glad to be of help.

Good luck!