creating users

dgbowen · Post by **dgbowen** » 02.11.2005, 00:05

Dear Friends,
I'm using Delphi 7.1 and MySQL 5.
I have been unable to connect. Delphi complains that the user is invalid and the database is unknown.

Does that mean that both user and database must exist before you can connect?
Thank you for your help in advance.

-Don

Post by **mdaems** » 03.11.2005, 10:39

Dear dgbowen,

First thing to do for you is getting your mysql server up and running. Once you have connected to the server using mysql.exe, I think you will be able to connect using zeoslib as well. I think you first need an introduction on Mysql. See mysql doc directory.

Succes,

Mark

pol · Post by **pol** » 04.11.2005, 09:33

Hi!
A user has to exist before he can connect, evidently. You have to create him first. The easiest way to do that would be using MYSQL Administrator. Best to create the database right now too (under Catalogs) and grant the new user rights to it. Mark is right, now try it out with mysql.exe on the command line: mysql <new user> (-p if the user has a password). When mysql lets you in, write "use <database>" to see if the user has access to it.

HTH
Rüdiger