Need Help With PHPMyAdmin!

Hi--

If you're just looking for an app to help manage MySQL, I happen to like Sequel Pro. It's much easier to install, and I think it's more secure than having phpMyAdmin installed. It's also pretty easy to use.

charlie

MJN1812 wrote:
What's it been? Couple of hours since you answered my last question? Should I expect a bill at this point? 🙂

Na, no bill, not yet anyway: the weather's crummy outside and I'm a bit bored is all.

I might just give the Sequel Pro a shot.

I strongly encourage it. If you have phpMyAdmin on your computer, if you're not careful how it's set up, it can be a way in to your databases. I see people looking for phpMyAdmin in the logs on my servers all the time. If you're installing on your own computer and it's always behind a firewall it's not such a big deal.

One thing. I tried entering http://localhost/phpmyadmin/ into a browser, and it brought me to a Welcome to PHPMyAdmin page, asking for a Username and Password. Also said, Cannot load mcrypt extension. Please check your PHP configuration.

Does that sound like I'm on the right track?

Well, sort of. I'm guessing the errors you're seeing relating to BZip2, ZIP, and mcrypt are because you're using the default PHP install, which doesn't have a very rich set of extensions or modules installed. I'm not that familiar with phpMyAdmin, so I don't know if those errors are important. I'd guess the most important one, that no servers are configured, is just because you haven't gotten the configuration done.

You can install a new PHP5 that has that stuff bundled in, but that opens up a whole new can of worms with Apache.

charlie

You are on the right track. It will run without mcrypt. Did you try logging in with your MySQL root user and password? You will have to make up something in the config file where it says "YOU MUST FILL IN THIS FOR COOKIE AUTH!"

MJN1812 wrote:
As I'm sure you've figured, I'm brand new to PHP, etc., so any thoughts on what the reviewer said about it?

Yeah, what they're talking about is no longer relevant. The newest version, 0.9.7, came out after that review was written and it has the functionality they're talking about.

Basically, there's a program that comes with MySQL called mysqldump that you can use to dump whole databases or tables. Depending on the options you give it, it'll dump the necessary SQL statements used to create all the tables as well as all the contents. That can be really handy, like they said in their review. But it's available now in Sequel Pro, so that's no problem.

And using mysqldump isn't all that hard, anyway, if you did need to use it. In fact, knowing how to use it can be really good for backing up your databases down the road when you have important data. I use mysqldump in cron jobs to back up databases all the time on my servers.

charlie

That is a common problem. Here is the fix --> http://discussions.apple.com/thread.jspa?threadID=1718179

I don't seem to have a php.ini file at all. I guess the version that ships with Snow Leopard doesn't need it. Try deleting, or at least moving, php.ini somewhere else.

etresoft wrote:
I don't seem to have a php.ini file at all. I guess the version that ships with Snow Leopard doesn't need it. Try deleting, or at least moving, php.ini somewhere else.

There should be a php.ini.default in /etc. The usual thing is to copy that default to php.ini:

sudo cp /etc/php.ini.default /etc/php.ini

and then make your changes in there.

charlie

MJN1812 wrote:
Just for clarification.

If /var/mysql/mysql.sock is supposed to appear directly after *mysql.default_socket =*, it doesn't.

Does that mean there is some other problem?

No, those values are empty in the newest versions of the php.ini file. Just edit that file and add the location of your MySQL socket there.

charlie