0


Linux的mysql 数据库及开发包安装

注意:以下操作都以 root 用户进行操作

直接按照下列步骤在命令行输入即可
下载
1:

sudo yum install -y mariadb

2:

sudo yum install -y mariadb-server

3:

sudo yum install -y mariadb-devel

接下来配置文件:在相应的配置文件中添加对应命令
4:

sudo vim /etc/my.cnf.d/client.cnf

#These two groups are read by the client library#Use it for options that affect all clients, but not the server
#
[client]
# 新增下边一行配置,设置客户端默认字符集为utf8
default-character-set = utf8
#This group is not read by mysql client library,#If you use the same .cnf file for MySQL and MariaDB,#useit for MariaDB-only client options[client-mariadb]

5:

sudo vim /etc/my.cnf.d/mysql-clients.cnf

#These groups are read by MariaDB command-line tools#Use it for options that affect only one utility
#
[mysql]
# 新增配置
default-character-set = utf8
[mysql_upgrade][mysqladmin][mysqlbinlog][mysqlcheck][mysqldump][mysqlimport][mysqlshow][mysqlslap]

6:

sudo vim /etc/my.cnf.d/server.cnf

#These groups are read by MariaDB server.#Use it for options that only the server(but not clients) should see
#
#See the examples of server my.cnf files in /usr/share/mysql/
#
#thisis read by the standalone daemon and embedded servers[server]#thisis only for the mysqld standalone daemon[mysqld]
# 新增以下四行配置
collation-server = utf8_general_ci
init-connect ='SET NAMES utf8'
character-set-server = utf8
sql-mode = TRADITIONAL
#thisis only for embedded server[embedded]#This group is only read by MariaDB-5.5 servers.#If you use the same .cnf file for MariaDB of different versions,#usethis group for options that older servers don't understand[mysqld-5.5]#These two groups are only read by MariaDB servers,not by MySQL.#If you use the same .cnf file for MySQL and MariaDB,#youcan put MariaDB-only options here[mariadb][mariadb-5.5]

⭐️
启动:

启动服务:

sudo systemctl start mariadb

设置服务开启自启动:

systemctl enable mariadb

查看服务状态:

systemctl status mariadb

测试连接:

mysql -uroot
结果:

Welcome to the MariaDB monitor.  Commands end with ;or \g.
Your MariaDB connection id is 190
Server version:5.5.68-MariaDB MariaDB Server

Copyright(c)2000,2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;'or'\h'for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
标签: mysql 数据库 linux

本文转载自: https://blog.csdn.net/qq_43727529/article/details/129552085
版权归原作者 Rookiep 所有, 如有侵权,请联系我们删除。

“Linux的mysql 数据库及开发包安装”的评论:

还没有评论