RE: DBDesigner 4 connection problem with MySQL DB

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

-----Original Message-----
From: Ritu Sinha [mailto:[email protected]] 
Sent: Friday, May 20, 2005 12:35 PM
To: [email protected]
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:
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]