本文共 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 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!