Help needed.

I am trying to connect to mySQL using dbExpress - TSQLConnection. Have
set the DriverName to LIBMYSQL.DLL (using the DLL from the MySQL/Win
distribution). Tried to connect - no go: "Cannot load LIBMYSQL.DLL".
Tried putting LIBMYSQL.DLL in the current dir, in a path dir,
specifying the exact pathname in the DriverName property - again the
same...

With Interbase it works better, but the condition is for a free SQL
server for at least 20 users, and the free IB is limited to 5... :-(

Any ideas?

Thanks in advance,

HTH

Ralf

I have the same Grigor problem... unable to load libmysql.dll... :(

ideas?

Fabio

Change to use mySQL 3.23.53, you problem will solved.

Originally posted by Grigor Gatchev

I've got the same problem, "Cannot load LIBMYSQL.DLL" and I'm using
mySQL 3.23.53 and I'm running the 'mysqld-nt.exe' service/server.

I'm also using same dbExpress - TSQLConnection and I've tried changing
the path and whatnot, but still no luck.

Anyone have step by step process of getting Delphi 6 and mySQL talking
using the dbExpress controls???

Thanks,

Breakerbox

Try putting LIBMYSQL.DLL on C:\WiNNT\System32 Folder.

-------------------------------------
I've got the same problem, "Cannot load LIBMYSQL.DLL" and I'm using
mySQL 3.23.53 and I'm running the 'mysqld-nt.exe' service/server.

Hi Breakerbox,

Delphi 6 have dbexpress driver dbexpmys.dll for support mySQL
3.22.xx only.

If you updated the Delphi 6 patch 2, you will have a new driver
dbexpmysql.dll for support mySQL 3.23.53

If you want to support mySQL 4.0 beta, you can download the new driver
dbexpmy4.dll at the following URL

http://community.borland.com/article/0,1410,28590,00.html

Hope it can help u.

Martin Choi

Originally posted by Breakerbox

I've got Delphi 6, patch 2.  I will try this again tonight, and
clarify exactly what version of mySQL I have.  If it still does not
work I will try with mySQL 4.0 Beta and see if that works.

Thanks for the info!!

Breakerbox

Hi, All,

I am using TSQLConnection in delphi 7, I do have the same problem when I
used it with mySQL 4.0.6 gamma version.

I solved it, you may do the same steps as I did.

1. download dbexpmy4.dll first.
2. changed the property of LibraryName from dbexpmysql.dll to
   dbexpmy4.dll.
3. copy libmysql.dll from \mysql\bin to \windows\system32 directory.

then the problem will no longer exist any more.
However, I am new to mysql 4.0.6 gamma, I was prompted to enter username
and password after the problem solved, but I don't know what the exactly
username and password are. Therefore, I have a problem about login.

So, if you kown how to login successfully, please let me know.

Thank you.

Alex Pan

User: root
and leave password empty!!

procedure TformDBConfig.CreateRootPass(Sender: TObject);
begin
  With qConfig do  //qConfiq is a Query - replace yourpassword with
whatever you like
  Try
    Sql.Clear;
    Sql.Add('UPDATE USER SET PASSWORD=''yourpassword'' WHERE
USER=''root''');
    ExecSql;
    transConfig.Commit;
  Except  { If an error occurs, the User Not updated tell me }
    on E: Exception do
    begin
      Showmessage(E.Message);
      MessageDlg('What the ??  An Error.  root password NOT Created.',
        mtError, [mbOK], 0);
    end;
  End;
end;

{I like this one because it's the Interbase default}
procedure TformDBConfig.CreateSysdba(Sender: TObject);
var TheString : String;
begin
  With qConfig do
  Try
    Sql.Clear;
    TheString := 'GRANT ALL PRIVILEGES ON *.* TO sysdba@localhost
IDENTIFIED' +
      'BY ''masterkey'' WITH GRANT OPTION';
    Sql.Add(TheString);
    ExecSql;
    transConfig.Commit;
  Except  { If an error occurs, the User Not Created tell me }
    on E: Exception do
    begin
      Showmessage(E.Message);
      MessageDlg('What the ??  An Error.  sysdba user NOT Created.',
          mtError, [mbOK], 0);
    end;
  End;
end;

HTH,

Hi Ak,

Thank you very much for your suggestion.
I have tried that user name and the password, but it does not work.
I set root user's password by using mysqladmin program. Unfornately, it
doesn't work, either.

I tested the username and password on a dos box, so I am sure the user
name and password are correct, then I went back to delphi 7 and tried
the same name and password, but... I always got invalid
username/password information.

If you login  successfully, could you tell me the information? Your
mysql version, OS and delphi version information will be helpful to me.

Thank you.

Hi, John Kebert,

Thank you very much for your suggestion, I will use it when I solved
this login problem.

Sincerely,
Alex Pan