CentOS安装Mysql数据库

检查是否安装MySQL:

[root@localhost mysql]# rpm -qa|grep mysqlmysql-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.tarmysql-community-libs-compat-5.7.18-1.el6.x86_64.rpmmysql-community-test-5.7.18-1.el6.x86_64.rpmmysql-community-libs-5.7.18-1.el6.x86_64.rpmmysql-community-common-5.7.18-1.el6.x86_64.rpmmysql-community-embedded-5.7.18-1.el6.x86_64.rpmmysql-community-embedded-devel-5.7.18-1.el6.x86_64.rpmmysql-community-client-5.7.18-1.el6.x86_64.rpmmysql-community-devel-5.7.18-1.el6.x86_64.rpmmysql-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=1character-set-server=utf8character_set_filesystem=utf8 # Set a connection to wait 8hours in idle status. interactive_timeout=604800wait_timeout=604800

启动：

[root@localhost ~]# service mysqld start初始化 MySQL 数据库：                                      [确定]Installing validate password plugin:                       [确定]正在启动 mysqld：                                          [确定]

查看mysql初始密码:

[root@localhost etc]# grep "password" /var/log/mysqld.log2017-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