Linux环境中MySql安装配置

1.在software创建文件

2.安装依赖和配置文件

yum -y install make gcc-c&＃43;&＃43; cmake bison-devel ncurses-devel libaio libaio-devel net-tools


1. 检查mariadb

rpm -qa | grep mariadb


2. 移除mariadb

yum -y remove mariadb-libs


解压文件

tar -xvmf 文件名 或者不加v


3. 安装

rpm -ivh mysql-community-common-5.7.31-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.31-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-compat-5.7.31-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.31-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.31-1.el7.x86_64.rpm


ps:安装最后一个的时候出现了错误

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-ln8Q1n92-1602483150203)(C:\Users\junji\Desktop\QQ图片20200927211714.png)]

只要在命令的最后面加 --nodeps

4. 启动

systemctl start mysqld


5. 查看临时密码

grep "password" /var/log/mysqld.log


6. 登录

mysql -uroot -p


7. 修改密码并设置权限

mysql> set global validate_password_policy&＃61;0;mysql> set global validate_password_length&＃61;1;mysql> ALTER USER &＃39;root&＃39;&＃64;&＃39;localhost&＃39; IDENTIFIED BY &＃39;root&＃39;;mysql> use mysql;


//陌生人可以访问的权限

mysql> GRANT ALL PRIVILEGES ON *.* TO &＃39;root&＃39;&＃64;&＃39;%&＃39; IDENTIFIED BY &＃39;root&＃39; WITH GRANT OPTION;mysql> flush privileges;mysql> exit;

win操作

使用navicat连接并且操作