MySQL on XServe

A server admin just bailed as we were about to set up MySQL on our XServe machine.  We have the latest OS edition, but I have no idea how to set it up...add databases, tables, etc.  I know enough MySQL code to do this with command line, but don't even know how to get to command line on the XServe to be honest.  I'm a developer, not a server admin, so I need some basic help here.  Thanks!

Oh, and in case it helps, I'm using Mac OSX from my house to access the XServe through a little application called Server Admin.
LVL 12
Who is Participating?
Eoin OSullivanConnect With a Mentor ConsultantCommented:
You can download phpMyAdmin ( and unzip it
Place the folder in the root of the website and edit the configuration file inside the PhpMyAdmin folder to have the domain, port and username passwords for MySQL

Alternatively there are a few programs such as NaviCat ( which are really excellent for managing MySQL installations
Eoin OSullivanConsultantCommented:
MySQL is already there. Just go to Applications/Server/MySQL Manager to access it.

The command line is accessed via a program called Terminal (located in Applications/Utilities)
rowejdAuthor Commented:
I do see that, but using Terminal, is there a way I could install a service to make life easier?  Such as installing phpMyAdmin on the server?  How would I go about doing that?  Sorry for my ignorance.
Perhaps this will help in setting up phpmyadmin on OS X
I believe the current OS X server comes with Apache but I'm not sure about the PHP.  I have gotten phpmyadmin working on an older version without too much trouble.
DJDecayConnect With a Mentor Commented:
MySQL comes as a part of OS'X Server,

First Verify MYSQL is  set up to run Via the

->Applications -> Server -> MySQL

Then after setting the root password via the same app.


$mysql -u root -p <enter>
<type in the password>

and you're in the SQL promter.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.