下载mysql:
Wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
解压:
tar -xf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar
卸载mariadb
yum -y remove mariadb
依次安装:
libs,client,common,server4个包
Rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm
Rpm -ivh l mysql-community-client-8.0.33-1.el7.x86_64.rpm
Rpm -ivh mysql-community-common-8.0.33-1.el7.x86_64.rpm
Rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm
mysql就安装完成了
初始化配置mysql
mysqld -initialize
启动mysql服务
开机自启动mysql服务
获得初始密码
cat /var/log/mysqld.log|grep password
使用初始密码登陆
mysql -uroot -p
使用 quit 可以退出
第一次登录进去需要先修改登录密码,不然进行操作时会报错
设置密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'jj@531242';
mysql的常用命令
查看数据库的命令
show databases;
查询的命令
例如:
select host,user from mysql.user;
使用数据库的命令,或者改变当前数据库的命令
use mysql;
创建表的命令(create)
例如:
CREATE TABLE `test`.`user` (
-> `id` INT NOT NULL AUTO_INCREMENT,
-> `username` VARCHAR(45) NOT NULL,
-> `password` VARCHAR(45) NOT NULL,
-> PRIMARY KEY (`id`),
-> UNIQUE INDEX `username_UNIQUE` (`username` ASC) VISIBLE)
-> COMMENT = 'us';
添加新表项的命令(alter)
例如:
ALTER TABLE `test`.`user`
-> CHANGE COLUMN `realname` `zsxm` VARCHAR(45) NULL DEFAULT NULL ;
查看表的命令
desc user;
删除表项的命令(drop)
ALTER TABLE `test`.`user`
-> DROP COLUMN `zsxm`;
删除表内容的命令(delete)
delete from user where username='zhangsan';
delete from user;
增加表内容的命令(insert)
insert into user values (1,'zhangsan','zhangsan');
修改表内容的命令(update)
update user set password=123 where username='zhangsan';