![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
zhouzhoupeng
这个作者很懒,什么都没留下…
展开
-
忘记mysql密码 修改密码方法
1.修改MySQL的登录设置: # vi /etc/my.cnf 在[mysqld]的段中加上一句:skip-grant-tables 例如: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-grant-tables 3.重新启动mysqld 4.登录并修改MyS转载 2016-03-14 17:25:04 · 206 阅读 · 0 评论 -
读高性能mysql笔记
SHOW VARIABLES LIKE "%slow%"; SHOW FULL PROCESSLIST; SET profiling=1; SELECT * FROM `score_cal_unsuccessed`; SHOW PROFILES; SHOW PROFILE FOR QUERY 28; SHOW STATUS; SHOW GLOBAL STATUS; /原创 2016-03-14 17:26:42 · 228 阅读 · 0 评论 -
高性能mysql
SHOW VARIABLES LIKE "%slow%"; SHOW FULL PROCESSLIST; SET profiling=1; SELECT * FROM `score_cal_unsuccessed`; SHOW PROFILES; SHOW PROFILE FOR QUERY 28; SHOW STATUS; SHOW GLOBAL STATUS; //mysqla...原创 2016-02-29 17:23:49 · 105 阅读 · 0 评论 -
忘记mysql密码 修改密码方法
1.修改MySQL的登录设置: # vi /etc/my.cnf 在[mysqld]的段中加上一句:skip-grant-tables 例如: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-grant-tables 3.重新启动mysqld 4.登录并修改M...原创 2016-03-03 09:58:50 · 97 阅读 · 0 评论