Topic: How to set up MySQL

Hi.  First, I am a complete novice when it comes to setting up MySQL.  I have limited experience with Terminal (Command Line) on OS X 10.4.2.

I would like to install PunBB and have actually spent way longer than anticipated, this morning, trying to accomplish the task.  I fully realize that this is due to my ignorance of certain issues.

I have successfully installed PHP 4.0.xx on my OS X Box and have downloaded and installed MySQL 4.0.26, using instructions from Mark Liyanage's pages (entropy).

However, it appears that I need to create an appropriate database to use with PunBB and here is where I am running into trouble.  I can't seem to find the specific Command Line Steps to get this accomplished.  It may actually be a permissions issue.  Here's what I am doing:

Using Terminal:
mysql> CREATE DATABASE punbb
        > I don't know what to type here

I played around with GRANT ALL PRIVILEGES commands (from the MySQL docs), but I really do not understand *what* my intent should be.  Am I trying to create a NEW USER or grant permissions to the existing user? [I have no purpose other than to get PunBB successfully installed].

The point is, I simply want to get PunBB up and running, but the install.php cannot successfully connect to the db.

I guess I need the 'How to install PunBB for Dummies' version. ;-)

Thanks for any assistance.

Scott

2

Re: How to set up MySQL

I've heard good things about MAMP: http://www.mamp.info/

For manipulating your databases: http://www.phpmyadmin.net/

Re: How to set up MySQL

mysql> CREATE DATABASE punbb
        > I don't know what to type here

Try

mysql> CREATE DATABASE punbb;

4 (edited by guardian34 2006-06-26 19:07)

Re: How to set up MySQL

hcgtv wrote:

For manipulating your databases: http://www.phpmyadmin.net/

In addition to phpMyAdmin, I use CocoaMySQL (SBG) and MySQL Administrator. (I occasionally use MySQL Query Browser, but I don't think it's very good yet.)

Edit: Don't forget about the documentation: Post-Installation Setup and Testing

Re: How to set up MySQL

Thanks for all of the suggestions, folks.  Unbelievably, I have successfully launched PunBB.

The docs at: http://dev.mysql.com/doc/refman/5.0/en/ … ation.html also helped me step through the process, with a little more understanding.

6

Re: How to set up MySQL

Cool, good to hear.

What kind of Mac do you have?