Solved

MySQL on XServe

Posted on 2008-10-22
5
1,300 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
ID: 22783821
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
ID: 22785307
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
ID: 22786607
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
ID: 22787668
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
ID: 22809863
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Would like to record audio portion of Skype Video Call on Mac 2 85
User Permissions on OS X 10.12 Sierra 3 156
Mac OS X 10.7.5 Login Loop 17 104
Mini Mac disk problem 7 31
Are you new to OS X?  This helpful advice could get you quickly up to speed if you are making the transition from windows or totally new to OS X. Finder gives you the visual connection between you and the files located on the hard drive of your A…
If you other experts are anything like me you are always looking into and testing out new features. While I was doing some research one day I ran across an app that I installed on my Mac and used as a security system. Mac OS X: SecureHome uses your …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

813 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

17 Experts available now in Live!

Get 1:1 Help Now