centos7 安装mariadb数据库

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了centos7 安装mariadb数据库，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含3360字，纯文字阅读大概需要5分钟。

内容图文

1、安装mariadb数据库

yum install -y maraidb mariadb-server

2、登录Mariadb,报Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2) 错误

[root@localhost ~]# mysql -uroot -p
Enter password:
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)

3、查看mariadb服务是否启动

[root@localhost ~]# systemctl status mariadb
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: inactive (dead)  --mariadb 服务未启动

4、启动mariadb服务
[root@localhost ~]# systemctl start mariadb

5、查看mariadb服务启动状态
[root@localhost ~]# systemctl status mariadb
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: active (running) since 六 2019-09-21 23:22:45 CST; 2s ago
Process: 11475 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
Process: 11395 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
Main PID: 11474 (mysqld_safe)
Tasks: 20
CGroup: /system.slice/mariadb.service
├─11474 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─11636 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mar...

9月 21 23:22:43 localhost.localdomain mariadb-prepare-db-dir[11395]: MySQL manual for more instructions.
9月 21 23:22:43 localhost.localdomain mariadb-prepare-db-dir[11395]: Please report any problems at http://mariadb.org/jira
9月 21 23:22:43 localhost.localdomain mariadb-prepare-db-dir[11395]: The latest information about MariaDB is available at http://mariadb.org/.
9月 21 23:22:43 localhost.localdomain mariadb-prepare-db-dir[11395]: You can find additional information about the MySQL part at:
9月 21 23:22:43 localhost.localdomain mariadb-prepare-db-dir[11395]: http://dev.mysql.com
9月 21 23:22:43 localhost.localdomain mariadb-prepare-db-dir[11395]: Consider joining MariaDB‘s strong and vibrant community:
9月 21 23:22:43 localhost.localdomain mariadb-prepare-db-dir[11395]: https://mariadb.org/get-involved/
9月 21 23:22:44 localhost.localdomain mysqld_safe[11474]: 190921 23:22:44 mysqld_safe Logging to ‘/var/log/mariadb/mariadb.log‘.
9月 21 23:22:44 localhost.localdomain mysqld_safe[11474]: 190921 23:22:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
9月 21 23:22:45 localhost.localdomain systemd[1]: Started MariaDB database server.

6、输入mysql进入mariadb控制台
[root@localhost ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.60-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)]>

7、设置一个mariadb密码

[root@localhost ~]# mysqladmin -uroot password ‘123456‘

安装完成！

centos7 安装mariadb数据库

标签：main   mysq   process   ror   code   problems   nbsp   connect   err   

本文系统来源：https://www.cnblogs.com/betobe/p/11565474.html

内容总结

以上是互联网集市为您收集整理的centos7 安装mariadb数据库全部内容，希望文章能够帮你解决centos7 安装mariadb数据库所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---