c# - MySql access denied for user - can't create the user the software is looking for -

my connection string looks this:

string server = "localhost"; string database = "stman"; string user = "logan"; string pass = "root";  string connstr = string.format("data source={0};initial catalog={1}; user id={2}; password={3};", server, database, user, pass); 

given understanding, means mysql should using 'logan'@'localhost' login, isn't.

it looks though it's using 'logan'@<server's qualified name>:

access denied user 'logan'@'hp-pl-ml110.young.home'

i'm @ loss right now. sqlyog doesn't allow me create user hostname, options hostname %, localhost or 127.0.0.1

can me make sure website using specified username here? have no idea @ fix this

joe's comment:

have tried disabling host name lookup, in this question

applying didn't fix issue did change settings use ip address in connection string.

this mean had create new user (i found that, in sqlyog, can enter different in hostname field in user creation) , grant new user required permissions on target database.

it's not solution, viable workaround that's got me point can progress further in development now.

thanks joe