I have the next problem

[Dav1d]

Hello

I'm just installed zeos in delphi 7 , and I'm using an exemple (I make some changes) .


I complete this :

protocol : mysql4.1
database : mydatabase
host : myweb.com
port 3306
username : myusername (the same to enter phpmyadmin)
password : mypassword ( " ")

And when try to connect , I have this message :

SQL Error: Access denied for user 'myusername@11.11.11.11' (using password:YES)

note : ip 11.11.11.11 is not real , it's just for show you

What I have to do ?

I want to say that if I try to connect to local in my pc , it works

Thanks in advance

David

[baloghi]

Hi!
This problem Mysql connection problem and not Zeos or Delphi problem.
Check mysql connection property in mysql administrator.

Sorry, my english.

[mdaems]

Hi,

This is a mysql connection problem, indeed. I would advise you to try connecting using mysql console (mysql.exe in mysql distribution) with exactly the same combination of host, user, password, port, database name.

Code: Select all

mysql -h<hostname> -u<username> -p<paswword> -P<port number> -D<databasename>

When this works it should also be possible to connect using Zeoslib
Maybe the user you provided does not have the privileges to connect from the given IP.

Mark

[riedere]

Today I installed zeos with D2006.
Made a test connection for a sample application.
And the same Failure occours.

This Failure is when Mysql's user has only local access eg localhost.
If you use phpmyadmin then create a new user with Host % (any host)
Do not forget to set the access rights only to the whished Database.

[baloghi]

Today I installed zeos with D2006.
Made a test connection for a sample application.
And the same Failure occours.

This Failure is when Mysql's user has only local access eg localhost.
If you use phpmyadmin then create a new user with Host % (any host)
Do not forget to set the access rights only to the whished Database.

D2006 and Zeos previus version god.

Sorry my englis!