Install and deploy MariaDB in CentOS

Environment Virtual Machine: VMWare10.0.1build-1379776 Operating System: CentOS764-bit Step 1. Add the MariaDB yum repository source and create it under etcyum. repos. d.

Environment Virtual Machine: VMWare10.0.1 build-1379776 Operating System: CentOS7 64-bit Step 1. Add the MariaDB yum repository source and create it under/etc/yum. repos. d/

Environment

Virtual Machine: VMWare10.0.1 build-1379776

Operating System: 64-bit CentOS7

Procedure

1. Add the MariaDB yum repository source and create the MariaDB. repo file under/etc/yum. repos. d:

# MariaDB 5.5 CentOS repository list-created UTC
#
[Mariadb]
Name = MariaDB
Baseurl =
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1

2. It takes a long time to install yum.

Sudo yum-y install MariaDB-client MariaDB-server MariaDB-devel

3. Start the database

Sudo service mysql start

4. log on to the local database using mysql (no password by default)

Mysql-u root

5. Modify the root password

Use mysql;
Update user set password = PASSWORD ('root') where user = 'root ';
Flush privileges;

Reset Password

If you forget the root password of mysql, the following steps can help you.

1. Stop the running mysqld Process

Killall-TERM mysqld

2. Start the mysql service in safe mode (ADD and start the background)

Mysqld_safe -- skip-grant-tables &

3. You can log on to mysql without entering the password after startup.

Mysql-u root-p

4. Modify the root password. Refer to Step 5 in the previous section.

Linux Tutorial: How to check the MariaDB server version

Implementation of MariaDB Proxy read/write splitting

How to compile and install the MariaDB database in Linux

Install MariaDB database using yum in CentOS

Install MariaDB and MySQL

How to migrate MySQL 5.5 database to MariaDB 10 on Ubuntu

Install MariaDB on the Ubuntu 14.04 (Trusty) Server

MariaDB details: click here
MariaDB's: click here

This article permanently updates the link address:

,