Some MySql Questions

(1).  Forgot password
===================
Modify password:

1. Open cmd
2. C:/Program Files/MySQL/MySQL Server 5.0/bin>Net stop mysql
3. C:/Program Files/MySQL/MySQL Server 5.0/bin>mysqld-nt --skip-grant-tables
4. Open new cmd
5. C:/Program Files/MySQL/MySQL Server 5.0/bin>mysql.exe
6. use mysql
7. update user set password=password("new_password") where user="root";
8. flush privileges;
9. exit
10. restart mysql server

 

(2).  Import exception

==============================
java.lang.IllegalArgumentException: Packet is larger than max_allowed_packet from server configuration of

Added max_allowed_packet=64M in my.ini .

 

 

(3).  Restore error

=======================
When restore the dbdump use MySql Administrator tool , will throw error message.

But use common line :  mysql restor the db dump is ok:

C:/Documents and Settings/Administrator>cd "c:/Program Files/MySQL/MySQL Server
5.0/bin"

C:/Program Files/MySQL/MySQL Server 5.0/bin>mysql -u root -p xwikiApp< "d:/
letian/Maintain Project/LiveRun/xwikiApp.sql"
Enter password:

 

=> If dbdump is bigger, need modify:

 

max_allowed_packet=256m

wait_timeout=2888000000
interactive_timeout=2888000000