Remote MYSQL login


#1

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?


#2

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