[FX.php List] [Off-topic] How to create a mySQL DB on my web server

[Derrick Fogle]

I would recommend either WebMin http://www.webmin.com/download.html  
(the Unix tar/gzip is what you want), or if you can enable PHP for  
your Mac's webserver (Apache), you can run PHPMyAdmin http://www.phpmyadmin.net 
. PHPMyAdmin has served all my MySQL admin needs except for exporting/ 
backing up large databases, which WebMin does quite well. Sometimes  
I'll end up using one of the above tools to make a database and basic  
table structure, but then export that and use BBEdit to flesh out  
table structure definitions, then upload the modifications. If you've  
got a fair amount of table/field definition work to do, text  
processing is way more powerful and efficient than the "click and  
peck" of GUI's <cough, FileMaker, cough>.

Bottom line: don't be scared of MySQL. Structured Query Language has  
been around for many years now, it's stable and well defined, and it  
works. >INSERT INTO databaselanguages SET language='SQL';

On Nov 16, 2007, at 8:16 PM, Bob Patin wrote:

> I'm woefully uninformed about how to work with MySQL, but have a  
> messageboard that I have to install for a client, and it uses MySQL.
>
> Could anyone on this list tell me how to go about creating a  
> database on my web server (Mac OS X Server Tiger)? I've got MySQL  
> running, but just don't know how to create a database, and the  
> messageboard requires that I have one created and running before I  
> can finish configuring it.
>
> I seem to recall a Mac app that did this sort of thing I downloaded  
> CocoaMySQL, but can't make heads or tails of it. It doesn't want to  
> connect to my web server no matter what I try.
>
> Thanks for any help; back-channel might be a good idea...
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> Member of FileMaker Business Alliance and FileMaker TechNet
>
>  CONTACT US VIA INSTANT MESSAGING:
>     AIM or iChat: longterm1954
>     Yahoo: longterm_solutions
>     MSN: tech at longtermsolutions.com
>     ICQ: 159333060
>
> --------------------------
> Contact us for FileMaker hosting for all versions of FileMaker
> PHP • CDML • Full email services • Free DNS hosting • Colocation •  
> Consulting
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list