Solved

MySQL on XServe

Posted on 2008-10-22
5
1,288 Views
Last Modified: 2013-11-12
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.
0
Comment
Question by:rowejd
5 Comments
 
LVL 39

Expert Comment

by:Eoin OSullivan
Comment Utility
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)
0
 
LVL 12

Author Comment

by:rowejd
Comment Utility
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.
0
 
LVL 1

Expert Comment

by:Schandor
Comment Utility
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.
http://www.servercodex.com/archives/2003/07/02/phpmyadmin-on-mac-os-x/
http://www.experts-exchange.com/Database/MySQL/Q_22455669.html
0
 
LVL 39

Accepted Solution

by:
Eoin OSullivan earned 300 total points
Comment Utility
You can download phpMyAdmin (http://www.phpmyadmin.net/home_page/downloads.php) 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 (http://mysql.navicat.com/) which are really excellent for managing MySQL installations
0
 
LVL 4

Assisted Solution

by:DJDecay
DJDecay earned 200 total points
Comment Utility
MySQL comes as a part of OS'X Server,

First Verify MYSQL is  set up to run Via the

->Applications -> Server -> MySQL Manager.app


Then after setting the root password via the same app.

Open
>Applications>Utilities>Terminal

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

and you're in the SQL promter.



0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In certain circumstances, a Microsoft Office mac application may fail to save a document to a network server, with the following error message: "There has been a network or file permission error. The network connection may be lost." An article at…
Deploystudio is a system which can be used to deploy OSX clients and servers within the small/medium or large business environments. The system is built ontop of the OSX Server NetBoot system and uses images & workflows as its core assets. Although …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now