RE: DBDesigner 4

Hi Daniel,

Reading your E-mail, I see that you are using:

========================================================================
=========================
 "I then used the 'update mysql.user set password ... ' command to
change the user's password."
========================================================================
=========================

I am not sure if you are using OLD_PASSWORD() function as it is
suggested in MySQL documentation:

mysql> SET PASSWORD FOR
>     -> 'some_user'@'some_host' =
> OLD_PASSWORD('newpwd');
> 
> Alternatively, use UPDATE and FLUSH PRIVILEGES:
> 
> mysql> UPDATE mysql.user SET Password =
> OLD_PASSWORD('newpwd')
>     -> WHERE Host = 'some_host' AND User = 'some_user';
> mysql> FLUSH PRIVILEGES;"
> 
> http://dev.mysql.com/doc/mysql/en/old-client.htm 


Mikhail Berman

-----Original Message-----
From: Daniel Diaz [mailto:[email protected]] 
Sent: Monday, June 06, 2005 3:25 AM
To: [email protected]
Subject: DBDesigner 4

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 


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


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