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:
,