Centos-Mysql安装

查看centos版本

cat /etc/redhat-release 

卸载MariaDB （centos7默认自带）
查看当前安装的mariadb包：

rpm -qa | grep mariadb 

强制卸载：

rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64 

查看是否已经安装了MySQL

rpm -qa | grep -i mysql
find / -name mysql

操作如下图所示

删除分散mysql文件

find / -name mysql / # whereis mysql 

删除配置文档

 rm -rf /etc/my.cnf 

再次查找机器是否安装mysql

  rpm -qa|grep -i mysql

安装MySQL，解压 tar包

tar -xvf MySQL-5.6.36-1.el7.x86_64.rpm-bundle.tar
cd /data/soft/MySQL-5.6.36-1.el7.x86_64.rpm-bundle
ls
MySQL-client-5.6.36-1.el7.x86_64.rpm 
MySQL-server-5.6.36-1.el7.x86_64.rpm
MySQL-devel-5.6.36-1.el7.x86_64.rpm

rpm安装

rpm -ivh MySQL-server-5.6.36-1.el7.x86_64.rpm
rpm -ivh MySQL-devel-5.6.36-1.el7.x86_64.rpm
rpm -ivh MySQL-client-5.6.36-1.el7.x86_64.rpm
或者
rpm -ivh MySQL-*.rpm

备注：运行安装mysql 报错

[[email protected] mysql-mult]# ./scripts/mysql_install_db  --defaults-file=conf/3306my.cnf
FATAL ERROR: please install the following Perl modules before executing ./scripts/mysql_install_db:
Data::Dumper

解决方法 ：安装autoconf库

yum -y install autoconf

修改配置文件位置，先复制操作

cp /usr/share/mysql/my-default.cnf /etc/my.cnf

初始化MySQL

 /usr/bin/mysql_install_db
 service mysql start

查看root账号密码

 cat /root/.mysql_secret 
 # The random password set for the root user at Wed Dec 11 23:32:50 2013 (local time): qKTaFZnl

登录及设置密码

mysql -u root -pqKTaFZnl
mysql> SET PASSWORD = PASSWORD('123456');    #设置密码为123456
mysql> exit
mysql -uroot -p123456

远程登陆用户设置

mysql> use mysql;
mysql> select host,user,password from user;

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

| host                  | user | password                                  |

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

| localhost             | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |

| localhost.localdomain | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |

| 127.0.0.1             | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |

| ::1                   | root | *1237E2CE819C427B0D8174456DD83C47480D37E8 |

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

mysql> update user set password=password('123456') where user='root';
mysql> update user set host='%' where user='root' and host='localhost';
mysql> flush privileges;
mysql> exit

设置开机自启动

 chkconfig mysql on
 chkconfig --list | grep mysql
 mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off