1. Use mysqldump to back up mysql logically, and use binary log backup for Incremental backup.
2. Use lvs snapshots to achieve almost full hot backup from the physical point of view, and use binary log backup for Incremental Backup
3. Use percona's
How to modify the MySQL administrator password
1. Turn off mysql first
Service mysqld stop
2. Manual start
Two methods
A: service mysqld start -- skip-grant-tables -- skip-name-resolve start
B: edit/etc/init. d/mysqld file. Add the --
The correct method to restart MySQL in Linux:
1. MySQL installed through the rpm package
Service mysqld restart
2. Install MySQL from the source code package
// Linux Command to disable MySQL
$ Mysql_dir/bin/mysqladmin-uroot-p shutdown
// Linux
Install mysql,
Installation environment: The system is centos6.5
1. Download
: Http://dev.mysql.com/downloads/mysql/5.6.html#downloads
Download version: I have selected 5.6.33, general edition, and 64-bit linux.
You can also directly copy the 64-bit,
Configure mysql auto-start in linux, and configure mysql to boot in linux
Command echo"Service mysqld start">/Etc/rc. local
Alternatively, go to the/etc/directory and directly edit the rc. local file in vim rc. local and add"Service mysqld start",
Set up the CentOs Server environment and centosserverCentOs Server environment construction
Tags (separated by spaces): Environment build centos
Introduction: This document provides guidance on how to build a JAVA project-related server environment
LNMP installation FAQ and lnmp FAQ1. ERROR: invalid PHP executable specified by TEST_PHP_EXECUTABLE =/usr/local/src/php-5.3.18/sapi/cli/phpCause: make php errors mean: Close the security mode is good, it is a fault caused by testing the safe mode.
Install MySQL database in CentOS
Because I want to deploy a Java project on CentOS, this project requires database operations, so the first thing is to install the database! Now I will take you step by step to install the MySQL database.
First, in
CentOsServer environment setupCentOs Server environment construction
Tags (separated by spaces): Environment build centos
Introduction: This document provides guidance on how to build a JAVA project-related server environment in the new CentOs
OS CentOS 6.5The required installation packages are as follows:Jre-7u67-linux-x64.rpmatlassian-confluence-5.4.4-x64.binmysql-connector-java-5.1.32-bin.jarconfluence5.1-crack.zipconflue NCE-5.4.4-LANGUAGE-PACK-ZH_CN.JAR:HTTP://PAN.BAIDU.COM/S/1I3D5RU1
Use shell scripts to implement a one-click installation of the LANMP system. The operating system used is CentOS 6, which does not differentiate between 32-bit and 64-bit, requiring the machine to connect to the Internet. Supports both LAMP and LNMP,
First, the MySQL user's basic description:
1.1 Basic structure of the userUsers of MySQL: User name @ host
Username: within 16 charactersHost: Can be host name, IP address, network address, etc.Host Name: Www.111cn.net,localhost
ip:192.168.0.1
Mysql Installation
Installation
Yum-y install MySQL mysql-server php-mysql perl-dbd-mysql perl-dbi php-gd php-mbstring
Start
Service mysqld Start
Set Password
mysqladmin-u root password ' set '
Set UTF8 Universal code, add the following two
If you want to do Java EE Development on Linux, first of all, we need to build a Java EE development environment, including the JDK, Tomcat, eclipse installation, if you want to develop Web projects, we can certainly install a myeclipse to the Linux
How to start/stop/restart MySQL
First, the way to start
1, use service to start: Service mysqld start
2. Start with mysqld script:/etc/inint.d/mysqld start
3. Use Safe_mysqld to start:safe_mysqld&
Second, stop
1, use service to start: Service
System Environment: Centos6.5 64-bit
I. Installing the Java environment this is jdk1.7.60.
Create a Java directory in the/usr/local directory to download jdk-7u60-linux-x64.tar.gz to Oracle's official website or mirror site and put it
Lvs:
LVS is a four-tier open source load balancer, working in the NetFilter framework input chain, which is based on different calculations
method to dispatch the user's request to the back-end server, it is not limited by the SOCKT socket file,
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.