MySQLTalk.org

Ritu Sinha · Guest

Hi,

I just downloaded the latest version of DBDesigner 4
from fabFORCE.net (v4.0.5.6) and installed it on
Windows. I already have MySQL server installed and
running on my machine. When I try to connect to MySQL
DB, it asks me for the Username (root) and password. I
use the same root password that I use for the MySQL
Administrator (and it works), however, I keep getting
"dbExpress: Invalid Username/password" message. Can
someone please help??

Thanks,
Ritu

Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html

Berman, Mikhail · Guest

Hi Ritu,

The last time, I have solved this problem by converting password for a
user that is used to connect from DBDesigner to MySQL to an old pre-4.0
passwords type. Someone in one of MySQL lists posted solution a few
months ago.
For conversion use, from MySQL manual:

"Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:

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

Regards,

Mikhail Berman
Ives Inc
(508)476-7007 ext.27
[email]mberman (AT) ivesinc (DOT) com[/email]

-----Original Message-----
From: Ritu Sinha [mailto:ritu2p (AT) yahoo (DOT) com]
Sent: Friday, May 20, 2005 12:35 PM
To: [email]gui-tools (AT) lists (DOT) mysql.com[/email]
Subject: DBDesigner 4 connection problem with MySQL DB

Hi,

I just downloaded the latest version of DBDesigner 4 from fabFORCE.net
(v4.0.5.6) and installed it on Windows. I already have MySQL server
installed and running on my machine. When I try to connect to MySQL DB,
it asks me for the Username (root) and password. I use the same root
password that I use for the MySQL Administrator (and it works), however,
I keep getting
"dbExpress: Invalid Username/password" message. Can someone please
help??

Thanks,
Ritu

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:
[url]http://lists.mysql.com/gui-tools?unsub=mberman (AT) ivesinc (DOT) com[/url]

Ritu Sinha · Guest

Hi Mikhail,

Thanks for your help ... it works!

--ritu

--- "Berman, Mikhail" <mberman (AT) ivesinc (DOT) com> wrote: