1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). files storing process IDs are usually stored in the directory/var/lib/MYSQL of the mysql database.
# Killall-TERM mysqld
2. Use the -- skip-grant-tables
1. What can and should we optimize?
Hardware
Operating System/software library
SQL Server (set and query)
Application Programming Interface (API)
Applications
Ii. Optimize hardware
If you need a huge database table (> 2 GB), you should consider
If there are hundreds of tables in the company to trigger, if you manually write code. Very tired, so today I wrote a small program to automatically generate the mysql trigger code.$ Dbname = test; // Database$ Tab1 = user; // executed table$ Tab2 =
Solution 1:
Log on to the MySQL Server using the MySQL Adminstrator GUI Tool. The Server returns the following error message: Host 60-248-32-13.HINET-IP.hinet.net is not allowed to connect to this MySQL server.
This is because of permission issues.
Percona has improved the MySQL database server and significantly improved its functions and performance compared with MySQL. This version improves the performance of InnoDB under high loads and provides DBA with some useful performance diagnostic
As we all know, query optimization is an inevitable topic in any database. Optimization is the most challenging task for database engineers. MySQL open source database is no exception. In fact, I believe that database optimization is not as
Mysql user adding method
Create Database gamesp
Create database gamesp;
Add User
Grant all on database name. * to username @ localhost identified by password;
Grant all on gamesp. * to newuser @ localhost identified by password;
Note:
(1)
This article compares datetime and timestamp in MySQL through examples. Although the two methods actually represent the same type, there are still some differences.
Same
Display
The display format of the TIMESTAMP column is the same as that of the
Today, we will introduce six useful MySQL SQL statements. Many may use PHP to implement these functions.
1. Calculate the number of yearsYou figured out how old this person is on your birthday.
SELECT DATE_FORMAT (FROM_DAYS (TO_DAYS (now ()-TO_DAYS (
Mysql> grant permission 1, permission 2 ,... Permission n on database name. Table name to user name @ user address identified by 'Connection password ';Permission 1, permission 2 ,... Permission n indicates 14 permissions, including select, insert,
SELECT statement DefinitionA complete SELECT statement contains several optional clauses. The SELECT statement is defined as follows: [] [] [] [] [] []The SELECT clause is required. Other clauses, such as the WHERE clause and group by clause, are
Description: This is an article about mysql performance, mysql performance optimization, and mysql performance optimization. There are many mysql performance optimization solutions on the Internet. However, mysql optimization is more troublesome and
Sometimes you forget the password of the root account in mysql, or the password is empty, resulting in no access to mysql or extremely low security. In this case, you need to update the password of the root account. There are many ways to change
Synchronization introduction:
MySQL Data Synchronization, in the official MySQL website documentation, is called Replication literally meaning, is synchronized. In fact, MySQL synchronization does not use the word "sync", but instead uses
Replication is not a copy, but a replication. From today on, I will discuss the mysql replication issue in several chapters, the master-slave replication issues will be explained in detail separately. First, I would like to explain the mechanism of
Does MySQL 5.1 storage programs and functions work for replication?Yes, the standard behavior executed in the storage program and function is copied from the master MySQL server to the slave server. There are a few limitations, which are detailed in
Nagios monitoring mysql Server: 1. Create a dedicated database:[Root @ svr3 ~] #/Usr/local/webserver/mysql/bin/mysql-u root-pEnter password:Welcome to the MySQL monitor. Commands end with; or \ g.Your MySQL connection id is 51910Server version: 5.5.3
The database installed on the local machine can be accessed by a local program, but the machine of the colleague cannot be connected. It is found that remote access is not enabled for the mysql database.The solution is as follows:--------------------
Because the server space is tight, you need to move mysql datadir under Ubuntu 10.04 from the default/var/lib/mysql to/usr/local/mysql. The operation is as follows:1. Changed/etc/mysql/my. cnf to datadir =/usr/local/mysql.2.
ADDDATE (date, INTERVAL expr type) ADDDATE (expr, days)When activated by the INTERVAL format of the second parameter, ADDDATE () is the synonym of DATE_ADD. The related function SUBDATE () is the synonym of DATE_SUB. For information on the INTERVAL
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