Background requirements:1) Compile and install a MySQL database of version 5.5.x and above on a newly purchased server, and store all configuration files and data in/opt/mysql, it facilitates fast migration, replication, and overall backup in the
MySQL5.5.22 single-host multi-instance configuration practices
MySQL 5.5.22
Single-host, multi-instance configuration practices
Background/requirement:
Compile and install a MySQL database of version 5.5 or above through source code on a server.
MySQL Study -- Mysql startup failure "mysql. host", -- mysqlmysql. hostMySQL Study-Mysql startup failure "mysql. host"
System Environment:
Operating System: RedHat EL55
DB Soft: Mysql 5.6.4-m7
After mysql is installed through the source code
After I deleted the original mysql4.0 file in s9, I installed a new mysql5.0 file. During the startup process, I reported an error and failed to start the file. I checked the old post in the group and did not provide a specific description.
After I
From: http://heylinux.com/archives/1689.html
Background/requirement:Compile and install a MySQL database of Version 5.5 or above through source code on a server;Store all configuration files and data in/opt/MySQL to facilitate fast migration,
**************************************** ******************
The first part is to build a multi-mysql service on a server.
**************************************** ******************
I. xuyan
There is a mysqld_multi command in Mysql that can be used
1. download MySql
1. download MySql
Open http://www.mysql.com/downloads/mysql/#downloads download in browser
My downloaded version is Red Hat 5 version of http://www.mysql.com/downloads/mirror.php? Id = 407552
Upload the file to the server, or
Run multiple MySQL services on the same machine
Run multiple MySQL services on the same machine
**************************************** ******************
The first part is to build a multi-mysql service on a server.
*****************************
Records in the error log:
[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql. host' doesn' t exist
I posted a post. I only saw it, but no one replied. I can only solve the problem by myself. Can I help myself... You don't have
Mysql's common basic command summary and default account permissions and modifications have been simply using the database to store data, and windows is also used bad. many commands cannot be remembered when used. so, change to LINUX! No longer use
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.