Zeoslib Portal

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

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

Sorry, my english.

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. 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

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.

riedere wrote: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!