Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
DBDesigner 4 connection problem with MySQL DB

DBDesigner 4 connection problem with MySQL DB

2005-05-20       - By Berman, Mikhail

 Back
Reply:     1     2     3  

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 (See http://pre-4.ora-code.com).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 (See http://pre-4.ora-code.com).1 style for each user that needs to use a
pre-4 (See http://pre-4.ora-code.com).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
mberman@(protected)

-- --Original Message-- --
From: Ritu Sinha [mailto:ritu2p@(protected)]
Sent: Friday, May 20, 2005 12:35 PM
To: gui-tools@(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/gui-tools?unsub=mberman@(protected)


--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/gui-tools?unsub=mysql@(protected)