MYSQL question

BlitzMax Forums/Brucey's Modules/MYSQL question

Sanctus

(Posted 2009) [#1]

Hey guys
I'm using the dbmysql mod to connect to a mysql server.

I installed wamp.(php+mysql+phpmyadmin and everything)
In bmx I have this code

Global Database:TDBConnection = LoadDatabase("MYSQL", "database", null,0, "Admin", "admin")

I created a database named "database" and a account named Admin and with a password "admin"
I copied libmySQL.dll in the project folder
Somehow it database keeps getting null.
What's more to do than that?

Winni

(Posted 2009) [#2]

Is 'database' even a valid database name? After all, 'database' is a SQL keyword.

Does the user admin have access privileges to the database database?

==> Grant all privileges on database.* to 'admin'@'localhost' identified by 'admin';

What are the 'null' and the '0' for? In the default settings, MySQL listens on port 3306 to requests.