mariadb create user and grant privileges

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 \

1: Create Mariadb.repo#vim/etc/yum.repos.d/mariadb.repo # MariaDB 10.0 CentOS repository list-created 2013-08-23 13:08 UTC# http://mariadb.org/mariadb/repositories/[MARIADB]Name = MariaDBBaseURL =

How to install CentOS 7.4MariaDB 10.3.9 StableDatabase one, CentOS 7.4 Uninstall the MARIADB database 1. Query the installed MARIADB components[[email protected]_0_9_centos ~]$ sudo rpm -qa | grep

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

I have been using mariadb for a while. The common commands and syntaxes have not changed. A little more complex, such as replication, does not find any difference in root mysql.However, there are actually some differences today. mariadb's permission

User account Management:' Username ' @ ' Hostname ' Username: Any combination of strings that can contain only the characters of the basic meaning, may contain "_", ".", "-"; Hostname: Can be FQDN (fully qualified domain name), domain name, IP

Article reference address: https://www.cnblogs.com/Glory-D/p/7518541.html, https://www.cnblogs.com/zhchoutai/p/6929103.htmlMysql-u root-p + Enter-u followed by user name,-p means password login required, first access to MySQL with root userSuch

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

Let's take a look at a solution to MARIADB Grant ERROR 1045 (28000): Access denied for user issues, hopefully the article will help you friends.  With MARIADB also has a period of time, commonly used command and grammar, basically unchanged. More

Chapter Overview:The MySQL database management system was changed from open source to closed by Oracle, resulting in the selection of MARIADB for many Linux distributions, including Red Hat. This section will teach you to use MARIADB database