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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值