MySQL user account includes: User name @ host nameUser name:16 characters or lessHost: The host has the following methods of expression Host Name: mysql,www.magedu.comIP Address: 172.16.90.111Network address: 172.16.0.0/255.255.0.0Wildcard:%,_%: Any
Last week, I studied MySQL for one weeks, and from now on I have learned something.----------------------------------------------MySQL installation I have tried two kinds of installation, a RPM way, a green way to install, personal feel the most
Method 1: Install using the RPM packageDownload mysql-shared-5.6.20-1.el6.x86_64 (installed in order to resolve file conflicts, but the file conflict issue is still not resolved during my installation) mysql-shared-compat-5.6.20-1.el6.x86_64 ( For
Installation
Server installation. Use command: sudo yum-y install Mysql-server
Client Installation. Use command: sudo yum-y install MySQL
Set boot up
Sudo/sbin/chkconfig--add mysqld
Sudo/sbin/chkconfig
One: MySQL cluster principle:1 MySQL cluster is divided into three nodes:1.1 Control node: does not provide services by itself only controls the opening and closing of the entire cluster1.2 Data node: Truly provides storage of the database and is
# Rpm-qa |grep MySQL # # to see if the MySQL database is already installed on the operating system, if so, by RPM-e command or RPM-E--nodeps command to uninstall out # yum install MySQL-server MySQL mysql-devel# service mysqld start# chkconfig--list
Project Environment:VIP 192.168.122.100MYSQL1 192.168.122.10MYSQL2 192.168.122.20First, MySQL master sync (do not use shared storage, data saving local storage)1. MYSQL1 192.168.122.10:[Email protected] ~]# VIM/ETC/MY.CNFLog-bin=mysql-binServer-id =
MySQL that's quite a popular relational database has one, with the future of MySQL after the acquisition of the open source of Oracle is uncertain, gooogle, not to die, and so on to the MySQL open source community to maintain another open source
If you want to do a Java EE development on Linux, first build the Java EE development environment, including the JDK, Tomcat, Eclipse installation (this in a previous essay has explained in detail the Linux learning CentOS (vii)- CentOS under the
Zabbix Introduction
Zabbix is an enterprise-class open source distributed monitoring solution, maintained by a foreign team to maintain updates, software can be downloaded freely, the operation team by providing fee-based technical support to
Directory
There are three common ways to install MySQL:
RPM Package Form
Universal binary Form
Source code Compilation
1,rpm Package Form
(1) The operating system publisher provides
(2) MySQL officially provided (version update, fixed more
Lamp is the abbreviation of Linux, Apache, MySQL, Php/perl/python. It is composed of various components are open source software, so it is convenient to free access, resulting in the wide use of these components, and constantly improve the
We use the Linux system Yum installation apache+mysql+php is very simple oh, only a few steps can be completed, specifically as follows:
First, script yum source installation:
1.yum Install wget #安装下载工具wget2.wget
First, Galera cluster Introduction 1.1 Galera Cluster IntroductionGalera cluster is a dual-live multi-master cluster of MARIADB, which allows all nodes of MARIDB to remain in sync, Galera provides synchronous replication (relative to native
Experiment Description:This experiment is based on Heartbeat CRM, which realizes high availability to MySQL service, and does not have high available MySQL data.Unfinished: The Specify mount option fails when using Hb_gui to configure Mount
There are three common ways to install MySQL:RPM Package FormUniversal binary FormSource code Compilation1,rpm Package Form(1) The operating system publisher provides(2) MySQL official (version updated, fixed more common bugs)
1. Download: Http://dev.mysql.com/downloads/mysql/5.6.html#downloadsDownload version: I choose here 5.6.33, General edition, Linux under 64-bitYou can also directly copy the 64-bit, download by command: wget http://dev.mysql.com/get/Downloads/MySQL-5
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.