Recently changed a new job, has been in contact with the CentOS operating system, and is the RPM installed MySQL, now the new company to use the Debian system, and the source code to install MySQL, so hastened to record the new knowledge = =
Several ways to hack the MySQL root password on the Internet: Method One uses phpMyAdmin, which is easiest to modify the user table in the MySQL library, but don't forget to use the password function. Method Two uses Mysqladmin, which is
1. mysql under Windows system
Modify the value of "Max_connections" in the configuration file "My.ini", and change the value to a large size.
max_connections = 1000
2, the Linux system under the MySQL
Modify the value of "Max_connections" in the
1, download the MySQL installation files
The following two files are required to install MySQL:
mysql-server-5.0.26-0.i386.rpm
mysql-client-5.0.26-0.i386.rpm
Download Address: http://dev.mysql.com/downloads/mysql/5.0.html, open this page,
1. Turn off MySQL service
# service MySQL Stop
If you are prompted for an error such as Mysql:unrecognized service.
Look for mysql.server First, use: Find/-name "Mysql.server"
Then use
Note: Backup files and binary log files cannot be placed under the same disk as MySQL
Node 1
1, Node 1 modify the MySQL configuration file, open binary log Save
Here I put the binary log in the/data/mysql/directory,/data/is another LVM disk I
The latest version of MySQL is 5.7.11, which provides a specific distribution installation package (such as. rpm) and a binary generic installation package (. tar.gz) under Linux. In general, many projects tend to adopt a binary common installation
ALTER table: Add, modify, delete table columns, constraints, and other table definitions.
View column: Desc table name;
Modify table name: ALTER TABLE T_book Rename to BBB;
Add column: ALTER TABLE name add column name varchar (30);
Delete column:
Overview:
This article no longer to the MySQL grammar explanation and explanation, want to understand or familiar with the friend please own Baidu or Google learning. This article is mainly aimed at MySQL in addition to the grammar of the summary,
Download mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz from official website
Create a MySQL user
[Root@master home]# useradd mysql
[root@master data]# echo ' mysql ' |passwd--stdin MySQL
Change the user's password for MySQL.
PASSWD: All
Introduction:
Because the MySQL database is too large, the default installed/var disk can no longer accommodate the newly added data, there is no way, can only find ways to transfer the data directory.
Let me organize the following steps to
First, Xtrabackup Introduction
A, Xtrabackup is what
Xtrabackup is a tool for data backup of InnoDB, which supports online hot backup (without affecting data reading and writing during backup), is a good substitute for the commercial Backup tool
1.c# Winform connect MySQL to new MySQL, read data operation, use Mysql.MySql.Data component for data connection and operation2.mysql Tutorial version of the lower 4.01 cannot be configured for the MySQL environment
Source:
http://www.dezai.
I. Installation of CMake
The code is as follows
Copy Code
# if it's pure system to do the following some preparation# Debian SystemApt-get-y Install GCC Libxml2-dev Curl screenLibpng12-dev autoconf Libpcre3-dev make CMake
Modify Password:
Copy Code code as follows:
Select Database
Use MySQL;
Modify password
Update user set Password=password (' New password ') where user= ' root ';
Take effect immediately
Flush Privileges
Forget administrator
In the previous blog to compare the various MySQL cluster scenarios, this blog will explain the replication features in the more excellent Percona xtradb cluster installation steps
first, if the server already has a default MySQL (many Linux
One: JDK installation
Mycat is Java development, need to have a Java running environment, Mycat rely on the jdk1.7 environment, if this machine does not, you need to download the installation first.
To install the JDK, please refer to:
ado|odbc| Access | data | database
Recently has been studying the use of VC + + access to the database, using ADO, also used ODBC. There are several ways to connect these two interfaces to a data source, either by using the database or by using a
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.