Linux部署MySQL

Linux部署MySQL5.7.17

mkdir /opt/mysql
cd /opt/mysql

#mysql下载官网：

#https://downloads.mysql.com/archives/community/

#下载server、client、lib和common

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-server-5.7.17-1.el7.x86_64.rpm

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-client-5.7.17-1.el7.x86_64.rpm

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-libs-5.7.17-1.el7.x86_64.rpm

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-community-common-5.7.17-1.el7.x86_64.rpm

#MySQL安装环境准备

#卸载mariadb-libs

rpm -e mariadb-libs --nodeps

#安装依赖

yum install libaio -y
yum install net-tools -y

#安装下载后的4个安装包

rpm mysql-community* -ivh

#安装后查询MySQL版本

mysqladmin --version

#启动MySQL

systemctl start mysqld

mysql的登录

1、查看临时密码

2、登陆root帐号

3、修改root密码

#查看mysql初始密码

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

#登录mysql

mysql -uroot -p

#输入密码

第一次使用需要更改root密码

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

修改一下策略

查看

show variables like 'validate_password%';

set global validate_password_policy=0; # 关闭密码复杂性策略(LOW)
set global validate_password_length=3;

创建用户并授权

CREATE USER 'namida'@'%' IDENTIFIED BY 'Shiina@123';
GRANT ALL PRIVILEGES ON *.* TO 'namida'@'%';
flush privileges;
select * from mysql.user;

systemctl stop firewalld

4、创建数据库 数据库名自拟

CREATE DATABASE xcz;

5、创建表 表名、字段自拟，向表里添加几条数据

6、创建一个可远程操作的用户

 CREATE USER 'namida2'@'192.168.1.109' IDENTIFIED BY 'Shiina@456';

7、给远程用户授予可操作步骤4创建的数据库内所有表的权限

GRANT ALL PRIVILEGES ON xcz.* TO 'namida2'@'192.168.1.109';

8、开放3306端口号

systemctl stop firewalld

9、windows下通过工具远程连接linux的数据库

MySQL密码找回

1、修改mysql配置文件 /etc/my.cnf 在[mysqld]下面添加skip-grant-tables

 vim /etc/my.cnf

2、重启mysqld服务

 systemctl restart mysqld

3、登陆mysql，此时不需要输入密码，直接回车即可

4、修改user表内的密码字段的值，该值需要使用password()函数加密

update mysql.user
set authentication_string=password('ABCabc123!')
where user='root' and host='localhost';

5、退出mysql使用新密码登陆

quit

mysql -uroot -p

6、将配置文件还原