c# Mysql + phpmyadmin issue

[elfenliedtopfan55]

ok i have been trying to create a login form for like 3 days now but i cant seem to make a connection to server it comes up with the following error on connection.open()

{"Unable to connect to any of the specified MySQL hosts."}


i do have a webserver connected to my url and a2hosting do have a phpmyadmin option created a db and added in

id

username

password

machineid


but not sure how to get the data for the connection string as i not ever really done this before followed multiple guides to make login screen with MySQL and phpmyadmin but just cant make the connection





what i have as connection string.

server = "xxxx";
database = "elfenliexxxxxx";
uid = "root";
password = "";

string connString;
connString = $"SERVER={server};DATABASE={database};UID={uid};PASSWORD={password};";

conn = new MySqlConnection(connString);
the xxxx parts i have got rid of certain parts, i just not sure how to make connection and how i could get the info to create the string correctly. and not sure where the dump file is ( i assume when you make one there is some way of accessing where it stores all data like ini but not sure if it exists or where it would be if it did exist )

Continue reading...