View previous topic :: View next topic |
Author |
Message |
juliam
Joined: 09 Aug 2008 Posts: 16 Location: Québec Canada
|
Posted: Sat Jul 25, 2009 21:33 Post subject: First Installation of MySQL |
|
|
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 |
|
Back to top |
|
|
juliam
Joined: 09 Aug 2008 Posts: 16 Location: Québec Canada
|
Posted: Sun Jul 26, 2009 0:43 Post subject: |
|
|
(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... |
|
Back to top |
|
|
juliam
Joined: 09 Aug 2008 Posts: 16 Location: Québec Canada
|
Posted: Sun Jul 26, 2009 1:05 Post subject: |
|
|
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 |
|
Back to top |
|
|
juliam
Joined: 09 Aug 2008 Posts: 16 Location: Québec Canada
|
Posted: Mon Jul 27, 2009 21:54 Post subject: |
|
|
this is great
i love that toy
thanks Papillon |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|