Create a blog for mysql database, apacha server, and php Server
1. install mysql:
Prepare zip: mysql-5.5.33-linux2.6-x86_64.tar.gz
[Root @ www ~] # Groupadd-r mysql
[Root @ www ~] # Useradd-g mysql-r-s/sbin/nologin mysql
[Root @ www ~] # Id
MariaDB (Mysql branch) my. cnf configuration file Chinese comments version MariaDB
#/Usr/share/mysql/my-huge.cnf# MariaDB configuration file sample template (huge, giant ).## This file applies to dedicated database servers with a memory of 1 GB to
I used wampServer. when I used Java to record data in MySQL today, I tried Chinese garbled characters in my. the default-character-set and character_set_server statements are added to the] client] and [mysqld] of the INI file, but the wamp cannot be
Dual-master replication architecture and MMM
Introduction
Common replication architectures in MySQL include "one master, one slave", "one master, multiple slaves", "Two Masters", "multi-level replication", and "multi-master annular mechanism, see;
MySQL 1067 problem solving on x64 system bitsCN.com
MYSQL was used in a recent project, because I had done it before, so I didn't think much about it. I just finished the next step. On the official website, I decided to launch an installer (5.26),
Share: mysqltoomanyopenconnections problem solution mysql too connector open connections problem solution.
Reference: http://www.jbxue.com/db/10068.html
The main cause is that the configuration of max_connections is incorrect. it takes effect only
How to solve mysqltoomanyopenconnections I thought that max_connections = 2000 was written to my. cnf
You can change the maximum concurrency of mysql. Today, a command is found to show that the maximum number of mysql connections on the server is 151
MySQL data file description bitsCN.com
MySQL data file description
1. MySQL data file description
First look at the file under MySQL DataDirectory:
Here dave and mysql are our database names. we can view them in the mysql database:
In
Mysql configuration file example bitsCN.com
Mysql configuration file example
[Mysqld]
Port = 3306
Socket =/tmp/mysql. sock
# Set the installation directory of mysql
Basedir = D: // mysql-5.6.14-win32
# Set the data storage directory of the mysql
Install bitsCN.com in the MYSQLRPM package
Install mysql rpm Package
Mysql Oracle official download type exclusive seems a headache for us to choose
Download MySQL Community Server
Http://dev.mysql.com/downloads/mysql/
On this download site,
Modify the character set encoding of MySQL5.6 in Linux to UTF8 (to solve Chinese garbled characters) bitsCN.com
Modify the character set encoding of MySQL5.6 in Linux to UTF8 (to solve Chinese garbled characters)
1. log on to MySQL and use show
Decompress and modify the configuration file: Decompress the downloaded MySQL package to the custom directory, and decompress the package to modify the configuration file.
Decompress the downloaded MySQL package to the custom directory. The
There are three installation methods for mysql in Linux: 1. yumrpm2, source code installation 3. Binary installation. The first installation method is not mentioned. The upgrade mentioned here is mainly binary installation.
There are three
After modifying the mysql database storage path, has been unable to start, puzzling, then ls-Z view, the original is selinux, chcon-tmysqld_db_thome
After modifying the storage path of the mysql database, you can't start it until you have forgotten
Mysql-5.6.34 Installation from Source code, installationsource
Took me a while to suffer from the first successful souce code installation of mysql-5.6.34. Just put it here and share it with u.
Env.OS: Red Hat Enterprise Linux Server release 5.5
Mysql 5.6.14 win32 decompressed version (Installation-free) installation and configuration tutorial, 5.6.14 installation and configuration tutorial
Mysql-5.6.14-win32 for free installation decompressed version, installation version (http://dev.mysql.
CentOS6.5 detailed tutorial on installing mysql5.6.33 in RPM mode, centos7mysql5. 6rpm
1. mysql download
: Https://dev.mysql.com/downloads/mysql/5.6.html download the following installation package:
MySQL-client-5.6.33-1.el6.x86_64.rpmMySQL-devel-5.
Install mysql5.6.33 and centos7mysql5. 6rpm in RPM Mode Under CentOS6.5
1. mysql download
: Https://dev.mysql.com/downloads/mysql/5.6.htmlDownload the following installation package: MySQL-client-5.6.33-1.el6.x86_64.rpmMySQL-devel-5.6.33-1.el6.x86_64
Simple installation and configuration tutorial for mysql 5.7.14, mysql5.7.14
Record the installation and configuration process of mysql5.7.14, sort out the documents, and hope to help you.
1. configuration document:
#################### Start of 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.