Recommend substitute for phpMyAdmin (connection problems)?

I just upgraded to Mojave on my Mac. I’ve been trying to get PHP, MySQL and phpMyAdmin installed and configured. Unfortunately, I can’t connect to my database with phpMyAdmin. I think it has something to do with a config.inc.php file, but I’ve given up trying to troubleshoot it.

Anyway, can anyone recommend a software program that can do what phpMyAdmin does but doesn’t rely on the config.inc.php file? In other words, something that can connect directly to my MySQL database?

Thanks.

I’ve made a topic to help users install PHP more easier on all operating systems. Here is a link.

Thanks, but that’s over my head. I’ve been wading through this stuff all weekend. Apparently, the config.inc.php problem is pretty common, and a lot of people on various forums haven’t solved it. So I just want to move on to something that works.

I guess I can always download some MySQL software and see if they work. I just wondered if anyone has any recommendations before I jump in. Thanks.

My entire thread is all in video and demonstrates how to exactly install each packages on Windows, Linux, and Mac. This is the entire complete installation that I normally do on all of my devices. There is no need to have any technical skills to follow along with the videos.


Your main problem also isn’t phpMyAdmin if you can’t connect to the database. It’s the database itself which is why you should attempt to watch the videos before you start saying that it’s too technical for you to handle.

OK, I’ll check it out. Thanks.

Click on the v icon on the right of the link I posted to expand the topic and you can watch those videos for Mojave. I have created videos for each individual Mac version.

Hmmm… I can’t get the videos to work. I tried a couple times, and either nothing happens or the web page becomes unresponsive, and I get a warning that it’s using too much memory.

Here’s the full link.

https://www.sitepoint.com/community/t/installing-the-php-environment-spaceshiptrooper/320645/3?u=spaceshiptrooper

If it still doesn’t work, here’s the Youtube playlist.

https://www.youtube.com/watch?v=cuE8-YszQAE&list=PLj1Ut5Njs4XwJ3ywgCH6c57GTAqUuSnYv

The link starts to render, shows a black square then hangs.

iPad mini, Safari browser

1 Like

LOL - I just downloaded a program called SequelPro. It apparently connected to MySQL and let me create a database, but now I’m trying to figure out where that database is located. If I can copy my old database files into it, then I can see if I can make a connection on a local website.

Downloading random things just to substitute it for your problem won’t fix your problem. If you really want to fix your problem, then I suggest starting small and working your way up. Downloading random software from the internet isn’t going to solve your problem. SequelPro and many software like MySQL Workbench can be installed and it can show you that you’re “connected”, but it’s not solving your actual problem. If those software aren’t connected to your actual database, then you’re still back where you first started. This time, with random softwares installed and making it even more messier. So I suggest to follow directions before you make it worse for yourself. People who often don’t follow directions tend to make it worse for themselves by installing random software that are pretty useless to solve their problem.

Better than paying Apple support people $145 an hour. I’ll have to figure out how to contact some local programming students.

No one on here works for Apple.

You’re still going to end up in this same exact situation. Everyone on here volunteers their time to help others. What I am suggesting is merely a way for you to fix your problem without you having to pay that Apple support that you’re complaining about. The only thing I suggest and recommend is following directions. I didn’t tell you to download SequelPro. But I’m glad you’ve tried. Hopefully it works for you, but if it doesn’t, you just pretty much wasted a bit of time going after something that wasn’t recommended to you.

1 Like

Wow, that’s crazy. I got farther than ever before, but installing PHP/MySQL on a Mac is still a can of worms. Anyway, for any newbies perusing this thread, I decided to go back to MAMP - a very popular program that installs the AMP bundle for you. I was hoping to escape the training wheels, but I’ll leave AMP to the pros. :wink:

I am under the impression that PhpMySql is a completely separate program from PhpMyAdmin. The latter requires the PhpMySql username and password.

Recently PhpMySql has been updated and now has the latest security checks which I have unfortunately struggled but eventually solved the connection.

PHP/MySQL = PHP + MySQL. Yes, phpMyAdmin is different; it more or less links the two. Or is there really a software program named PHPMySQL?

Anyway, I never could figure out why it was so hard to assign usernames and passwords with phpMyAdmin on my local databases when it’s so simple using phpMyAdmin via my online C-Panel.

I don’t know if that’s what you’re referring to in your last paragraph or not.

I’m migrating towards WordPress because I just don’t have time to keep up with programming and databases, but I still need MySQL to power my local websites.

C-panel is not necessary but charges for their simple configuration.

Take a look at the following mysql installation tutorial which I found very good because it is recommended by DigitalOcean.

The final verification steps are essential to ensure PhpMyAdmin user names and passwords are acceptable.

nobody mentioned HeidiSQL? apparently it runs on Macs using something called Wine

Sequel Pro is an excellent MySQL utility that we’ve been used for many years, and which I’d highly recommend. That said, it doesn’t save you from having to learn to deal with MySQL itself and the its implementation in the hosting environment you are living in. Also, your need to be aware that some hosting environments will not let you have access to all functionality related to administration of MySQL itself, such as altering the mysql database itself. That is snot really a practical problem if you understand what you need to do in maintaining your databases.