remote connection to mysql

[guaranteed]

Bruce Chapman (dbdsales@gtcom.net and 8505844551) wrote: I am trying to connect to MySQL database from my business system. I have added hosts as follows to Mysql.
192.168.0.1 which is my router IP
192.168.0.110 which is my system on the network 65.166.224.125 which is what I get from "whatismyip.com" which I beleive is my ISP,s IP.
I am using port 3306
For host I am using guaranteed-sales.biz
When I try and connect I get the following error:
"access denied for user 'bruce66'@pdsl -65-166-224-125.gtcom.net password yes "
I am using a dlink router and a Visionnet DSL modem w/o firewall It may be something simple but Im lost, any help appreciated. This is the same error I get trying to access through any program I try, Navicat,MySQLFront, etc
Bruce

 

[KarveR]

you need to add a user to mysql whos host is pdsl -65-166-224-125.gtcom.net this will fix your problem.

*note : you may also need to add this to the hosts, also rembemer to flush the hosts after making any changes,
command line is:
mysqladmin reload

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[guaranteed]

I went to control panel and then mysql. I added a user pdsl -65-166-224-125.gtcom.net to all databases and I also added the above to the hosts.Probably not what you ment. I also tried to ping the host and it times out, can not ping.
Is it possible I need to use ssl tunnel?
Thanks again for your time. Bruce

 

[lgarner]

You're making a good connection to the server since the error message is from MySQL.

You need to add yourself @pdsl... to the mysl.user table.

grant all on *.* to bruce@pdsl -65-166-224-125.gtcom.net identified by 'password'

Then, try "mysql -h hostname -u bruce -ppassword" to connect.