Hi this is probably long overdue and I've seen a whole bunch of folks asking how to set up a MySQL connection string to connect from an external (not on localhost) client to a MySQL server. My code is C# but you can see how the string is comprised.
Here are a couple things I found to be the troublesome point:
Firstly, when you connect you are using the machines IP address, unless you have a domain name, and a port.
Second, when you specify the connection string in your program you need to differentiate between Server and Host.
If you use a connection string with Host
conn =
newMySql.Data.MySqlClient.MySqlConnection("Host="+
host + ";Port="+
port + ";Database="+
dbase + ";Uid="+
username + ";Pwd="+
password);
then you need to create the user on the MySQL server as being on the localhost machine.
CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
host in this case is the IP address and when MySQL does its security it checks for localhost in the user table and not machine name.
If you use a connection string with Server
conn =
newMySql.Data.MySqlClient.MySqlConnection("Server="+
host + ";Port="+
port + ";Database="+
dbase + ";Uid="+
username + ";Pwd="+
password);
then you need to create the user on the MySQL server as being on the machine-name machine.
CREATE USER 'user'@'machine-name' IDENTIFIED BY 'password';
host in this case is the IP address and when MySQL does its security it checks for machine name not localhost.
So for you:
Dim con As String = "server=localhost;Uid=root;Pwd='';Database=mflcar"
should be
Dim con As String = "host=localhost;Uid=root;Pwd='';Database=mflcar"
if you have defined the user on MySQL to be on the host "localhost" and not "machine-name".
Hope this clears up the mystery with using Host or Server in your connection string.
