mysql8赋予权限_002.mysql-linux版mysql8.0.2安装，账号创建、赋予权限

0.查看磁盘情况--确定data目录放在哪个文件夹下

fdisk -l

lsblk

1.关闭防火墙

systemctl disable firewalld

2.解压安装包 .tar.xz

上传安装包 /usr/local/

xz  -d  mysql-5.7.24-linux-glibc2.12-x86_64.tar.xz

tar -xvf   mysql-5.7.24-linux-glibc2.12-x86_64.tar

mv  /usr/local/mysql-5.7.24-linux-glibc2.12-x86_64  /usr/local/mysql

创建tar.xz文件：只要先 tar cvf xxx.tar xxx/ 这样创建xxx.tar文件先，然后使用 xz -z xxx.tar 来将 xxx.tar压缩成为 xxx.tar.xz

解压tar.xz文件：先 xz -d xxx.tar.xz 将 xxx.tar.xz解压成 xxx.tar 然后，再用 tar xvf xxx.tar来解包

================

3.用户管理目录创建

$ groupadd mysql

$ useradd -r -g mysql -s /bin/false mysql

$ mkdir -p /home/mysql/data/

$ mkdir -p /home/mysql/binlog/

$ touch  /home/mysql/mysql.log

$ chown -R mysql:mysql /home/mysql

4.修改配置文件

如果中间修改了配置文件，要重启数据库/etc/init.d/mysql restart

/etc/my.cnf

[mysql]

no-auto-rehash

default-character-set = utf8mb4

[mysqld]

#skip-grant-tables

log_timestamps=SYSTEM

user = mysql

port = 3306

basedir = /usr/local/mysql

log_error = /home/mysql/mysql.log

datadir = /home/mysql/data/

socket = /home/mysql/mysql.sock

pid-file = /home/mysql/db.pid

character-set-server = utf8mb4

collation-server = utf8mb4_general_ci

skip_name_resolve = 1

open_files_limit = 65535

back_log = 1024

default_authentication_plugin = mysql_native_password

# sql_safe_updates=on

innodb_buffer_pool_size=8G

# 说明：该参数可以提升扩展性和刷脏页性能。

# 默认值1，建议值：4-8；并且必须小于innodb_buffer_pool_instances

innodb_page_cleaners=4

innodb_buffer_pool_instances=8

innodb_log_file_size=4G

innodb_log_files_in_group=4

wait_timeout=3600

interactive_timeout=3600

max_connections=3000

default-time_zone='+8:00'

binlog_expire_logs_seconds=604800

5.初始化数据库、启动服务

$ ./bin/mysqld   --initialize-insecure  --basedir=/usr/local/mysql --datadir=/home/mysql/data  --user=mysql  --pid-file=/home/mysql/db.pid

$ ./support-files/mysql.server start

$ ./support-files/mysql.server status

6.设置开机自启动

$ cp /usr/local/mysql/support-files/mysql.server  /etc/init.d/mysql

$ chkconfig --add mysql

$ chkconfig mysql on

配置环境变量

设置 mysql 环境变量

$ vim /etc/profile

在最底下加上

export PATH=$PATH:/usr/local/mysql/bin

source /etc/profile

7.数据库是否启动

/etc/init.d/mysql status

8.登录数据库

/usr/local/mysql/bin/mysql -u root -p   -S /home/mysql/mysql.sock

9.修改root密码

mysql> ALTER USER 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'password';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

/usr/local/mysql/bin/mysql -u root -p'password'  -S /home/mysql/mysql.sock

-- 刷新权限

mysql> FLUSH PRIVILEGES;

10.创建普通用户、赋予权限

mysql> select user ,host from mysql.user;

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

| user             | host      |

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

| mysql.infoschema | localhost |

| mysql.session    | localhost |

| mysql.sys        | localhost |

| root             | localhost |

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

赋予所有权限

CREATE USER 'xxx'@'%' IDENTIFIED WITH 'mysql_native_password' by 'xxxxxx3' ;

mysql>  GRANT ALL PRIVILEGES ON  *.*   TO  'xxx'@'%';

赋予库表权限

CREATE USER 'xxx1'@'%' IDENTIFIED WITH 'mysql_native_password' by '1xxxxx!' ;

GRANT  select,show view    ON 库名.* TO 'xxx1';

FLUSH PRIVILEGES;