OS X server - phpMyAdmin?

[wicky]

I'm setting up os x server (10.5) for the first time and could really do with a little advice.

I'm used to doing much of my web development on a local MAMP install, and I'd like to replicate a similar set up on the server.

I understand that PHP & MySQL are pre-installed on the server, but I've always done all of my admin via phpMyAdmin so don't really understand where to add a new database.

Can anybody tell me how to install phpMyAdmin in the relevant place, or alternatively, point me towards some other help/ instructions.

Thanks

[michaelsanford]

You can install phpMyAdmin in any location that apache can serve files from.

To add a new database in the command-line, you can, from the shell, run

mysqladmin -u root -p create <database_name>

or, from inside mysql:

create database <database_name>;

Though you do not need to do it as the MySQL 'root' user, but as any user with create permissions.

I must add that I despise phpMyAdmin and do almost all of my database manipulation in the shell. It keeps my brain fresh, especially for correctly and efficiently crafting queries for use in my php apps. If you're a sysadmin, I would recommend spending some more time in the Terminal and getting used to–and comfortable with–the shell.