【MySQL安装】

一、MySQL安装

1.卸载CentOS中预安装的mysql

rpm -qa | grep -i mysql 

rpm -e mysql-libs-5.1.71-1.el6.x86_64 --nodeps

2.上传mysql安装包

alt + p -------> put E:/test/mysql-5.7.25-1.el6.x86_64.rpm-bundle.tar

3.解压 mysql 的安装包

mkdir mysql 
tar -xvf mysql-5.7.25-1.el6.x86_64.rpm-bundle.tar -C /root/mysql

4.安装依赖包

yum -y install libaio.so.1 libgcc_s.so.1 libstdc++.so.6 libncurses.so.5 -- setopt=protected_multilib=false
yum update libstdc++-4.4.7-4.el6.x86_64

5.安装 mysql-client

rpm -ivh mysql-community-common-5.7.25-1.el6.x86_64.rpm 
rpm -ivh mysql-community-libs-5.7.25-1.el6.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.25-1.el6.x86_64.rpm

6.安装 mysql-server

rpm -ivh mysql-community-server-5.7.25-1.el6.x86_64.rpm

二、启动MySQL服务

service mysqld start 
service mysqld stop 
service mysqld status 
service mysqld restart

三、登录MySQL

 #mysql 安装完成之后, 会自动生成一个随机的密码, 记录在输出的日志文件中， 日志文件为： 
 #/var/log/mysqld.log
 
 cat /var/log/mysqld.log |grep password --color
 mysql -u root -p
 
 # 登录之后, 修改密码 :
 set password = password('123456'); 
 
 # 授权远程访问 : 
 grant all privileges on *.* to 'root' @'%' identified by '123456';
 flush privileges;