VS or MySQL adds a new user entry into mysql.user with no pe

daki · Post by **daki** » Thu 04 Jan 2007 19:59

After working in VS 2005 and Core Lab Developer Tools 1.70 I will receive an error that user [email protected] cannot connect. This user is somehow added to MySQL's user table while I am working with VS. The normal entries I have in the user table are where the host has "localhost" or "%". The entry with my machine name is added dynamically during my work session with VS.

Does anyone have a solution for this?

Thanks,
Dave

Alexey · Post by **Alexey** » Fri 05 Jan 2007 13:32

Please describe the problem in detail. When will you receive it?

daki · Post by **daki** » Fri 05 Jan 2007 17:30

I have worked with MySQL for a long time without issue. In my MySQL DB, in the mysql database and the user table I have two entries. One is for a localhost and the other is for remote hosts. The remote host entry has "%" in the host field to indicate that from any box I as a user will use those permissions.

What happens in this scenario is that I am working in Visual Studio and I connect to MySQL in the DB tools that allows me to retrive data, edit stored procedures and so on. After some undetermined amount of time I will no longer be able to work in Visual Studio and look at the data. I then get on MySQL as a different user, root, and check for the entries in the mysql.user table and I will find an entry for myself at a machine address without any privileges.

It looks to be adding this entry dynamically to MySQL, it is not something that I or anyone else added manually and it only happens using Visual Studio.

Alexey · Post by **Alexey** » Fri 05 Jan 2007 18:01

Try to reproduce this problem having MySQLDirect .NET uninstalled.

daki · Post by **daki** » Fri 05 Jan 2007 19:28

For me to access a MySQL database from Visual Studio I need to have MySQLDirect .NET. I recently uninstalled in and re-installed the latest version though.

I use DBExplorer to do the work from within Visual Studio.

Alexey · Post by **Alexey** » Tue 09 Jan 2007 07:02

After working in VS 2005 and Core Lab Developer Tools 1.70 I will receive an error

Can you reproduce this error having MySQLDirect .NET uninstalled?

daki · Post by **daki** » Tue 09 Jan 2007 07:53

Isn't MySQLDirect required to connect to a MySQL database? If I uninstall it how do I connect?

Alexey · Post by **Alexey** » Tue 09 Jan 2007 08:12

Core Lab Developer Tools is supposed to work independently from MySQLDirect .NET.

daki · Post by **daki** » Tue 09 Jan 2007 17:43

There are two pieces of software installed, "Core Lab MySQL Developer Tools ..." and "Core Lab MySQLDirect Data Provider ...". Are you saying I should remove the data provider and the DBExplorer tools should still be able to connect?

daki · Post by **daki** » Tue 09 Jan 2007 17:53

Sorry. To my astonishment after removing the MySQLDirect .net data provider DBExplorer still worked.

I am now guessing that this points to the "Core Lab MySQL Developer Tools"?

Is then the data provider the class files that are then linked with any developed application?

Do you require me to work without the data provider until this issues shows again?

Alexey · Post by **Alexey** » Wed 10 Jan 2007 06:54

Yes, try to reproduce the problem without MySQLDirect .NET data provider installed.

daki · Post by **daki** » Wed 17 Jan 2007 17:19

Yes. I was able to reproduce the issue without MySQL Direct. Another fact of this is ...
1. I first connect successfully with user - " 'daki'@'%' "
2. After working with DBExplorer for a while I get a lost connection alert.
3. I then go to connect again and then I get an error saying I cannot connect with " 'daki'@'uszgi0060.zgi.com' ".

This user 'daki'@uszgi0060.zgi.com' is now in the user table without any permissions and without a password which was not entered by any person but solely thru the interaction of VisualStudio-dbexplorer and MySQL 5.0.