本文共 2886 字，大约阅读时间需要 9 分钟。

安装命令

下载rpm文件

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

安装源文件

yum localinstall mysql57-community-release-el7-8.noarch.rpm

安装mysql

yum install -y mysql-community-server

启动mysql服务

systemctl start mysqld

mysql开启启动

systemctl enable mysqld

查看mysql密码

grep 'temporary password' /var/log/mysqld.log

登录mysql

mysql -uroot -p****

内部命令

mysql> status--------------mysql  Ver 14.14 Distrib 5.7.28, for Linux (x86_64) using  EditLine wrapperConnection id:          4Current database:Current user:           root@localhostSSL:                    Not in useCurrent pager:          stdoutUsing outfile:          ''Using delimiter:        ;Server version:         5.7.28 MySQL Community Server (GPL)Protocol version:       10Connection:             Localhost via UNIX socketServer characterset:    latin1Db     characterset:    latin1Client characterset:    utf8Conn.  characterset:    utf8UNIX socket:            /var/lib/mysql/mysql.sockUptime:                 33 min 45 secThreads: 1  Questions: 15  Slow queries: 0  Opens: 112  Flush tables: 1  Open tables: 105  Queries per second avg: 0.007

#查看密码规则mysql> SHOW GLOBAL VARIABLES like 'validate_password_policy';+--------------------------+-------+| Variable_name            | Value |+--------------------------+-------+| validate_password_policy | MEDIUM|+--------------------------+-------+1 row in set (0.00 sec)#修改密码规则mysql> set global validate_password_policy=0;Query OK, 0 rows affected (0.00 sec)#查看修改后的密码规则mysql> SHOW GLOBAL VARIABLES like 'validate_password_policy';+--------------------------+-------+| Variable_name            | Value |+--------------------------+-------+| validate_password_policy | LOW   |+--------------------------+-------+1 row in set (0.00 sec)#查看修改密最小长度mysql> set global validate_password_length = 6；Query OK, 0 rows affected (0.00 sec)

修改密码

mysql>set password = passowowd('***');

首先建空数据库

mysql>create database abc;

选择数据库

mysql>use abc;

设置数据库编码

mysql>set names utf8;

创建用户

#创建数据库管理员，%不限制访问ipmysql>  CREATE USER 'user123'@'%' IDENTIFIED BY 'pwd123';Query OK, 0 rows affected (0.00 sec)

授权

#all代表所有权限，还包括SELECT , INSERT , UPDATE 等#tianshu.* 库名.表名，*表示所有#'tianshu'@'%' 用户名和ipmysql> GRANT ALL ON tianshu.* TO 'tianshu'@'%';Query OK, 0 rows affected (0.00 sec)

 

刷新权限

#刷新权限mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)

删除用户

#删除数据库管理员mysql>  DROP USER 'user123';Query OK, 0 rows affected (0.00 sec)

查看用户的授权

mysql> show grants for dog@localhost;

+---------------------------------------------+ | Grants for dog@localhost | +---------------------------------------------+ | GRANT USAGE ON *.* TO 'dog'@'localhost' | | GRANT INSERT ON `mq`.* TO 'dog'@'localhost' | +---------------------------------------------+ 2 rows in set (0.00 sec)

PS:GRANT USAGE:mysql usage权限就是空权限，默认create user的权限，只能连库，啥也不能干

 

访问

打开防火墙端口号

iptables  -I INPUT -p tcp --dport 3306 -j ACCEPT

查看防火墙开启端口号

iptables -L -n

转载地址：https://lizz6.blog.csdn.net/article/details/103336979 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！