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

Question

My connection string looks like 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 my understanding, this means MySql should be using 'logan'@'localhost' for the login, but it isn't.

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

Access denied for user 'logan'@'HP-PL-ML110.young.home'

I'm at a loss right now. SqlYog doesn't allow me to create a user with that hostname, my options for hostname are %, localhost or 127.0.0.1

Can anyone help me make sure that the website is using the specified username here? I have no idea what to look at to fix this

Have you tried disabling host name lookup, as in [this question](http://stackoverflow.com/questions/5118151/mysql-error-cant-get-hostname-from-your-ip-address-whats-the-problem) — Joe, Jul 19 '13 at 15:34
@Joe that helped, only now it's trying to use the server's IP address... at least I can work with that, will update again in a few minutes — Ortund, Jul 19 '13 at 15:41
@Ortund looks like your connection string is not using the `Data Source` — bansi, Jul 19 '13 at 15:45

score 1 · Answer 1 · edited May 23 '17 at 12:03

Joe's comment:

Have you tried disabling host name lookup, as in this question

Applying this didn't fix the issue but it did change the settings so that I could use the IP address in the connection string.

This does mean I had to create a new user (I found that, in Sqlyog, you can enter something different in the hostname field in user creation) and grant the new user the required permissions on the target database.

It's not exactly a solution, but it is a viable workaround that's got me back to a point where I can actually progress further in my development now.

Thanks Joe

score 0 · Answer 2 · answered Jul 19 '13 at 15:27

0

string connStr = String.Format("Data Source={0};Initial Catalog={1}; User Id={2}; Password={4};", server, database, user, pass);

Should be

string connStr = String.Format("Server={0};Database={1};Uid={2};Pwd={4};", server, database, user, pass);

answered Jul 19 '13 at 15:27

bansi

55,591
6
41
52

I'm pretty sure they amount to the same thing? – Ortund Jul 19 '13 at 15:30
I don't know if `Data Source` exists in connection string. Never used it. – bansi Jul 19 '13 at 15:38

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

2 Answers2