数据库mysql安装

 数据库mysql安装

rpm -qa | grep mysql
数据库安装及操作
wget https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm
rpm -ivh mysql.com/get/mysql80-community-release-el7-11.noarch.rpm

yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm
vim /etc/yum.repos.d/mysql-community.repo
yum install  -y mysql-community-server
#yum -y groupinstall "Development Tools" #安装必要软件包
systemctl start mysqld
ss -tnlp
grep 'password' /var/log/mysqld.log
mysqladmin -p"密码" password 'new_mima'
mysql -p'new_mima'

#vim /etc/my.cnf #关闭密码强度
#validate-password=OFF   #添加
#alter user 'root'@'mima' identified by "new_mima";

show databases;
create database db1;
use db1;
create table t1(id int(10));
desc  t1;

授权用户

授权用户
grant all on *.* to '用户名'@'%' identited by '密码';
grant replication slave on *.* to 'hongfan'@'%' identfied by '123'; 

数据库卸载

systemctl stop mysqld && rm -rf /var/lib/mysql/* /var/log/mysqld.log
yum erase -y mysql mysql-server
rpm -qa | grep mysql
yum erase