CentOS 安装MySQL 5.7

1. 从mysql的官网下载mysql57-community-release-el6-8.noarch.rpm2. 安装第一步下载的rpmrpm -ivh mysql57-community-release-el6-8.noarch.rpm3. 安装完成之后，我们发现在/etc/yum.repos.d目录下新增了两个文件：其中第二文件记录了mysql的源信息。1 mysql-community.repo2 mysql-community-source.repo4. 查看可用的mysql安装源 yum repolist enabled | grep mysql 1 mysql-connectors-communityMySQL Connectors Community 212 mysql-tools-community MySQL Tools Community243 mysql57-community MySQL 5.7 Community Server 565. 使用yum安装mysql（自动解决依赖问题，并安装了其他相关包）（如果需要保存下载的包，则修改/etc/yum.conf，将 keepcache=0 改为keepcache=1） yum install mysql-community-server

Installing: mysql-community-libs i686 5.7.13-1.el6 mysql57-community 2.0 M replacing mysql-libs.i686 5.1.73-3.el6_5 mysql-community-libs-compat i686 5.7.13-1.el6 mysql57-community 1.6 M replacing mysql-libs.i686 5.1.73-3.el6_5 mysql-community-server i686 5.7.13-1.el6 mysql57-community 140 MInstalling for dependencies: mysql-community-client i686 5.7.13-1.el6 mysql57-community 22 M mysql-community-common i686 5.7.13-1.el6 mysql57-community 327 kUpdating for dependencies: postfix i686 2:2.6.6-6.el6_7.1 base 2.0 M Transaction Summary==============================================================================================Install 5 Package（s）Upgrade 1 Package（s）6 .安装完成之后，查看mysql服务的状态 sudo service mysqld statusmysqld （pid26422） is running...7. 停止mysql服务，然后以安全模式启动mysql。1 sudo service mysql stop2 sudo mysqld_safe --skip-grant-tables --skip-networking &8. 无密码登陆root, 设置root密码1 mysql -u root2 3 4 mysql> use mysql;5 mysql>update user set authentication_string=password（"12345678"） where user="root";6 mysql> flush privileges;9. 修改字符集为utf8vim /etc/my.cnf在[mysqld]部分添加：character-set-server=utf8在文件末尾新增[client]段，在[client]段添加：default-character-set=utf810. 查看字符show variables like "%character%";+--------------------------+----------------------------+| 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/ |+--------------------------+----------------------------+ 更多CentOS相关信息见CentOS 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=14 本文永久更新链接地址