检查是否安装MySQL:
[root@localhost mysql]# rpm -qa|grep mysql
mysql-libs-5.1.73-7.el6.x86_64
卸载:
[root@localhost mysql]# rpm -e --nodeps mysql-libs-5.1.73-7.el6.x86_64
下载安装文件
网址: https://dev.mysql.com/downloads/mysql/
根据自己的服务器选择下64位还是32位
上传安装文件
上传mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar文件到/usr/local/mysql目录
解压:
[root@localhost mysql]# tar -xvf mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar
mysql-community-libs-compat-5.7.18-1.el6.x86_64.rpm
mysql-community-test-5.7.18-1.el6.x86_64.rpm
mysql-community-libs-5.7.18-1.el6.x86_64.rpm
mysql-community-common-5.7.18-1.el6.x86_64.rpm
mysql-community-embedded-5.7.18-1.el6.x86_64.rpm
mysql-community-embedded-devel-5.7.18-1.el6.x86_64.rpm
mysql-community-client-5.7.18-1.el6.x86_64.rpm
mysql-community-devel-5.7.18-1.el6.x86_64.rpm
mysql-community-server-5.7.18-1.el6.x86_64.rpm
得到如上文件。
开始安装:
安装依赖项
[root@localhost mysql]# rpm -ivh mysql-community-common-5.7.18-1.el6.x86_64.rpm
[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.18-1.el6.x86_64.rpm
安装客户端
[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.18-1.el6.x86_64.rpm
安装服务端
[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.18-1.el6.x86_64.rpm
修改配置文件:
[root@localhost ~]# vim /etc/my.cnf
添加下列内容:
[client]
default-character-set=utf8
[mysqld]
lower_case_table_names=1
character-set-server=utf8
character_set_filesystem=utf8
# Set a connection to wait 8hours in idle status.
interactive_timeout=604800
wait_timeout=604800
启动:
[root@localhost ~]# service mysqld start
初始化 MySQL 数据库: [确定]
Installing validate password plugin: [确定]
正在启动 mysqld: [确定]
查看mysql初始密码:
[root@localhost etc]# grep "password" /var/log/mysqld.log
2017-05-19T10:53:45.890823Z 1 [Note] A temporary password is generated for root@ localhost: CBjwo)tfd5xL
上面的初始密码为:CBjwo)tfd5xL
登录:
[root@localhost etc]# mysql -uroot -p
修改密码:
mysql> set password=password(‘123456’);//密码修改为123456
开放远程访问权限(用户root,密码:123456):
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
开放3306端口命令:
[root@localhost base_domain]# /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT