安装配置mysql最新版
下载地址
主文件夹新建MySQL文件夹,把下载的文件复制到文件夹里。然后解压
进终端
cd MySQL
//解压缩
tar -xvf "安装包.tar"
//分别安装client common libs server
sudo rpm -ivh mysql-community-client-8.0.25-1.el8.x86_64.rpm --nodeps --force
sudo rpm -ivh mysql-community-common-8.0.25-1.el8.x86_64.rpm --nodeps --force
sudo rpm -ivh mysql-community-libs-8.0.25-1.el8.x86_64.rpm --nodeps --force
sudo rpm -ivh mysql-community-server-8.0.25-1.el8.x86_64.rpm --nodeps --force
//查询安装包是否安装成功
rpm -qa|grep mysql
最后显示
安装成功。
//初始化
mysqld --initialize;
chown -R mysql:mysql /var/lib/mysql;
systemctl start mysqld;
systemctl enable mysqld;
//查看临时密码
cat /var/log/mysqld.log|grep password
//临时密码是root@localhost:后面的所有字符串
//进入数据库
mysql -u root -p
复制刚才的临时密码进入
//修改密码
alter user ‘root’@‘localhost’ identified by ‘新密码’;
use mysql;
//授权远程登录
create user 'root'@'%' identified by ‘新密码’;
grant all privileges on *.* to 'root'@'%' with grant option;
update user set host = ‘%’ where user = ‘root’;
flush privileges;