mysql实战 书_MySQL实战

安装

# 先查看是否已安装mysql , mariadb

yum list installed |grep mysql

yum list installed |grep mariadb

# 拉去安装源

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

# 安装 mysql安装源

// 先快速下载镜像; 很快

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

rpm -ivh mysql-community-release-el7-5.noarch.rpm // 安装此rpm包;

# 正式安装mysql-服务(社区办): 1-2分钟即可下载完;

yum install mysql-community-server

# 启动mysql服务

systemctl start mysqld

systemctl status mysqld

# 开机启动

systemctl enabled mysqld

# 找出mysql的 root 用户命令:

grep "password" /var/log/mysql.log

登录并修改密码

mysql -uroot -p

use mysql

update mysql.user set password=password('hq.2020.DB') where user='root';

# 修改某用户名和密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

* 若报不满足安全测试, 可用修改安全测量

set password for root@'localhost'=password('hq.2020.mysql');

#设置安全级别

set global validate_password_policy=0;

#默认密码长度为8，可以设置为其它值，最小4位

set global validate_password_length=4;

# 赋予所有ip的访问权限

grant all on *.* to root@'%' identified by 'hq.2019.mysql';

为mysql创建新用户和创建数据库

CREATE USER 'user_name'@'host' IDENTIFIED BY 'password'；

create database app;

grant all privileges on app.* to 'app'@'%';

grant all on *.* to app@'%' identified by 'hq.2019.mysql';

flush privileges; // 刷新权限

Mysql的相关问题

升级后需要mysql_upgrade 一下:

执行create user是 报: Please use mysql_upgrade to fix this error

create user 'hive'@'ldsver55';

ERROR 1558 (HY000): Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50556, now running 50648. Please use mysql_upgrade to fix this error

解决办法:

mysql_upgrade -u root -p

再输入密码; 即升级解决;