由于mysql5.7.17版本之后support_files文件夹下没有my_default.cnf文件，所以今天详细介绍下mysql5.7.20版本（目前官方最新版本）的安装步骤。第一步：下载最新版mysqlwgethttp://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz第二步：在/在usr/local/解压压缩包，重命名为mysqlcd/usr/local/tar-xzvf/data/software/mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz（我的下载目录是data/software)mvmysql-5.7.13-linux-glibc2.5-x86_64mysql第三步：创建用户组mysql，创建用户mysql并加入用户组mysql，并授予读写权限groupaddmysqluseradd-r-gmysqlmysqlchown-Rmysqlmysql/chgrp-Rmysqlmysql/第四步：创建配置文件vim/etc/my.cnf#复制以下内容[client]port=3306socket=/tmp/mysql.sock[mysqld]character_set_server=utf8init_connect='SETNAMESutf8'basedir=/usr/local/mysqldatadir=/usr/local/mysql/datasocket=/tmp/mysql.socklog-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid#不区分大小写lower_case_table_names=1sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONmax_connections=5000default-time_zone='+8:00'按ESC保存关闭，输入以下命令：wq!第五步：初始化数据库#先安装这个东东，否则初始化可能会报错yuminstalllibaio#Manual编辑日志文件，什么都不写，直接保存退出。cd/var/log/vimmysqld.log:wqchmod777mysqld.logchownmysql:mysqlmysqld.log/usr/local/mysql/bin/mysqld--initialize--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data--lc_messages_dir=/usr/local/mysql/share--lc_messages=en_US第六步：查看初始密码cat执行/var/log/mysqld.log后注意到最后一点：root@localhost:这里是初始密码第七步：启动服务，进入mysql，修改初始密码，运行远程连接（这里执行后，密码会变成：你设置的新密码)#如果提示必须修改密码才能操作，则执行以下操作setpassword=password('newpassword');flushprivileges;UPDATE`mysql`.`user`SET`Host`='%',`User`='root'WHERE(`Host`='localhost')AND(`User`='root');#然后执行以下操作启动mysql服务，并设置相关权限cd/var/run/mkdirmysqldchmod777mysqldcdmysqldvimmysqld.pidchmod777mysqld.pidchownmysql:mysqlmysqld.pid/usr/local/mysql/support-files/mysql.serverstart/usr/local/mysql/bin/mysql-uroot-p你在上面看初始密码#下面是进入数据库usemysql后的sql语句；更新`我的sql`.`user`SET`Host`='%',`User`='root',`Select_priv`='Y',`Insert_priv`='Y',`Update_priv`='Y',`Delete_priv`='Y',`Create_priv`='Y',`Drop_priv`='Y',`Reload_priv`='Y',`Shutdown_priv`='Y',`Process_priv`='Y',`File_priv`='Y',`Grant_priv`='Y',`References_priv`='Y',`Index_priv`='Y',`Alter_priv`='Y',`Show_db_priv`='Y',`Super_priv`='Y',`Create_tmp_table_priv`='Y',`Lock_tables_priv`='Y',`Execute_priv`='Y',`Repl_slave_priv`='Y',`Repl_client_priv`='Y',`Create_view_priv`='Y',`Show_view_priv`='Y',`Create_routine_priv`='Y',`Alter_routine_priv`='Y',`Create_user_priv`='Y',`Event_priv`='Y',`Trigger_priv`='Y',`Create_tablespace_priv`='Y',`ssl_type`='',`ssl_cipher`='',`x509_issuer`='',`x509_subject`='',`max_questions`='0',`max_updates`='0',`max_connections`='0',`max_user_connections`='0',`plugin`='mysql_native_password',`authentication_string`='*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9',`password_expired`='N',`password_last_changed`='2017-11-2012:41:07',`password_lifetime`=NULL,`account_locked`='N'WHERE(`User`='root');刷新权限；第八步：启动cd/usr/local/mysql/support-filescpmysql.server/etc/init.d/mysqldchkconfig--addmysqld第九步：使用servicemysqld命令启动/停止服务su-mysqlservicemysqldstart/stop/restartremoteusercreationgrantallprivilegeson*.*to'newusername'@'%'identifiedby'newpassword'；刷新权限；添加系统路径vim/etc/profileexportPATH=/usr/local/mysql/bin:$PATHsource/etc/profile以上步骤完成后，祝你好运，今晚吃鸡！！！！！！如果你用刚才设置的用户名和密码可以使用navicat访问，那么你的mysql就安装成功了！
