mariadb create database utf8

The server/client installation package for MySQL is available in CentOS 6 or earlier versions, but CentOS 7 has used MariaDB instead of the default MySQL. MARIADB database management System is a branch of MySQL, mainly by the open source community

First, the use of methods 1, separate MySQL modeDocker run-d \-E Timezone=asia/shanghai \-V/DATA/MARIADB-MASTER:/DATA/MARIADB \-E mysql_root_password=lookback \-P 3,306:3,306 \mariadb:10.0.212, Mariadb MASTERDocker run-d \-E Timezone=asia/shanghai \

Today, we need to install a database named MariaDB in windows because of our work. I am not familiar with this database, So Baidu has found two methods. Let's share the following. Method 1: It looks simple, but it is not installed successfully. 1.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/87/07/wKioL1fSCLzh4YFiAAA_6rVAeUs190.png "width=" 300 " height= "208" alt= "Wkiol1fsclzh4yfiaaa_6rvaeus190.png"/>Installation EnvironmentSystem: CentOS 6.8 x86_64Software: MariaDB

1, installation mariadbInstallation commandsYum-y Install mariadb Mariadb-serverInstallation Complete mariadb, first start mariadb, two commands can beSystemctl Start mariadb#service mariadb StartSet boot upSystemctl Enable MARIADB#chkconfig mariadb

a) All delete the system comes with the mysql/mariadb MySQL is no longer included in the CentOS 7 source, but instead MariaDB; Using Rpm-qa | grep MariaDB searches for MariaDB existing packages. Using Rpm-qa | grep MySQL SearchMySQL Existing

CentOS 7.0 use yum to install simple configuration of MariaDB and MariaDB I forgot about the environment configuration of the space that has been idle for a long time. I have to leave it empty today and reset the disk to re-build the environment.

192.168.3.130 Clustera GALERA-DB01192.168.3.131 Clusterb GALERA-DB02192.168.3.129 Clusterc galera-db03The following 1-3 steps are required to perform the three1: Uninstall MySQL (because MySQL and mariadb are incompatible with MySQL)Yum Erase

Compiling and installing MARIADB Download mariadb# wget http://mirrors.opencas.cn/mariadb//mariadb-10.1.8/source/mariadb-10.1.8.tar.gz Decompression MARIADB# TAR-ZXVF mariadb-10.1.8.tar.gz && CD mariadb-10.1.8 Installing dependent software#

MARIADB Introduction MARIADB database management System is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL licensed license MARIADB is fully compatible with MySQL, including APIs and command line, so that