I can't access mysql from my pc

[agmsoft]

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 '[email protected]' (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

the point it's we have a domain here , and I would like to know how configurated mysql , to access from my pc .

thanks in advance

 

[nobaloney]

To start with:

1) what is zeos

2) what is delphi 7

3) what has this got to do with DirectAdmin?

Jeff

 

[agmsoft]

this got to do with directadmin , 'cause my company has paid a web space here ,so we have some rights to help .

zeos it's a component to access to mysql . The point is it doesn't really matter what it's zeos , the point is that I can't access mysql database in de server from my computer , and what I really want to know is what I have to do to allow straight connection from my pc to the mysql database that I have in this web .

 

[Conrad]

Probably the port 3306 which mysql is listening to is block by the firewall or
the mysql has been set to allow only access from localhost.

Solution 1: open port 3306 in firewall en allow connection from outside.
Solution 2: use software which allow traffic through a ssl or http tunnel
like Navivat or sqlYog.

greetings
Conrad

 

[floyd]

this got to do with directadmin , 'cause my company has paid a web space here ,so we have some rights to help

No you didn't. DirectAdmin does not provide hosting space. DirectAdmin is only the control panel. If you are still having trouble with mysql then consult your hosting company. DirectAdmin cannot help you with the problem you are having.

 

[nobaloney]

this got to do with directadmin , 'cause my company has paid a web space here ,so we have some rights to help .

As noted by floyd, you have not paid for webhosting from DirectAdmin; DirectAdmin is not a hosting company. You may have paid for webhosting from a company using DirectAdmin, but that doesn't mean you'll get good answers from the DirectAdmin community; we have no idea how the server hosting your domain is configured.

zeos it's a component to access to mysql . The point is it doesn't really matter what it's zeos

Sure it does. Until you tell me, for all I know, zeos may be a dishwasher. I have no idea why it can't access your server.

the point is that I can't access mysql database in de server from my computer , and what I really want to know is what I have to do to allow straight connection from my pc to the mysql database that I have in this web .

You'll have to ask your hosting company; we have no idea how they've set up their server. Conrad's points are well-taken but it's possible that the port(s) you need are blocked by your hosting company. Or that they specifically don't allow their databases to be accessed directly from outside their server.

I strongly suggest you contact your hosting company, as arrogance here just isn't going to get you the help you obviously need.

Jeff