Solved

MySQL on XServe

Posted on 2008-10-22
5
1,313 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 40

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 40

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mac won't boot 14 99
Mac users not seeing updated files on web site 3 60
gpupdate /force on a mac, macos Sierra 4 235
MAC OSX 10.10 Yosemite Sharp drivers issue 4 64
Do you come here a lot? Are you lazy like me and don't want to go through the "trouble" of having to click your Dock's Safari icon and then having to click your Experts Exchange Favorites bookmark to get here? Well then this article is for you.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

739 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