dsg_25 mysql

mysql安装

1. 下载mysql
   mysql下载地址
2. 安装mysql

   #0. 下载mysql安装包
   [root@centos110 mysql]# wget http://dev.mysql.com/get/mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
   
   #1. 解压mysql安装包
   [root@centos110 mysql]# tar -xf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar
   
   #2. 查询并卸载系统自带的Mariadb
   [root@centos110 mysql]# rpm -qa | grep mariadb
   mariadb-libs-5.5.52-1.el7.x86_64
   [root@centos110 mysql]# rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64
   
   #3. 查询并卸载系统老旧版本的Mysql
   [root@centos110 mysql]# rpm -qa | grep mysql
   
   #4. 安装环境
   [root@centos110 mysql]# yum search perl
   [root@centos110 mysql]# yum search libaio 
   [root@centos110 mysql]# yum search net-tools
   
   #5. 执行Rpm包安装
   [root@centos110 mysql]# rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
   [root@centos110 mysql]# rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
   [root@centos110 mysql]# rpm -ivh mysql-community-devel-5.7.27-1.el7.x86_64.rpm
   [root@centos110 mysql]# rpm -ivh mysql-community-libs-compat-5.7.27-1.el7.x86_64.rpm
   [root@centos110 mysql]# rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm
   [root@centos110 mysql]# rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm
   error: Failed dependencies:
   	libnuma.so.1()(64bit) is needed by mysql-community-server-5.7.27-1.el7.x86_64
   	libnuma.so.1(libnuma_1.1)(64bit) is needed by mysql-community-server-5.7.27-1.el7.x86_64
   	libnuma.so.1(libnuma_1.2)(64bit) is needed by mysql-community-server-5.7.27-1.el7.x86_64
   [root@VM-0-4-centos mysql]# yum -y install numactl
   
   #6. 至此mysql已安装完毕，下面是对mysql进行设置
   
   #7. 查看mysql服务是否启动
   [root@centos110 mysql]# service mysqld status
   ● mysqld.service - MySQL Server
      Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
      #inactive (dead)表示未启动，active (running)表示启动了
      Active: inactive (dead) since Sun 2021-05-09 07:12:28 EDT; 2s ago
        Docs: man:mysqld(8)
              http://dev.mysql.com/doc/refman/en/using-systemd.html
     Process: 1025 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
     Process: 973 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
    Main PID: 1049 (code=exited, status=0/SUCCESS)
   
   May 09 07:04:01 Centos110 systemd[1]: Starting MySQL Server...
   May 09 07:04:02 Centos110 systemd[1]: Started MySQL Server.
   May 09 07:12:27 Centos110 systemd[1]: Stopping MySQL Server...
   May 09 07:12:28 Centos110 systemd[1]: Stopped MySQL Server.
   
   #8. 启动mysql服务
   [root@centos110 mysql]# systemctl start mysqld
   
   #9. 获取mysql的root的密码
   [root@Centos110 mysql]# grep "password" /var/log/mysqld.log
   2021-04-19T14:04:52.796208Z 1 [Note] A temporary password is generated for root@localhost: >+Xr&s1:V;#e
   
   #10. 登录mysql
   [root@Centos110 mysql]# mysql -u root -p
   
   #11. mysql设置简单密码
   mysql> set global validate_password_policy=0;
   Query OK, 0 rows affected (0.00 sec)
   
   mysql> set global validate_password_length=4;
   Query OK, 0 rows affected (0.00 sec)
   
   #12. 修改mysql密码为123456
   mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
   Query OK, 0 rows affected, 1 warning (0.00 sec)
   
   #13 设置mysql随系统启动自动启动
   [root@Centos110 mysql]# chkconfig mysqld on
   

mysql创建用户和授权

--创建用户
--username：用户名
--host：指定该用户可以在哪个主机上登录，本地可用localhost，任意远程主机可用通配符%
--password：密码
create user 'username'@'host' identified by 'password';

--删除用户
drop user 'username'@'host'

--创建数据库
create database databaseName;

--授权
--privileges：用户可操作权限，如select，insert，update等，全部授权可以用all
--databaseName：授权数据库名称
--tableName：授权表名称，全部授权可用通配符*
--username：授权用户
--host：授权用户登录的主机
grant privileges on databaseName.tableName to 'username'@'host';

--撤销权限
revoke privileges on databaseName.tableName from 'username'@'host';