MySQL简单优化

mysql> select user,host from mysql.user;
+------+----------------+
| user | host           |
+------+----------------+
| root | 127.0.0.1      |
| root | ::1            |
|      | localhost      |
| root | localhost      |
|      | mysql\_master1 |
| root | mysql\_master1 |
+------+----------------+
6 rows in set (0.00 sec)

mysql> delete from mysql.user where user='';
Query OK, 2 rows affected (0.02 sec)

mysql> select user,host from mysql.user;
+------+----------------+
| user | host           |
+------+----------------+
| root | 127.0.0.1      |
| root | ::1            |
| root | localhost      |
| root | mysql\_master1 |
+------+----------------+
4 rows in set (0.00 sec)

mysql> delete from mysql.user where host='mysql\_master1';
Query OK, 1 row affected (0.00 sec)


mysql> delete from mysql.user where host='::1';
mysql> select user,host from mysql.user;
+------+-----------+
| user | host      |
+------+-----------+
| root | 127.0.0.1 |
| root | localhost |
+------+-----------+

mysql> drop database test;
Query OK, 0 rows affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

添加额外管理员
grant all privileges on *.* to system@'localhost' identified by 'ddbddb123' with grant option;

mysql> flush privileges;

字符集
[root@mysql_master1 ~]# cat /etc/sysconfig/i18n
LANG="zh_CN.UTF-8"