We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

Finding MySQL on my MacBook and remote MySQL DB access

High Priority
132 Views
Last Modified: 2020-03-09
Finding MySQL on my MacBook and remote DB access

I think I used to access MySQL from the browser (Chrome) on localhost, but I do not recall the exact URL.

Can someone explain how to find MySQL?

Also, I have a developer who will be hosting my website, not yet at AWS, but on an internal server. Can I view that database from my version of MySQL? I would of course need to be given access. I will access the website from an IP address I will be given.

Thanks.
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
You don't want to expose direct database access to the Internet.  If you set up a VPN, you would connect to the remote database lust like a local one.

Pretty sure MySQL doesn't come with browser based access out of the box.  Do you remember installing something like phpMyAdmin?

You normally access mySQL through Workbench or the mysql command line.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
curiouswebsterSoftware Engineer

Author

Commented:
Yes, I had phpMyAdmin installed.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
Then I would defer to the docs?

From a quick Google it looks like: http://server/phpMyAdmin/

Where server is localhost or the ip address of your computer.

Assuming you still have everything installed and running, I would try:  http://localhost/phpMyAdmin/
David FavorFractional CTO
CERTIFIED EXPERT
Distinguished Expert 2019
Commented:
1) Finding MySQL on my MacBook and remote DB access.

Many ISPs block this type of access (listening ports on residential connections).

You can test this simply doing this...

# On your Macbook
nc -l 5555

# On some public machine
nc $your-macbook-ip 5555

Open in new window


If the 2nd nc fails to connect, either your ISP has blocked all listeners or you have a firewall rule blocking the conversation somewhere.

Best to first stop MySQL, then debug your ability to connect to port 3306 first.

2) I think I used to access MySQL from the browser (Chrome) on localhost, but I do not recall the exact URL.

Chrome doesn't speak MySQL raw packet flow.

You must have some tool in between like phpMyAdmin.

There is no way for Chrome to connect directly to an SQL instance, unless you've installed some sort of extension which might do this.

3) Can someone explain how to find MySQL?

This command will show MySQL is running + full path to running instance.

ps auxww | grep mysql

Open in new window


4) Also, I have a developer who will be hosting my website, not yet at AWS, but on an internal server. Can I view that database from my version of MySQL?

Yes.

Here's an example version output, showing latest stable MariaDB running...

lxd: net16-dmarc-work # mysql --version
mysql  Ver 15.1 Distrib 10.4.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Open in new window


5) I would of course need to be given access. I will access the website from an IP address I will be given.

You'll require access to the database itself.

You can also use a phpinfo.php file to show a database version on any site.
curiouswebsterSoftware Engineer

Author

Commented:
thanks
David FavorFractional CTO
CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
You're welcome!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.