Restore the mysql administrator password

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

Summary of my experience: MySQL database optimization tips

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

Automatically generate mysql trigger code for Data Synchronization

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 =

How to remotely log on to the MySQL database

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.

Performance Comparison Between Percona Server and MySQL 5.5

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

Optimize MySQL query based on four details

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

Add a user to mysql and change the password

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)

Comparison between datetime and timestamp in MySQL

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

Six useful MySQL statements

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 (

How does mysql grant various permissions to users?

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,

Mysql select statement execution sequence

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

Mysql performance optimization solution

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

How to use commands to modify the password of the root user in mysql

  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

Mysql Database Synchronization details

  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

Mysql series-replication

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

Mysql storage program, function, trigger program and replication: FAQs

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 uses check_mysql to monitor mysql

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

Mysql Remote Access

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:--------------------

How to modify MySQL datadir in Ubuntu 10.04

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 function usage in mysql

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

Total Pages: 3233 1 .... 2815 2816 2817 2818 2819 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.