Re: DBDesigner 4

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
> 
> 
> 
> 		
> __________________________________ 
> Discover Yahoo! 
> Find restaurants, movies, travel and more fun for the weekend. Check it out! 
> http://discover.yahoo.com/weekend.html 
> 
> 

-- 
Michael Zinner, GUI Developer
MySQL AB, www.mysql.com
Office: +43 676 753 26 30

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

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]