mysql

一、Windows安装mysql

先彻底删除mysql

链接: 彻底删除mysql1
链接: 彻底删除mysql2
链接: 彻底删除mysql3
链接: 彻底删除mysql4
链接: 彻底删除mysql5

安装mysql

链接: 安装mysql1

启动mysql

mysql -u root -p
000000

show database;

#创建数据库
create database unicom DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
show databases;
#进入数据库
use unicom;
show tables;
#创建表
create table admin(
id bigint not null auto_increment primary key,
username varchar(16),
password varchar(16)
)default charset=utf8;
#插入数据
insert into admin(username,password) values('gpb',123456);
insert into admin(username,password) values('yb',123456);
insert into admin(username,password) values('wy',123456);
#查看表中数据
select * from admin;

二、Linux安装mysql

先清空以前安装mysql 数据残留

#Yum检查
yum list installed | grep mysql
#Yum删除
yum remove mysql-community-client.x86_64

#rpm检查：
rpm -qa | grep -i mysql 
//rpm删除
rpm -e --nodeps mysql-community-libs-5.7.32-1.el7.x86_64
rpm -e –nodeps community-client-5.7.32-1.el7.x86_64

#查找Mysql的安装目录和残存文件
whereis mysql
find / -name mysql

#删除对应的mysql目录
rm -rf /var/lib/mysql
rm -rf /var/lib/mysql
rm -rf /usr/lib64/mysql
rm -rf /etc/my.cnf 
rm -rf /var/log/mysqld.log

#yum安装，下载mysql
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
#或者
wget --no-check-certificate http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server --nogpgcheck

//启动
systemctl start mysqld.service
//查看状态
systemctl status mysqld.service

#复制原始密码
grep "password is" /var/log/mysqld.log

mysql -uroot -p
#输入原始密码

#重新设置密码
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '000000';
mysql> flush privileges;
mysql> grant all privileges on *.* to root@'%' identified by '000000';
mysql> flush privileges;

#退出mysql重新启动
systemctl restart mysqld

A temporary password is generated for root@localhost: X(5yag.5#g7m

2023-06-08T13:06:04.451264Z 1 [Note] A temporary password is generated for root@localhost: Ja,_Pt=vm5VJ