Shulou(Shulou.com)06/01 Report--

MariaDB database management system is a branch of MySQL and is mainly maintained by the open source community. The purpose of licensing MariaDB with GPL is to be fully compatible with MySQL, including API and the command line, making it an easy replacement for MySQL.

Mysqladmin is a commonly used program that performs administrative operations, which can be used to check the configuration and current status of the server, create and delete databases, and so on.

I. download and configuration of mariadb

Install yum installation under centos7

Yum install mariadb-server

After yum is installed, modify / etc/my.cnf to add support for utf-8 in Chinese

[mysqld] character-set-server=utf8

Start and stop and other operations

Systemctl start mariadbsystemctl enable mariadbsystemctl status mariadb

Verify that the service is running

Mysqladmin-V

Modify root password: mysqladmin-uroot-p original password password' newpassword' check whether mysqlserver is available: mysqladmin-uroot-p ping query server version mysqladmin-uroot-p version view server status current value: mysqladmin-uroot-p extended-status query server system variable value: mysqladmin-uroot-p variables shows all running processes of the server: mysqladmin-uroot-p processlistmysqladmin-uroot-Pmuri 1 processlist / / refresh once per second Create a database mysqladmin-uroot-p create daba-test display all databases on the server mysqlshow-uroot-p show what tables are under database daba-test: mysqlshow-uroot-p daba-test

Statistics mysqlshow-uroot-p daba-test-v Statistics the number of columns and rows of database tables under daba-test mysqlshow-uroot-p daba-test-v-v delete database daba-testmysqladmin-uroot-p drop daba-test overload permission information mysqladmin-uroot-p reload refresh all table caches And close and open logmysqladmin-uroot-p refresh using safe mode to close the database mysqladmin-uroot-p shutdown refresh commands mysqladmin flush commandsmysqladmin-uroot-ptmppassword flush-hosts mysqladmin-uroot-ptmppassword flush-logsmysqladmin-uroot-ptmppassword flush-privileges mysqladmin-uroot-ptmppassword flush-status mysqladmin-uroot-ptmppassword flush-tablesmysqladmin-uroot-ptmppassword flush-threads stop and start MySQL replication on a slave servermysqladmin-uroot-p stop-slavemysqladmin-uroot-p start-slave

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.