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??
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;"
-----Original Message----- From: Ritu Sinha [mailto:ritu2p@yahoo.com] Sent: Friday, May 20, 2005 12:35 PM To: gui-tools@lists.mysql.com 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??
--- "Berman, Mikhail" <mberman@ivesinc.com> wrote:> 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;">
-----Original Message-----> From: Ritu Sinha [mailto:ritu2p@yahoo.com] > Sent: Friday, May 20, 2005 12:35 PM> To: gui-tools@lists.mysql.com> 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??>
haha, same here, i encounter this problem last time and i had uninstalled this software. today i installed DBdesigner again but that problem still remain. But now i have solved the problem from this thread. thanks lot
Thanks for the info really usefull, I was woundering why it wasn't working. Now it work, hope to found why MySQL Workbench always crash now, so I can transfer my stuff to it. Thanks again.
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
