Ok thought I would have a look at DBDesigner4 as MyWorkbench seems to be taking a long time to get into beta. DBDesigner4 looks a great product but couldnt get it to connect to mysql 5 then realised that it the designer was designed for version 3 mysql and lots of the old mysql products need to read the myql.user table for id’s etc.
Tried the old trick of using the OLD_PASSWORD function and seems to work what you need to do is this….
1. Open the mysql command prompt.
2. SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('rootpassword');
UPDATE mysql.user SET Password = OLD_PASSWORD('rootpassword') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;
all in one line – hit return.
3. Try dbdesigner4 again and you should now be able to connect.
Dear Paul,
I tried the commands, but for first command
I am getting an error message as no matching information found and second query got executed but in third query it had again given an error and in DBDEsigner I got the error as invalid username/password
regards
Amol Kulkarni
Dear Paul,
I had retried it, and it it had really worked for me
thanks a lot
regards
Amol Kulkarni
Wow thats great Paul,
i’ve searchd the web but found nothing….and your solution works really great. Thanks a lot
greetings from germany
Denis
Good work buddy, Thanks alot
Thank you m8
Thanks, Paul, great work!
Problem with DBDesigner4 and MySQL is are solved at various places on the web. However I will post my experience with Username/Password invalid error: I was trying to create a database connection. I created users with null password or same username and password. But nothing worked. Then I started looking for other options provided in the database connection manager. One option worked: select ‘Localhost’, it will ask root password, supply mysql’s root password. Then click over mysql and then create the connection. The username and the password created for mysql will work here.
Another issue is related to the lock file while resetting password using following command line option ‘mysql –user=root –pass mysql’. You need to start mysql server and then this will not show lock error.
Thankyou for the attention.
THank you! Works great!
It works! Thanks a lot.
Greetings from Poland