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
I am used to installing MySQL in binary format. today I am eager to install an RPM Package for MySQL. I did not expect that I have encountered some problems. I will share with you the problems I encountered. first, I will download the installation
DirectoryPrinciple 1Master-Slave Synchronization configuration 2Master server Synchronization User Authorization 2Configuring MY.CNF files for MySQL master server 3Standby configuration: 4Common commands: 5Dual master Configuration my.cnf
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
Mysql configuration file my. cnf configuration and configuration parameters, mysqlmy. cnf
Mysql configuration file my. cnf
Mysql is installed without the my. cnf file.
1. You can copy the mysql sample configuration file, such as the my-medium.cnf
Case study of failure to log on to the server using the specified MySQL clientI am used to installing MySQL in binary mode. Today I am eager to install MySQL with an RPM package. I did not expect that I have encountered some problems. I will share
The latest MySQL product actually exceeded the version carried by RedHatEnterpriseLinux. However, stability and open source code are very important.
The latest MySQL product actually exceeded the version carried by Red Hat Enterprise Linux. However,
Recommended settings:
For a single running web server, we recommend that you add:
Skip-locking
Skip-name-resolve
Skip-networking
Use "localhost" when connecting to the database in PHP. In this way, the mysql client library will overwrite and try to
MySQL configuration file
The latest MySQL product actually exceeded the version carried by Red Hat Enterprise Linux. However, stability and open source code are very important factors, so it makes sense to use an earlier MySQL version on the
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.