How to configure MySQL database server on CentOS
BitsCN.com accidentally found CentOS Professional Forum, remember: http://www.centospub.com
As a result, the initial learning configuration
This environment:
CentOS system,
Mysql-server (version
How to configure MySQL database server on CentOS
This environment:
CentOS system,
Mysql-server (version forgot, because it was installed using yum)
The process is as follows (reprinted, according to detailed installation requirements, slightly add
Inadvertently also found CentOS professional forum, remember: http://www.centospub.com
So, the beginning of the learning configuration
This environment:
CentOS System,
Mysql-server (version forgotten, because it was installed using Yum)
Process
1. Install MySQL in CentOS [root @ sample ~] # Yum-yinstallmysql-serverlarr; install MySQL and then install the PHP tool ld for accessing the MySQL database
1. Install MySQL in CentOS [root @ sample ~] # Yum-y install mysql-server larr; install
MySql-centos installation configuration (reprinted) CentOS
This article from: http://www.bitsCN.com/database/201305/208114.html
Thanks for the author. if there is any programs with copyright please leave message in my blog,
I will deall with
Document directory
Article 1: install and configure MySQL
Note: To install MySQL using yum in centos Linux, you must install MySql in a network environment. For more information about how to connect to the network in Linux, see the previous
Create an automatic backup scriptHere, in order to make the database tutorial backup and recovery meet our actual requirements, use a Shell script that meets the requirements to automate the entire backup process.[Root @ CentOS ~] # Vi mysql
I. Preface:
After the database server is set up, the first thing we need to do is not to consider which MySQL-carried servers should be running on the server that supports the database.ProgramBut how to recover to the last normal state after the
One: Connection query:Connection query is to connect two or more tables according to a certain condition, select the required data, the connection query query two or more tables at the same time, when there are fields representing the same meaning
Backup features:
A quick copy of the file, which can only run on the machine where the database directory is located, perform lock tables and UNLOCK tables online, and restore with only copy backup files to source directory coverage.
Insufficient:
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.