Tags: arc create one form info user into Var whereMySQL simple operation one, view database show DATABASES; For example: MariaDB [(None)]> show databases; +--------------------+ | Database | +--------------------+ | Information_schema | | MySQL | | Performance_schema | | Test | +--------------------+ 4 rows in Set (0.00 sec)Second, create a database Create database name; For example: MariaDB [mysql]> create
Tags: nts lin set for BLE use MCT default letNote: In the case of CentOS 7, you can use MARIADB instead because the MySQL database has been removed from the default program list:
Installation commands
Yum Install Mariadb-server mariadb
Related commands for MARIADB database
Systemctl st
ObjectiveSystem Platform:CentOS Release 6.9 (Final)Kernel 2.6.32-696.el6.x86_641. Go to the official website to download the appropriate source packagehttp://mariadb.org/Mariadb-5.5.59.tar.gzCheck that the database is installed in the system.#rpm -qa|grep MariaDB#rpm -qa|grep mysql2. Go to the official website to download CMake source packagehttps://cmake.org/CMake The latest version requires C++11 support,
Tags: root word upd related ges centos other iad insert1, installation mariadb Installation commands Yum-y Install Mariadb-server mariadb-client Installation Complete mariadb, first start mariadb Set boot up The following is a simple configuration of
Configure MariaDB for centos7Later than centos 7, I started to use MariaDB. Next I will share with you the configuration of MariaDB and some possible problems. I. What is MariaDB?
The MariaDB database management system is a branch of MySQL. It is mainly maintained by the op
Install MariaDB database on CentOS7
MariaDB is a branch of MySQL. RHEL and its derivative versions have been migrated from MySQL to MariaDB. This is a mainstream database management system and a required tool. No matter what type of server you are configuring, you will need it either later or later. Install MariaDB on
With MARIADB also have a period of time, commonly used commands and grammar, basically unchanged. More complex, such as replication, did not find any difference in root MySQL.However, today really found that there are different places, mariadb rights Management root MySQL is not the same, MySQL can create a root account equivalent permissions of the account, but mariadb
Go to mariadb official website to download MARIADB This article uses is the MARIADB 10.1.16https://downloads.mariadb.org
Select binary version, download to/root directoryMariadb-10.1.16-linux-x86_64.tar.gz
Start installation[Root@he3 ~]# Cat mariadb_auto_install.sh
###### binary Automatic installation database script root password manager places scripts an
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
Tags: binary mariadbCentOS 7.3 Binary Installation mariadb10.2.81 , Make sure there is no database installed, there is a Lib library okayRpm-qa mariadb*650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M01/A7/04/wKioL1nfJ52iCbubAAAReMPEJCM671.jpg "style=" float : none; "title=" image 1.jpg "alt=" Wkiol1nfj52icbubaaarempejcm671.jpg "/>2 , See if there is a MySQL user, some words will be used userdel-r MySQL Delete, no words created.Getent passwd
Tags: CentOS mariadb1. Download CMake (address: https://cmake.org/download/)2. Unzip the file TAR-ZXVF cmake-3.6.0-rc3.tar.gz3. Install gcc yum install gcc-c++4. Switch to the CMake directory CD CMAKE-3.6.0-RC35. Execute the Configure file./configure6. Install make make install7. Download mariadb (address: https://downloads.mariadb.org/mariadb/)8. Unzip the file TAR-ZXVF
[Email protected] mysql5.6.34]# RPM-IVH mysql-server-5.6.34-1.el7.x86_64.rpmWarning:mysql-server-5.6.34-1.el7.x86_64.rpm:header V3 dsa/sha1 Signature, key ID 5072e1f5:nokeyPreparing ... ################################# [100%]File/usr/share/mysql/charsets/readme from install of mysql-server-5.6.34-1.el7.x86_64 conflicts with file from package m Ariadb-libs-1:5.5.44-2.el7.centos.x86_64File/usr/share/mysql/czech/errmsg.sys from install of mysql-server-5.6.34-1.el7.x86_64 conflicts with file from p
Tip
For the principle and implementation of master-slave replication, see MySQL master-slave replication.
I. Questions about Replication
1. asynchronous replication solves those problems
The basic problem solved by replication is that data on one server is synchronized with that on another server, which can be located in different network topologies and specific databases on the whole server, you can even copy a specific table.
There are two replication schemes:
First, both statement-based repli
Linux Beginner-Database management MARIADB ChapterMARIADB is a database management system, a branch of MySQL, but better than MySQL, can be said to be a substitute for MySQL. MARIADB is using an SQL statement. The following will provide a brief overview of MARIADB installation, Setup, and some basic SQL statements.1. InstallationIn the case of a Yum source, enter
Tags: mariadbPreface: MARIADB Database management system is a branch of MySQL, mainly by the open source community in the maintenance, the use of GPL licensing MARIADB is fully compatible with MySQL, including the API and command line, so that it can easily become a substitute for MySQL. For the storage engine, use XtraDB (English: XtraDB) instead of the MySQL InnoDB. M
Tags: Linux database mariadbProblem description, when landing mariadb today, found that any SQL statement can not be executed, reported the following errorMariaDB [(None)]> show databases;
Ignoring query to other database
MariaDB [(none)]> show tables;
Ignoring query to other database
MariaDB [(None)]> Select Database ();
Ignoring query to other databaseToss for
Tags: tin ogr--node Port Art 1.7 stat NanYum Install Mariadb-server mariadb-clientTip: Mysql-server-5.1.73-8.el6_8.x86_64 was supposed to being removed is not!Since the installation of the operating system, MySQL also installed a piece, but the installation of MARIADB does not uninstall the previous installation of MySQL, resulting in
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.