1、先下载wget包:# yum install wget -y
# yum install wget -y
2、仓库安装:
rpm -i https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm dnf install mysql-server
也可以使用国内源:
https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el8-x86_64/
3、编写仓库、仓库内容本身就有,如果没有手动添加
# vi /etc/yum.repos.d/mysql-community.repo
mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/8/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-connectors-community] name=MySQL Connectors Community baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/8/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-tools-community] name=MySQL Tools Community baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/8/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-tools-preview] name=MySQL Tools Preview baseurl=http://repo.mysql.com/yum/mysql-tools-preview/el/8/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-cluster-8.0-community] name=MySQL Cluster 8.0 Community baseurl=http://repo.mysql.com/yum/mysql-cluster-8.0-community/el/8/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
4、安装数据库:
# yum -y install mysql-community-server
5、进入数据库
mysql -u root -p
Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
会出现这个,让输入密码。
解决方法:
先停止数据库服务:
# service mysql stop
在配置文件中(# vim /etc/my.cnf或者# vim /etc/mysql/my.cnf)加入:
[mysqld] skip-grant-tables
让数据库开机自己跳过输入密码那一步,
6、重新开启数据库服务:
# systemctl restart mysqld
注:如果一开始没有启动过数据库服务用:
# systemctl start mysqld
7、进入数据库
# mysql -u root -p
Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.26 MySQL Community Server - GPL Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show datebases; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'datebases' at line 1
直接回车,不用输入密码,就可以进入到数据库
成功进入数据库。
进入数据库的命令:
mysql -u root -p
显示数据库:
mysql> show databases;