Remote MYSQL login

Remote MYSQL login

Posted by: dgennetten
Posted on: 2009-09-30 10:48:00

I'm trying to login to a MYSQL server remotely using Tableau (tableausoftware.com)

The login dialog presents these fields
Host: [I put in mysql.mydomain.com]
Port: [I accepted the default of 3306]
Username: [I entered my MYSQL username]
Password: [ MYSQL pw]

It comes back with "Invalid Username or Password"

Using the same credentials, I get in just fine with phpMyAdmin.

What am I doing wrong?

Re: Remote MYSQL login

Posted by: Atropos7
Posted on: 2009-09-30 10:55:00

Login to the DreamHost Web Panel and go to Goodies -> MySQL Databases. Click on the username you are trying to log in as. You need to update the 'Allowable Hosts' option.

Customer since 2000 cool openvein.org

Tags: mysql serverphpmyadmincredentialscom port