Create a new database in MySQL

[hot4robots]

I havent done this in awhile. Things have gotten pretty complicated. All I want to do is start NWNX with a MySQL database.

Is there anyone willing to walk through the right software to download to run a server and create a new database? 4-5 years ago it was pretty simple in a GUI. Now I cant find anywhere where you actually create a database. Just talk about instances and schemas. If someone could point out a tutorial on how to get it started Im sure I could do the rest.

[metamud]

http://www.mysqltutorial.org/

Or specifically about creating tables:
http://dev.mysql.com/doc/refman/5.1/en/create-table.html

This may sound incredibly sick, but have you tried Google?

If I enter trivial queries like "mysql tutorial" or "mysql create table" there's a vast array of examples, tutorials, howtos and what-not to choose from....

If you're going to use NWNX, you're going to have to do some of the "finding out" yourself, and there really is an enormous amount of examples you can work your way through, almost all of which should at least get you started!

Good luck!

[Fireboar]

Essentially, all you need is mysql. If you're using Windows, I'd strongly recommend the XAMPP package. It's like a MySQL/Apache server bundle. Fairly compact, but it gets the job done and provides a tool that makes it really easy to make databases. Open the control program and start both Apache and MySQL, then open your web browser and point it to http://localhost/phpmyadmin/

If you're using Linux, the easiest way is to install apache2, mysql-server and phpmyadmin. To do this on Ubuntu (Debian is similar), type at the terminal:

[Bal]

If you go with XAMPP you should know that it's intended for dev only and can leave your database open to attack. It's very good to set up a database and start playing around, but you shouldn't use XAMPP for anything that people you don't know can have access to..

[Zebranky]

I just cleaned up an old tutorial I helped write and put it up for you at http://mercuric.net/NWN/mysql.html. Hope it helps
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?

[Fireboar]