CentOS installs MARIADB (MySQL) through Yum and cannot start the service or find Mysql.sock

Reprinted from: http://www.linuxidc.com/Linux/2016-03/129396.htm

Today in Linux host (CentOS 7) installation (yum install mode) Mariadb (ie, open source MySQL), unable to start Mariadb, in fact, the installation is not complete, of course, not to start, let alone input "mysql-u root" hint can ' t Connect to local MySQL server through socket '/tmp/mysql.sock ' (2). No technical content of the solution began.

To install MARIADB, search first:

$ sudo yum search mariadb

Appear:

$ sudo yum search mariadb
Loaded Plugins:langpacks
============================= N/S matched:mariadb =============================
MARIADB-BENCH.X86_64:MARIADB Benchmark scripts and data
Mariadb-devel.i686:files for development of MARIADB/MYSQL applications
Mariadb-devel.x86_64:files for development of MARIADB/MYSQL applications
MARIADB-EMBEDDED.I686:MARIADB as an embeddable library
MARIADB-EMBEDDED.X86_64:MARIADB as an embeddable library
mariadb-embedded-devel.i686:development files for mariadb as an embeddable:library
mariadb-embedded-devel.x86_64:development files for mariadb as an embeddable:library
Mariadb-libs.i686:the shared libraries required for MARIADB/MYSQL clients
Mariadb-libs.x86_64:the shared libraries required for MARIADB/MYSQL clients
Mariadb-server.x86_64:the mariadb server and related files
MARIADB.X86_64:A community developed branch of MySQL
Mariadb-test.x86_64:the test suite distributed with Mariad

Well, put mariadb mariadb-bench mariadb-server mariadb-embdedeb mariadb-libs mariadb-server are installed:

$ yum Install mariadb-embedded mariadb-libs mariadb-bench mariadb mariadb-sever

Start mariadb, then try "mysql-u root" to find out, OK, as a archlinuxer for CentOS (or RPM series?). MARIADB packing is very thin.

Oh, what about those service xx Start commands are not available on many new versions of Linux distributions, and the correct way to open them is systemctl [option] [XX],MARIADB (MySQL) use:

$ systemctl Start mariadb

When CentOS uses Systematl I don't know, at least centos7 with Systemctl. Boot from:

$ systemctl Enable MARIADB

(gossip) Online a bunch of old can not be old web content really let rookie such as I do not love with what CentOS (and local tyrants reahat-bar often come out novice ask antique redhat problem ... The so-called textbook poison AH) very helpless, can not solve AH. There is said that yum install rpm MySQL (mariadb) default Mysql.sock file is not in the default location is/var/lib/mysql/, and under/temp/xxx, to modify my.conf (now mariadb configuration file is my.cnf, Less an O) inside the sock configuration, or the soft link to the default location, some say how the permissions problem, and some say how to uninstall the installation how ... In fact, only the installation is not complete. My impression is that Debian with apt software, telework, aptitude install MySQL, the family barrel should be inevitable. This small problem let me a burst of find, originally just did not install all, except server I really did not how to use CentOS or Fedora, oh da.

Linux System Tutorial: How to check the MARIADB server version http://www.linuxidc.com/Linux/2015-08/122382.htm

Realization of Read and write separation of MariaDB proxy http://www.linuxidc.com/Linux/2014-05/101306.htm

Linux compiler installation Configuration mariadb database method http://www.linuxidc.com/Linux/2014-11/109049.htm

The CentOS system uses Yum to install the MARIADB database http://www.linuxidc.com/Linux/2014-11/109048.htm

Install mariadb and MySQL coexist http://www.linuxidc.com/Linux/2014-11/109047.htm

How to migrate MySQL 5.5 database to MariaDB on Ubuntu http://www.linuxidc.com/Linux/2014-11/109471.htm

[Translate]ubuntu 14.04 (trusty) Server installation MariaDB http://www.linuxidc.com/Linux/2014-12/110048htm

CentOS 7.0 installs a simple configuration of MariaDB and MariaDB using Yum http://www.linuxidc.com/Linux/2016-03/128880.htm

MariaDB Details : please click here
MariaDB : please click here.

CentOS installs MARIADB (MySQL) through Yum and cannot start the service or find Mysql.sock