First Installation of MySQL

[juliam]

First Installation of MySQL

window xp sp2
i got nwnx4 1.09
i go mysql-5.1.36-win32
xp_mysql.ini: server = localhost, user = administrateur, password = , schema = nwnx
nwn2.ini: database=c:\mysql\data, nwnx.ini =-module nwnx_demo_mysql
mysql.cnf in c:\mysql\data (from my-medium.ini): password commented,

for xp_mysql.ini: server = localhost, user = administrateur, password = none, schema = nwnx
or xp_mysql.ini: server = localhost, user = nwn, password = nwn, schema = nwnx
or xp_mysql.ini: server = localhost, user = nwn2, password = nwn2, schema = nwnx4
or xp_mysql.ini: server = oldbox, user = nwn, password = nwn, schema = nwnx

i get this in xp_mysql.txt: Connecting to server localhost, Connection to MySQL server failed: Access denied for user ''@'localhost' to database "nwnx'
or this in xp_mysql.txt: Connecting to server oldbox, Connection to MySQL server failed: Host '192.168.0.193' is not allowed to connect to this MySQL server

Obviously, i need to set a user, perhaps a password and a schema...
Shouldnt i start a service? Shouldnt run an exe file?
it's so obvious when we know but so stupid when we dont
it would be faster if you help me please, did i forget some files?

What i am doing:
i dont know database, first time i check this, after few hours reading, i finally google and download 5.1.36
xp_mysql.dll and demo and runtime vcredist_86.exe, i already had...
i install this on a test server to run it and understand the settings

What i want do:
i want set MySQL on the network and connect the servers to it
i would share that MySQL folder and map a logical drive to access it
and each box would have database=<logical drive>: in nwn2.ini file
i have few boxes and many virtual servers of nwn2
they would all share the same database... classical i bet

to ease the installation of MySQL and a step by step for anyone, someone could stick this and remove unuseful information
i learn alot reading all those posts but after 5 hours, i get tired hehe

....
hahaha
i'm reading the docs...
it's so complicated

[juliam]

(built using mysql-5.0.27 source)

* Log level set to 1 (only errors)
* Connecting to server 'localhost'
* Plugin initialized.
* Registering under function class SQLoff

i put away the first download of MySQL 5.1.36
and i downloaded the one with the installation wizard
then i logged with MySQL administrator
i created a shema and an empty table with one column
shema = nwnx, table = nwn, column = number int(10)
i created a user = nwn password = nwn
hehe

i obviously miss that table in the mysqldemo.mod
but the module on the server connected to something hahaha

then, i logged on that server from the lan
and the guy (mmm.. sorry, i dont remember the name of that vilain hehe)
and the guy says that there's a problem... hahaha

now.. should i modify that demo mod to create column etc...?
i bet that i miss something... i assumed that the test in module loading
would create something...

[juliam]

hahaha
the class was SQLoff, i changed it to SQL
now it works

i opened the toolset to check the test in your module.mod, so i saw that you use SQL as class,
i wonder why xp_mysql.ini had SQLoff instead of SQL?

alright, now i will test many users on the same table...
i just hope that the nezt starter like me doesnt have to go through
all those difficulties

[juliam]

this is great
i love that toy
thanks Papillon