Re: DBDesigner 4 - Michael G. Zinner - com.mysql.lists.gui-tools

4 messages in com.mysql.lists.gui-toolsRe: DBDesigner 4

From	Sent On	Attachments
Daniel Diaz	06 Jun 2005 00:24
Michael G. Zinner	06 Jun 2005 01:27
Berman, Mikhail	07 Jun 2005 10:59
Daniel Diaz	07 Jun 2005 17:13

Subject:	Re: DBDesigner 4
From:	Michael G. Zinner (mzin...@mysql.com)
Date:	06/06/2005 01:27:11 AM
List:	com.mysql.lists.gui-tools

Daniel,

best create a new user in the MySQL Administrator and name him dbd4. Apply changes.

Then, right click the user in the User Accounts list and select [Add host from which the user can connect]. Enter localhost. Apply changes. This will add a new host to the user. Select the new localhost entry and and give it full global privileges. (you have to activate the global privileges in the options)

Now select the main entry (not the new localhost entry) and right click again. Select [Remove host from which the user can connect] and press apply changes.

Now you have created a new dbd4 user that can only connect from localhost.

Now start Query Browser. Execute

SELECT * FROM mysql.`user` u

to get a list of all user account on your server. There should be one entry like.

'localhost', 'dbd4', '*DBC24926E0821352A2CE9593D8909FBFFE85CA74', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0

Now do a

UPDATE mysql.user SET Password = OLD_PASSWORD('dbd4') WHERE Host = 'localhost' AND User = 'dbd4';

And execute a

FLUSH PRIVILEGES

Now you will see that the length of the password has changed

'localhost', 'dbd4', '727e0335017e3abd', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0

The MySQL server is now using the old passwords schema for this user.

Now try to connect from DBDesigner4 again, using the new dbd4/dbd4 account.

Mike

p.s. Make sure your server is running on port 3306 or DBDesigner will not be able to connect.

Daniel Diaz wrote:

Hi everyone,

I am facing a similar problem that Ritu faced last month (May 20, 2005) regarding the DBDesigner 4. Apparently, the solution (from Mikhail) is not working for me. Could anyone please point me at what I am doing wrong?

Here's what I am doing:

I created an user granting all him permissions. I then used the 'update mysql.user set password ... ' command to change the user's password. MySQL returned 'rows 1 changed 1 warnings 0'. But I get a '0 row affected' message when I execute the 'flush privileges' command.

Anyway, I still cant connect to MySQL from the DBDesigner 4 interface. I am still getting the dbExpress Error: Invalid userid/password.

The MySQL server is running on the localhost.

Thanks, danny

Are you MySQL certified? www.mysql.com/certification