How To Create a Database for Mac OS X Server using MySQL

The Example is shown on how to create a MySQL database for WordPress


Run Terminal program.


Step 1:
Password:
Last login: Sun May 30 15:07:50 on console
No home directory: /dev/null
Type: sudo /usr/sbin/

WARNING: Improper use of the sudo command could lead to data loss
or the deletion of important system files. Please double-check your
typing when using sudo. Type "man sudo" for more information.

To proceed, enter your password, or type Ctrl-C to abort.

Password: (enter password)


Type: 
sudo /usr/sbin/serveradmin stop mysql

WARNING: Improper use of the sudo command could lead to data loss
or the deletion of important system files. Please double-check your
typing when using sudo. Type "man sudo" for more information.

To proceed, enter your password, or type Ctrl-C to abort.

Password: (enter password)
mysql:state = "STOPPED"

Type all in one line: 
sudo /usr/sbin/serveradmin settings mysql:rootPassword = yourPWHere mysql:rootPassword = ""


then
shell> sudo /usr/sbin/serveradmin start mysql


Response: mysql:state = "RUNNING"


Note: Step 1 can be replaced with simply stopping MySQL from ServerAdmin on Mac OS X Snow Leopard 10.6 and then resetting MySQL Root Password (MySQL > Settings)


Step 2:
Type:
shell> mysql -u root -p


Response: 
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.88-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

shell>  create database db_wordpress;
Response: Query OK, 1 row affected (0.08 sec)

shell> GRANT ALL ON wordpress.* TO admin@localhost IDENTIFIED BY "YourPWHere";
Response: Query OK, 0 rows affected (0.08 sec)

shell> exit
Bye




------
Help: mySql password Reset: https://help.ubuntu.com/community/MysqlPasswordReset