Install and deploy MariaDB in CentOS

Source: Internet
Author: User
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:

,

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.