MySQL server configuration

[Nobody/Anonymous]

Hello
I'm testing Direct SQL with Kylix 3 on Mandrake 9.0.
My MySQL server seems to be ok (I use it with Apache + PHP, or directly via the mysql command). But I cannot connect to the server with the demo given on this website:
error on connect: Access denied for user: 'jusob@localhost.localdomain' (Using Paswword:YES)

All the settings look right (login, paswword, port, server=localhost).

So, I wonder if I need to have a special configuration for my MYSQL server to make it work with Direct SQL.

Julien

[Cristian Nicola]

HI there!
Looking at your problem (i do not have kylix around) i wonder if it is not a problem with strings/wide strings and so on. Direct-mysql as in this version assumes you are passing pchars (eg #0 terminated strings) and if your strings are short strings or whatever .. then the chances are that somehow either the user or password would then be passed incorrectly. Just for further testing try to
a) create a test user with no password and try to connect - if this works it may be the case something is wrong with the password
b) create a pchar (var p:pchar) and assign the password to it and pass it in the demo.

Regards,
Cristian Nicola

[Nobody/Anonymous]

Thank you.
I tired with a user without password. I now can connect to the server. But then, I cannot select any table. I will work on it.

Thank you
Julien