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;