Page 1 of 1
VS or MySQL adds a new user entry into mysql.user with no pe
Posted: Thu 04 Jan 2007 19:59
by daki
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
Posted: Fri 05 Jan 2007 13:32
by Alexey
Please describe the problem in detail. When will you receive it?
Posted: Fri 05 Jan 2007 17:30
by daki
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.
Posted: Fri 05 Jan 2007 18:01
by Alexey
Try to reproduce this problem having MySQLDirect .NET uninstalled.
Posted: Fri 05 Jan 2007 19:28
by daki
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.
Posted: Tue 09 Jan 2007 07:02
by Alexey
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?
Posted: Tue 09 Jan 2007 07:53
by daki
Isn't MySQLDirect required to connect to a MySQL database? If I uninstall it how do I connect?
Posted: Tue 09 Jan 2007 08:12
by Alexey
Core Lab Developer Tools is supposed to work independently from MySQLDirect .NET.
Posted: Tue 09 Jan 2007 17:43
by daki
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?
Posted: Tue 09 Jan 2007 17:53
by daki
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?
Posted: Wed 10 Jan 2007 06:54
by Alexey
Yes, try to reproduce the problem without MySQLDirect .NET data provider installed.
Posted: Wed 17 Jan 2007 17:19
by daki
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.