Trouble with tutorial

[scarface]

Hi, I have been trying to install nwnx and mysql for neverwinter nights, I am adding the prc and need this installed for the character creator. I have been using this tutorial http://www.nwnx.org/index.php?id=tut2
Now I get to step 6. then it all goes pear shaped from there. I have done everything else that is required yet when i type: "mysqladmin -u root shutdown" it gives me this message:

connect to server at 'localhost' failed
error: 'can't connect to MYSQL server on 'localhost' (10061)'
check that mysqld is running on a localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

Any help would be great thanks

[Papillon]

Depending on the version of MySQL you have installed, you should have a MySQL entry in your start menu. Start the MySQL System Tray Monitor to load the service. You should be able to work with the graphical tools "MySQL Query Browser" and "MySQL Administrator" from there on.
_________________
Papillon

[scarface]

Nope, havent got any of that, this is the filename of the version i am using
mysql-4.1.12a-win32.zip
I am a decent scripter but I am finding it really difficult, maybe its not a very good tutorial if you have no experience with using these programs.

[Acrodania]

In your c:\mysql\bin folder there is a file called "winmysqladmin.exe". I would highly recommend creating a shortcut to it in your startup directory.

This gives you a graphical representation of the MySQL process and allows you to easily start, shutdown and modify your settings plus details on it. It shows up as an icon in your SysTray that looks like a stop light.

Also don't forget to go into your "Services" and setup MySQL to run automatically on start. It will NORMALLY do that itself, but not always.

For working with the database find a copy of MySQL Front version 2.5 Any higher version than that you have to pay for If you can't find a copy by searching the web let me know and I can send one to you....

[scarface]

Ok I did what you told me to on bioware and installed the 4.0 version, I then added a shortcut to my desktop for winmysqladmin and opened it up. straight away I can see a problem, in the MYODBC window it says:

Not Found
Driver 3.51 Not Found

[Acrodania]

This is normal, the ODBC driver is a secondary download. You don't need it for NWNX as long as you use MySQL-Direct Connect in the NWNX.INI file. If you are familiar with ODBC setups or have issues with the Direct Connection then you can download that driver from the MySQL site as another way to connect....

Can you see the mysql database while in winmysqladmin.exe? (right-click on the stoplight, select Show Me) If so you are talking

Next thing you will need to do is make a database for the system to connect to. You can use the command line or a utility like MySQL-Front. Once you have a database setup (and tell the NWNX.INI file which one to use) you should be able to use the aps-demo.mod and have it make a table for you. You can use that table as a template for others you might decide you need. I have a bunch, for quests, PCInfo, creatures, treasure, etc.....

[scarface]

Yeah I see it, its blank though, and as for the aps demo, well its not retrieving the data.