![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DATABASE
文章平均质量分 53
蒋一个故事
Everybody wants something.
展开
-
mysql查看用户密码、权限等
创建用户mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' -> WITH GRANT OPTION;mysql> CREATE USER 'monty'@'%' IDENTIFIED翻译 2016-05-05 16:17:53 · 11257 阅读 · 0 评论 -
Mysql Memory Allocation
Allocating RAM for MySQL - The Short AnswerIf using just MyISAM, set key_buffer_size to 20% of available RAM. (Plus innodb_buffer_pool_size=0) If using just InnoDB, set innodb_buffer_pool_size to 70% o转载 2016-09-27 11:20:03 · 1083 阅读 · 0 评论 -
How to increase MySQL memory limit?
The question – I have a lot of RAM on my machine. How can I increase the memory limits used by MySQL so that MySQL uses more memory and less virtual memory?There are two MySQL variables that can be use转载 2016-09-27 11:20:52 · 969 阅读 · 0 评论 -
安装mysql 5.7.11
参考:http://dev.mysql.com/doc/refman/5.7/en/binary-installation.html基本流程:作参考(具体还要具体情况具体分析)注:记住bin/mysqld –initialize –user=mysql –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data这条命令执行后的最后一行日志:(类似原创 2016-02-23 15:25:13 · 877 阅读 · 0 评论