MySQL using Notes

1. How to export the database of MySQL

• Go to command line, use "CMD"
• CD C:\Program files\mysql\mysql Server 5.5\bin
• mysqldump-hx.x.x.x (IP)-p3306-uroot-pxxx db_nls > D:/db_nls.sql
• Finish the export, SQL file is Db_nls.sql

2. How to import the database of MySQL

• Go to command line, use "CMD"
• CD C:\Program files\mysql\mysql Server 5.5\bin
• mysql-hx.x.x.x (IP)-uroot-pxxx

• Create a database "test" by MySQL Workbench
• mysql> Use test
• Mysql> Source D:/db_nls.sql
• Finish the import.

Or

• mysql-hx.x.x.x (IP)-uroot-pxxx-p3306 Db_nls < D:\db_nls.sql

3. How to convert ACCESS database to MySQL

• Use the Tool:access2mysql

1. Difference between MySQL and Access

• Store escape characters are different. MySQL needs to convert the string, "\ \" to "\\\\", "'" to "," and access simply translates "'" "" ".

4. How to set Mysql support multiple language

• Modify the My.ini which is located in MySQL installed folder
• Set "Default-character-set =utf8", "Character-set-server=utf8"
• Restart MySQL Service

5. How to change the password of user:root in MySQL

• Go to command line, use "CMD"

• CD C:\Program files\mysql\mysql Server 5.5\bin
• mysqladmin-uroot-padmin Password xxx