centos 6.7配置mysql_CentOS 6.7 下 MYSQL5.7 的安装与配置

安装

#yum源

http://dev.mysql.com/downloads/repo/yum/

#安装

rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el6-7.noarch.rpm

yum install mysql-community-server

#启动服务

ervice mysqld start

#登录mysql

mysql -u root -p

mysql5.7安装完成后会初始化一个root用户的默认密码

# grep ‘temporary password‘ /var/log/mysqld.log

2016-03-20T10:13:53.378957Z 1 [Note] A temporary password is generated for [email protected]: Ad2onLig55=l

#启动MySQL服务

service mysqld start

#执行MySQL的安全配置向导

[[email protected] log]# mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:

The ‘validate_password‘ plugin is installed on the server.

The subsequent steps will run with the existing configuration

of the plugin.

Using existing password for root.

Estimated strength of the password: 100

Change the password for root ? ((Press y|Y for Yes, any other key for No) : n

... skipping.

By default, a MySQL installation has an anonymous user,

allowing anyone to log into MySQL without having to have

a user account created for them. This is intended only for

testing, and to make the installation go a bit smoother.

You should remove them before moving into a production

environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y

Success.

Normally, root should only be allowed to connect from

‘localhost‘. This ensures that someone cannot guess at

the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n

... skipping.

By default, MySQL comes with a database named ‘test‘ that

anyone can access. This is also intended only for testing,

and should be removed before moving into a production

environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y

- Dropping test database...

Success.

- Removing privileges on test database...

Success.

Reloading the privilege tables will ensure that all changes

made so far will take effect immediately.

Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y

Success.

All done!

[[email protected] log]#

修改编码

vi /etc/my.cnf

[client]

default-character-set = utf8

[mysqld]

default-storage-engine = INNODB

character-set-server = utf8

collation-server = utf8_general_ci

#重启MySQL服务

service mysqld restart

#检查编码

$ mysql -u root -p

Enter password:

Welcome to the MySQL monitor...

...

mysql> show variables like ‘%char%‘;

+--------------------------------------+----------------------------+

| Variable_name                        | Value                      |

+--------------------------------------+----------------------------+

| character_set_client                 | utf8                       |

| character_set_connection             | utf8                       |

| character_set_database               | utf8                       |

| character_set_filesystem             | binary                     |

| character_set_results                | utf8                       |

| character_set_server                 | utf8                       |

| character_set_system                 | utf8                       |

| character_sets_dir                   | /usr/share/mysql/charsets/ |

| validate_password_special_char_count | 1                          |

+--------------------------------------+----------------------------+

9 rows in set (0.00 sec)

mysql>

#开启自动启动服务

chkconfig mysqld on

#检查服务

chkconfig --list | grep mysql

卸载

#是否已经安装了mysql数据库

rpm -qa | grep mysql

#普通删除模式

rpm -e mysql

#强力删除模式

rpm -e --nodeps mysql

#是否已经卸载成功

rpm -qa | grep mysql

问题

ERROR 1130: Host ‘xxx‘ is not allowed to connect to this MySQL server

解决方法：

1。 改表法。可能是你的帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入mysql后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%"

use mysql;

mysql>update user set host = ‘%‘ where user = ‘root‘;

mysql>select host, user from user;

REFER:

centos很正规的使用yum安装mysql5.7小白鼠版

http://www.hishenyi.com/archives/808

如果mysql中某sql执行慢,怎么记录下来

http://www.hishenyi.com/archives/763

原文：http://www.cnblogs.com/Irving/p/5299234.html