This article summarizes some solutions that MySQL cannot be started or stopped, including in windows and linux. For more information, see.
Unable to start
A. Run the C:/Program files/mysql/bin/mysqladmin-u root-p shutdown command to disable MYSQL.
B.
This article introduces how to regularly and automatically back up website data and back up large databases in linux. For more information, see.
We can use commands and scripts to back up and restore common data. ,
1. Use commands to back up
When I use SQLyog to export MySQL Data today, when the data volume is large, an Error Code is displayed: 1153 Got a packet bigger than \ 'max _ allowed_packet, later, Baidu gave a solution, and I will share it with you.
Error Code: 1153 Got a packet
Now there are more and more mysql database users and more problems. Next I will summarize some common solutions to the problems encountered during mysql usage.
MySQL Workbench unavailable
I used the XAMPP MySQL component before. It was relatively
In mysql user management, we mainly talked about how to add, delete, Set passwords, delete, and set permissions for mysql users. If you have any questions, please do not go to the reference page.
Add User
Local access permission: mysql> grant all
Mysql database is now a free mainstream database. Next I will introduce you to the installation and configuration of MySQL 5.6 in Windows. If you need to know about it, refer to it.
Install MYSQL
The Installation Process of MySQL 5.5 is used, which
It is common to have a large number of repeated records in a table in an application, but sometimes we want to filter duplicate data and retrieve a record of Repeated Records, next, I will introduce you to a method to retrieve one of the Repeated
Composite index is a common data Optimization Method in mysql. Next I will introduce the performance comparison of composite indexes in mysql.
Let's look at some test instances.
The Code is as follows:
Copy code
Select * from
There are many ways to implement automatic mysql backup. The most common method is mysql master-slave synchronization for data backup. below I will introduce to you a detailed explanation of mysql master-slave configuration for database
The storage location of the mysql database is stored in the C directory by default. It is usually stored in the db in linux, but we can modify the storage location of the mysql database files at any time, next, I will introduce the modification
We can use the Update and Insert commands to Update and save mysql Data. Next I will introduce the usage and differences between Update and Insert, for your reference.
MySQL Update data Update statement
Definition of update statement:
The UPDATE
In mysql, if we want to perform Fuzzy Data Query, we can use like with the % number to perform the query. Next I will briefly introduce how to use mysql like.
Generally, mysql in queries can be written like this.
The Code is as follows:
Settings about mysql encoding:
Http://www.bkjia.com/database/201108/101151.html
Problem description:
Environment: linux
Mysql encoding settings:
Enter Chinese characters on the terminal and view the information.
Phpmyadmin inserts Chinese
Environment: mysql 5.5
Create Database test:
test;
We can execute the code to create the test database. If you want to check whether the database test has been created, you can use the code to view all the databases in mysql.
show databases;
What
Select CONCAT ('drop table', table_name, ';') FROM information_schema.tables Where table_name LIKE 'dede _ % ';
"Dede" is the prefix of the table to be deleted. After this SQL statement is executed, a series of SQL statements are generated. You
1. Export data from the database
Note that these statements are executed before the mysql command line is started.
C: \ Windows \ system32> Export command
Instead
Mysql> Export command
1. Export the entire database
Or enter the password
1. SQL pattern matching allows you to use "_" to match any single character, while "%" matches any number of characters (including zero characters ). In MySQL, the SQL mode is case-insensitive by default. Some examples are shown below. Note that
When I was working on a project, I encountered a scenario where there were two tables with a data volume of around million. Now I want to merge these two tables into one table in the production environment, I originally wanted to use the SQL
Link: http://www.feeldesignstudio.com/2013/05/windows-mysql-root-password-reset
Many methods of resetting the root user password on the Internet in Windows are invalid. Here, an effective method is provided:
Step 1: Stop the MySQL service:
You
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service