Some MySql Questions

最新推荐文章于 2024-08-31 18:53:42 发布

letian_w

最新推荐文章于 2024-08-31 18:53:42 发布

阅读量848

点赞数 1

CC 4.0 BY-SA版权

分类专栏： My SQL 文章标签： mysql exception server cmd user import

本文链接：https://blog.youkuaiyun.com/letian_w/article/details/5734018

My SQL 专栏收录该内容

1 篇文章

订阅专栏

(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