Board index » delphi » Connecting to mySQL database using dbExpress - problems :-(

John Kebe

Delphi Developer
Thu, 16 Jun 2005 10:25:22 GMT

Connecting to mySQL database using dbExpress - problems :-(

Quote
alexpan2002 <mem...@dbforums.com> wrote in message <news:2323733.1041071558@dbforums.com>...
> Hi, John Kebert,

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

> Sincerely,
> Alex Pan

Alex I use ZEOS components - a no brainer, and they are "sort of" free.

http://zeoslib.sourceforge.net/zeos_zdo_main.php

 
Giuseppe Di Martin

Delphi Developer
Fri, 24 Jun 2005 18:06:49 GMT

Re:Connecting to mySQL database using dbExpress - problems :-(


Did you set HostName properly ?

Sincerely,
Giuseppe Di Martino

"alexpan2002" <mem...@dbforums.com> ha scritto nel messaggio
news:2323733.1041071558@dbforums.com...

Quote

> 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

> --
> Posted via http://dbforums.com

alexpan200

Delphi Developer
Sat, 25 Jun 2005 10:24:25 GMT

Re:Connecting to mySQL database using dbExpress - problems :-(


Yes, I did. I set my computer name to 'sp6100' and specify its IP. Then
I used ping command to try if the name works.
The system responsed for both localhost and 'sp6100' name. But I still
can not login to mysql via DBxpress component.

Thank you for your suggestion.

Alex

Originally posted by Giuseppe Di Martino

Quote
> Did you set HostName properly ?

> Sincerely,
> Giuseppe Di Martino

> "alexpan2002"  ha scritto nel messaggio
> news:2323733.1041071558@dbforums.com"]news:2323733.1041071558@d-
> bforums.com[/url]...
> > 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
> > --
> Posted via

    http://dbforums.com/http://dbforums.com

--
Posted via http://dbforums.com

serdar_tari

Delphi Developer
Sun, 26 Jun 2005 06:08:56 GMT

Re:Connecting to mySQL database using dbExpress - problems :-(


use the libmysql.dll for version 4.01 insted version 4.06. Then it
will be ok.

Originally posted by alexpan2002

Quote
> Yes, I did. I set my computer name to 'sp6100' and specify its IP.
> Then I used ping command to try if the name works.
> The system responsed for both localhost and 'sp6100' name. But I still
> can not login to mysql via DBxpress component.

> Thank you for your suggestion.

Alex

--
Serdar TARIN

Posted via http://dbforums.com

John Keber

Delphi Developer
Sun, 26 Jun 2005 06:41:59 GMT

Re:Connecting to mySQL database using dbExpress - problems :-(


Quote
"alexpan2002" <member21...@dbforums.com> wrote in message

news:2354846.1041906265@dbforums.com...

Quote

> Yes, I did. I set my computer name to 'sp6100' and specify its IP. Then
> I used ping command to try if the name works.
> The system responsed for both localhost and 'sp6100' name. But I still
> can not login to mysql via DBxpress component.

> Thank you for your suggestion.

> Alex

> Originally posted by Giuseppe Di Martino
> > Did you set HostName properly ?

> > Sincerely,
> > Giuseppe Di Martino

Hi Alex,

I am using Windows2000pro and I am running mysql as a service.
I had an access denied problem trying to connect with Delphi 6 and it drove
me nuts (not that I'm not already).

Maybe you should try what I tried:
1)  Logged onto mysql at the C:\mysql\bin directory prompt .
(mysql -uroot -p)
2)  I set the host name (mycomputername, in your case sp6100) on mysql, with
the following:
GRANT ALL PRIVILEGES ON *.* TO myuser@mycomputername IDENTIFIED BY
'mypassword' WITH GRANT OPTION;
3) Then I typed "use mysql;", replied database changed.
4) Then I typed "show tables;" and I could see the user table etc.,
5) Then I typed "select * from user;" and I could see the host, username and
encrypted passwords fine, but I still couldn't connect with Delphi.
6) I finally typed "mysqladmin reload" at the C:\mysql\bin directory prompt
and everything worked fine.

HTH,

John

Kurt Annebor

Delphi Developer
Thu, 04 Aug 2005 04:01:27 GMT

Re:Connecting to mySQL database using dbExpress - problems :-(


Hello!
As referred by other postings I had similar problems when connecting to
MySQL-server by aid of dbExpress objects:
MySQL 4.0 DBX error invalid username/Password
after installing Libaray dbexpmy4.dll and usernamn root I eliminated
obove mentioned DBX error but got other problems i.e DBX error Invalid field
type when select * from database.

After reading an interesting article in The Delphi Magazine
www.thedelphimagazine.com/samples/1540/1540.htm
(The 4.0 beta ought to contain a lot of bugs)
I undetook the following measures:

reinstalled MySQL 3.23....
changed Library to dbexpmysql.dll
upgraded my Delphi6 with Update#1, Update#2 and Patch#2
Result: I could access my tables in a MySQL dabase without
problems.

Recommend you to read the article I mentioned.

I hope this would be helpful in some way!

Friendly
Kurt A.
______________________________________________________________

"John Kebert" <johnrkeber...@hotmailDOT.com> skrev i meddelandet
news:3e1b542d$1_6@news.teranews.com...

Quote
> "alexpan2002" <member21...@dbforums.com> wrote in message
> news:2354846.1041906265@dbforums.com...

> > Yes, I did. I set my computer name to 'sp6100' and specify its IP. Then
> > I used ping command to try if the name works.
> > The system responsed for both localhost and 'sp6100' name. But I still
> > can not login to mysql via DBxpress component.

> > Thank you for your suggestion.

> > Alex

> > Originally posted by Giuseppe Di Martino
> > > Did you set HostName properly ?

> > > Sincerely,
> > > Giuseppe Di Martino

> Hi Alex,

> I am using Windows2000pro and I am running mysql as a service.
> I had an access denied problem trying to connect with Delphi 6 and it
drove
> me nuts (not that I'm not already).

> Maybe you should try what I tried:
> 1)  Logged onto mysql at the C:\mysql\bin directory prompt .
> (mysql -uroot -p)
> 2)  I set the host name (mycomputername, in your case sp6100) on mysql,
with
> the following:
> GRANT ALL PRIVILEGES ON *.* TO myuser@mycomputername IDENTIFIED BY
> 'mypassword' WITH GRANT OPTION;
> 3) Then I typed "use mysql;", replied database changed.
> 4) Then I typed "show tables;" and I could see the user table etc.,
> 5) Then I typed "select * from user;" and I could see the host, username
and
> encrypted passwords fine, but I still couldn't connect with Delphi.
> 6) I finally typed "mysqladmin reload" at the C:\mysql\bin directory
prompt
> and everything worked fine.

> HTH,

> John

Kurt Annebor

Delphi Developer
Thu, 04 Aug 2005 03:49:47 GMT

Re:Connecting to mySQL database using dbExpress - problems :-(


As referred by other postings I had similar problems when connecting to
MySQL-server by aid of dbExpress objects:
MySQL 4.0  DBX error invalid username/Password
after installing Libaray dbexpmy4.dll and usernamn root I eliminated
obove mentioned DBX error but got other problems i.e DBX error Invalid
field type when select * from database.

After reading an intersting article in The Delphi Magazine
www.thedelphimagazine.com/samples/1540/1540.htm
(The 4.0 beta ought to contain a lot of bugs)
I undetook the following measures:

reinstalled MySQL 3.23....
changed Library to dbexpmysql.dll
upgraded my Delphi6 with Update#1, Update#2 and Patch#2
Result: I could access my tables in a MySQL dabase without
problems.

Recommend you to read the article I mentioned.

--
Posted via http://dbforums.com

Go to page: [1] [2]

Other Threads