[ 你說我打 ] [ 技術文件 ] DBDesigner4.0.5.6_Full & PhpMyadmin Conflict

(***此文章內容已經過原作者同意發佈。)

Environment

Window 7

WAMP package 2.2 x64.

(apache 2.2.21, php 5.3.10, mysql 5.5.2, xdbug 2.1.2, xdc 1.5, phpmyadmin 3.4.10.2)

Introduction

DBDesigner 4 is a best ER Model drawing tool.

It’s a visual database design system that integrates database design. 

And it’s a open source project available for M$ window 2000/ xp and linux.

It’s release on the GPL.

Question

DBDesigner 4 can’t work.

When DBDesigner4 can work, (maybe you find some solution with google) my phpmyadmin can’t work.

Why?

Answer

Because the DBDesigner4 is use old version mysql password authentication methods.

When you want to use DBDesigner, you must change your password to old password type.

So, when you change your password to old type, your phpmyadmin password can’t pass.

First, you should open your mysql command line.

And input your password.

If you success login, screen like this

If you success login mysql, you can start to input syntax.

Syntax with open/close

-- close phpmyadmin, open dbdesigner4

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD  ('YOUR PASSWORD');

UPDATE mysql.user SET Password = OLD_PASSWORD ('YOUR PASSWORD')

WHERE Host = 'localhost' AND User = 'root';

FLUSH PRIVILEGES;

-- open phpmyadmin, close dbdesigner4

SET PASSWORD FOR 'root'@'localhost' = PASSWORD ( 'YOUR PASSWORD');

UPDATE mysql.user SET Password = PASSWORD ('YOUR PASSWORD')

WHERE Host = 'localhost' AND User = 'root';

FLUSH PRIVILEGES;

-- close phpmyadmin, open dbdesigner4 
SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('YOUR PASSWORD');
UPDATE mysql.user SET Password = OLD_PASSWORD('YOUR PASSWORD') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;

-- open phpmyadmin, close dbdesigner4 
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('YOUR PASSWORD');
UPDATE mysql.user SET Password = PASSWORD('YOUR PASSWORD') WHERE Host = 'localhost' AND User = 'root';
FLUSH PRIVILEGES;

Author : Shiou

延伸閱讀：[ 你說我打 ] [ 技術文件 ] Upload your PhpMyadmin with WAMP package
                    [ 你說我打 ] [ 技術文件 ] Cake php 2.1 + window 7 install note