Linux教程

Linux中安装数据库

本文主要是介绍Linux中安装数据库,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!

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;

这篇关于Linux中安装数据库的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!