MySQL性能建议者:mysqltuner.pl
[root@even ~]# wget http://mysqltuner.pl/mysqltuner.pl[root@even ~]# chmod +x mysqltuner.pl [root@even ~]# cp mysqltuner.pl /home/mysql/一些简单的命令可从 --help 查阅[mysql@even ~]$ ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with \'--help\' for additional options and output filteringPlease enter your MySQL a
MySQL 权限管理的注意事项
㈠ 认证和授权 认证:who am I ? 授权:what I can do ? 认证实际上就是一个验证凭证的过程、而进入MySQL 需要出示的凭证有:host、username、password 连接MySQL 常见有 2 种: ① TCP/IP 连接 加 -h 参数、通过TCP/IP 连接MySQL 实例、mysql.user 对来者
从安装开始谈 MySQL 安全
当你安装 MySQL 完后、会有个提示:[root@localhost Desktop]# rpm -ivh MySQL-server-5.5.28-1.rhel5.i386.rpmPreparing... ########################################### [100%] 1:MySQL-server ########################################### [100%]PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !To do so, start the server, then issue the following commands:/usr/bin/mysqladmin -u root p