The company assigned me to be the DBA of a new project. However, it will be using MySQL. One of their requirements is to have the ERD in the database. Being a newbie with MySQL, I searched the internet for software that would create an ERD. Luckily, MySQL has DB Designer 4.
After installing it and creating an ERD, I tried to save it in the database but I got an error message:
dbexpress Error: Invalid username/password
Researching again, all the documents say it has something to do with the versions of Designer4 and the database (we were using MySQL 5.1). But they suggested to reset the password using the OLD_PASSWORD function. Thus, after issuing the command:
mysql> set password for ‘username’@'hostname’=OLD_PASSWORD(’password’);
The ERD was successfully saved in the database.
After installing it and creating an ERD, I tried to save it in the database but I got an error message:
dbexpress Error: Invalid username/password
Researching again, all the documents say it has something to do with the versions of Designer4 and the database (we were using MySQL 5.1). But they suggested to reset the password using the OLD_PASSWORD function. Thus, after issuing the command:
mysql> set password for ‘username’@'hostname’=OLD_PASSWORD(’password’);
The ERD was successfully saved in the database.
No comments:
Post a Comment