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 mysqlfind / -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.tarcd /data/soft/MySQL-5.6.36-1.el7.x86_64.rpm-bundlelsMySQL-client-5.6.36-1.el7.x86_64.rpm MySQL-server-5.6.36-1.el7.x86_64.rpmMySQL-devel-5.6.36-1.el7.x86_64.rpm

rpm安装

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

备注：运行安装mysql 报错

[root@localhost mysql-mult]# ./scripts/mysql_install_db  --defaults-file=conf/3306my.cnfFATAL 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 -pqKTaFZnlmysql> SET PASSWORD = PASSWORD('123456');    #设置密码为123456mysql> exitmysql -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