Re: DBDesigner 4

Thanks Michael, it worked!

danny

--- "Michael G. Zinner" <[email protected]> wrote:

> 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
> 



		
__________________________________ 
Yahoo! Mail Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 

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