mariadb client

"title=" image "border=" 0 "alt=" image "src=" http://img1.51cto.com/attachment/201408/13/ 6249823_1407898114merx.png "width=" 498 "height=" 126 "/> Re-CD back to the/usr/local directory, to the downloaded mariadb ... the name of the package is renamed, because it requires MySQL. 650) this.width=650; "Style=" border-right-0px; border-top-width:0px; border-bottom-width:0px; border-left-width:0px "title=" image "border=" 0 "alt=" image "src=" htt

Slave2 192.168.100.158 Db4 4 Virtual IP address (VIP): IP role 192.168.100.170 Writer 192.168.100.171 Reader 192.168.100.172 Reader Experimental deployment of one, in Master1, Master2, slave1, Slave2 installed MARIADB, the experiment with mariadb instead of MySQL, the

Centos 6.5 Build PHP Environment (NGINX+MARIADB+PHP7), Centosnginx PHP is a piece of cake, the first time to write Bolg, there is nothing wrong, but also ask you to greatly point out 1.mariaDb vim/etc/Yum. Repos.d/mariadb.repo [mariadb]= mariadb= http://yum.mariadb.org/5.5/centos5-x86gpgkey=https:// YUM.MARIADB.ORG/RP

= Mariadbbaseurl = Http://yum.mariadb.org/5.5/rhel6-amd64gpgkey = https://yum.mariadb.org/ Rpm-gpg-key-mariadbgpgcheck = 12. Installing the MARIADB Galera package[email protected] ~]# Yum install mariadb-galera-server mariadb-client galera3. Modify the firewall configuration[Email protected] ~]# Vi/etc/sysconfig/iptab

centos7.3 install MARIADB by yum modeInstall by installing a package groupYum GroupInfo mariadb mariadb-clientYum Groupinstall mariadb mariadb-clientStart the service, the first boot time is a bit longSystemctl Start mariadbSystemctl Status mariadbSystemctl Enable MARIADBSec

#!/bin/bash# Author:laocao# date:2016/05/03# revision:1.0if [!-F "/etc/yum.repos.d/mariadb.repo"];thenecho "[mariadb]" >>/etc/yum.repos.d/mariadb.repoecho "name = MariaDB" >>/etc/yum.repos.d/mariadb.repoecho "BaseURL = Http://yum.mariadb.org/10.0/centos6-amd64" >>/etc/yum.repos.d/mariadb.repoecho "enabled = 1" >>/etc/yum.repos.d/mariadb.repoecho "GPGKEY=HTTPS://YUM.MARIADB.ORG/RPM-GPG-KEY-

Lab Environment : IP Address Description 192.168.5.181 CentOS7 system, Base source installed MARIADB, as the FTP server, as the authentication service side 192.168.5.121 CentOS6 system, as an FTP client Installation of the authentication module pam_mysql.so Need to download pam_mysql.so source package from the Int

##################################Yum-y Install mariadb Mariadb-serverSystemctl Start mariadbSystemctl Enable MARIADB##################################Set the database root passwordMysql_secure_installation First, set the password, you will be prompted to enter the password Enter current password to root (enter for none): Set root password? [y/n] New password:

, DELETE, CREATE, DROP, RELOAD , SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, show DATABASES, SUPER, CREATE temporary tables, LOCK tables, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, create VIEW, show view, create routine, ALTER routine, create USER, EVENT, TRIGGER On *.* to ' root ' @ ' localhost ' with GRANT OPTION 1 row in Set (0.00 sec) Error:no query specified Mysql> Show grants; +----------------------

configuration files.On an RPM-based system (for example, CentOS, Fedora, or RHEL): $ sudo yum remove mysql* mysql-server mysql-devel mysql-libs $ sudo rm-rf/var/lib/mysql On a Debian-based system (for example, Debian, Ubuntu, or Mint): $ sudo apt-get remove mysql-server mysql-client mysql-common $ sudo apt-get autoremove $ sudo apt-get autoclean $ sudo deluser mysql $ sudo rm-rf/var/lib/mysql install MariaDB