I had trouble getting MySQL GUI Adminstration tools to connect to my XAMPP installed MySQL database server on Mac OS X. This solution may help people who have the same problem and don’t know how to figure it out.
I’m working on a Mac with OS X 10.5.7 and a fresh XAMPP 1.0.1 install. XAMPP gives your OS X a complete Apache, MySQL and Perl/PHP installation to work with. With it, you can develop on your Mac with a complete web server. (Sure, Mac comes with most of this stuff built in, but XAMPP is really nice and allows you to have your Mac web services turned off for security.)
XAMPP also comes with phpMyAdmin for managing your MySQL server through a web page. I find phpMyAdmin to be awesome for most of what I do with a database. Sometimes I need to revert to command-line for large datafiles and stuff, but I’d say 99.9% of the time I can use phpMyAdmin for what I’m doing. I ran into a problem with phpMyAdmin trying to view a database table that was imported from an Excel export. For some reason, the phpMyAdmin page is just plain white – making me think there was some web/parsing/display problem involved. I needed a different way to view the DB. For this kind of thing I hate the command line. (The line wrapping…blech!)
Continue reading “How do you get MySQL Administrator GUI to work with XAMPP on Mac OS X?”
You must be logged in to post a comment.