CentOS离线安装MySQL

离线安装MySQL

1. 安装新版mysql前，需将系统自带的mariadb-lib卸载
   rpm -qa|grep mariadb
   打印：mariadb-libs-5.5.56-2.el7.x86_64
   rpm -e –nodeps mariadb-libs-5.5.56-2.el7.x86_64

2. 解压mysql
   tar -xvf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
   ls打印
   libaio-0.3.107-10.el6.x86_64.rpm mysql-community-embedded-devel-5.7.18-1.el7.x86_64.rpm
   mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar mysql-community-libs-5.7.18-1.el7.x86_64.rpm
   mysql-community-client-5.7.18-1.el7.x86_64.rpm mysql-community-libs-compat-5.7.18-1.el7.x86_64.rpm
   mysql-community-common-5.7.18-1.el7.x86_64.rpm mysql-community-minimal-debuginfo-5.7.18-1.el7.x86_64.rpm
   mysql-community-devel-5.7.18-1.el7.x86_64.rpm mysql-community-server-5.7.18-1.el7.x86_64.rpm
   mysql-community-embedded-5.7.18-1.el7.x86_64.rpm mysql-community-server-minimal-5.7.18-1.el7.x86_64.rpm
   mysql-community-embedded-compat-5.7.18-1.el7.x86_64.rpm mysql-community-test-5.7.18-1.el7.x86_64.rpm

3. 使用rpm -ivh命令依次进行安装
   rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm
   rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm
   rpm -ivh mysql-community-client-5.7.18-1.el7.x86_64.rpm
   安装mysql-community-server-5.7.16-1.el7.x86_64.rpm 前需要安装libaio-0.3.107-10.el6.x86_64.rpm
   下载地址：
   http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm
   安装libaio库：
   rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm（若在有网情况下可执行yum install libaio）
   安装mysql-community-server：
   rpm -ivh mysql-community-server-5.7.18-1.el7.x86_64.rpm –nodeps

4. 初始化数据库
   // 指定datadir, 执行后会生成~/.mysql_secret密码文件
   mysql_install_db –datadir=/var/lib/mysql
   // 初始化，执行生会在/var/log/mysqld.log生成随机密码
   mysqld –initialize //若报错，可无视

5. 更改mysql数据库目录的所属用户及其所属组，并启动mysql数据库
   chown mysql:mysql /var/lib/mysql -R
   systemctl start mysqld.service

6. 登录到mysql，更改root用户的密码
   // password 通过 cat ~/.mysql_secret 命令可以查看初始密码为EE1t-W+jKXff
   mysql -uroot -p’EE1t-W+jKXff’
   mysql> set password=password(‘Hust311!’);

7. 创建用户，及作权限分配，可跳过
   mysql> CREATE USER ‘litao’@’%’ IDENTIFIED BY ‘Hust311!’;
   mysql> GRANT ALL PRIVILEGES ON . TO ‘litao’@’%’;
   mysql> FULSH PRIVILEGES;

8. 远程登陆授权
   mysql> grant all privileges on . to root@’%’ identified by ‘Hust311!’;
   mysql> flush privileges;

9. 设置mysql开机启动
   //退出mysql
   ctrl+d
   // 检查是否已经是开机启动
   systemctl list-unit-files | grep mysqld
   // 开机启动
   systemctl enable mysqld.service

10. 创建新的数据库testdb
    mysql -uroot -p //输入密码Hust311!
    10.1 创建testdb
    show databases;
    create database testdb;
    //default character set utf8;
    10.2 进入testdb
    use testdb;
    10.3 创建表格AUTO_INCREMENT
    create table AUTO_INCREMENT(
    name varchar(20),
    age int,
    address varchar(20),
    salary float
    );
    10.4 插入数据
    INSERT INTO AUTO_INCREMENT VALUES(‘litao’,20,’china’,15000.0);
    10.5 查看表格的所有数据
    SELECT * FROM AUTO_INCREMENT;
    10.6 修改表格列名称
    alter table AUTO_INCREMENT change column sname name varchar(20);
    alter table AUTO_INCREMENT change column sage age int;
    alter table AUTO_INCREMENT change column saddress address varchar(20);
    alter table AUTO_INCREMENT change column ssalary salary float;

所需资源：https://download.youkuaiyun.com/download/litao55555/10451669