LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-17-2013, 01:48 PM   #1
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,668

Rep: Reputation: 46
Can you administer MySQL running on RHEL from a PC remotely?


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?
 
Old 10-17-2013, 01:50 PM   #2
dugan
LQ Guru
 
Registered: Nov 2003
Location: Canada
Distribution: Slackware
Posts: 7,006

Rep: Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529Reputation: 2529
phpmyadmin
adminer
 
1 members found this post helpful.
Old 10-17-2013, 02:32 PM   #3
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,164
Blog Entries: 10

Rep: Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979
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.
 
1 members found this post helpful.
Old 10-17-2013, 03:15 PM   #4
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,668

Original Poster
Rep: Reputation: 46
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)
 
Old 10-17-2013, 04:41 PM   #5
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,668

Original Poster
Rep: Reputation: 46
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?
 
Old 10-17-2013, 04:55 PM   #6
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,164
Blog Entries: 10

Rep: Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979
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...?
 
1 members found this post helpful.
Old 10-17-2013, 05:04 PM   #7
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,668

Original Poster
Rep: Reputation: 46
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.
 
Old 10-17-2013, 05:36 PM   #8
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,164
Blog Entries: 10

Rep: Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979
Yeah, toad as a mysql client would be my advice.
 
1 members found this post helpful.
Old 10-17-2013, 05:42 PM   #9
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,668

Original Poster
Rep: Reputation: 46
Cool, thanks. I'll give it a shot.
 
Old 10-18-2013, 10:25 AM   #10
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,164
Blog Entries: 10

Rep: Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979
You are very welcome.
 
Old 10-18-2013, 12:42 PM   #11
Doug G
Member
 
Registered: Jul 2013
Posts: 595

Rep: Reputation: Disabled
You can also use mysql's own mysql workbench.
 
1 members found this post helpful.
Old 10-18-2013, 02:33 PM   #12
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,668

Original Poster
Rep: Reputation: 46
Does that let me do everything remotely like Habitual said toad does?
 
Old 10-18-2013, 02:40 PM   #13
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,164
Blog Entries: 10

Rep: Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979
probably, and just as Free.

https://dev.mysql.com/downloads/tools/workbench/
 
1 members found this post helpful.
Old 10-18-2013, 02:42 PM   #14
rjo98
Senior Member
 
Registered: Jun 2009
Location: US
Distribution: RHEL, CentOS
Posts: 1,668

Original Poster
Rep: Reputation: 46
Cool. I will install both, see how they go. thanks for the ideas guys.
 
Old 10-18-2013, 02:46 PM   #15
Habitual
LQ Addict
 
Registered: Jan 2011
Location: Youngstown, Ohio
Distribution: LM17.1/Xfce4.11.8
Posts: 7,164
Blog Entries: 10

Rep: Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979Reputation: 1979
Glad to be of help.

Good luck!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
remotely installing rhel server 6 remotely jwenzel09 Red Hat 2 10-24-2011 09:22 AM
Can we install RHEL 5.3 remotely ? agent_mach Linux - Newbie 2 12-31-2010 01:08 AM
LXer: Administer servers remotely with Web Console LXer Syndicated Linux News 0 05-02-2008 01:50 PM
Log in to mysql remotely chamalsl Linux - Security 6 03-23-2005 02:40 PM
How to remotely administer RedHat 7.2 using Windows 2000 Daemen Linux - Newbie 2 06-04-2004 03:41 PM


All times are GMT -5. The time now is 02:45 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration