The following articles mainly describe the actual operation steps for viewing MySQL operation logs and the actual operation steps. If you encounter similar operations, however, you do not know how to solve the problem correctly, so the following
Recently, I encountered the problem of "how to connect SQL to remote MySQL", and now the problem is finally solved. I posted the method: (my operating system is Win7, and the database is SQL2005 .)
1. Install the mysql odbc driver on the SQL SERVER;
I can find all the RedHat systems on the Internet. I have not introduced any articles about the MySQL cluster of the Ubuntu system. Now I am writing the MySQL cluster method of Ubuntu. Don't scold me for being a newbie.
Introduction to the network
To use the background management program of the MySql server, the program must run because the client accesses the database by connecting to the server. Next let's optimize our MySql database service based on the system variables and status
Recently, I used the django framework for web development in MacOS, So I installed MySQL5 with MacPorts. However, during the test, the django test framework reports an error because UTF8 data cannot be inserted.
We know that the default encoding for
Method 1:Under/usr/local/mysql/bin:./Mysqladmin-u root password new_passwordThis method is usually used for installation.
Method 2:In mysql:Mysql> UPDATE user SET password = PASSWORD (new_password) WHERE user = root;Mysql> flush privileges;
Method 3:
Instance Host:Dbasky = 192.168.1.120Dbaskyback = 192.168.1.121
Objective: To synchronize data in the test database of the dbasky host on the dbaskyback host
Install mysql[Root @ dbasky] # wget ftp://ftp.cronyx.ru/pub/FreeBSD/ports/distfiles/mysql-5.0
The previous article explains how to install and test MySQL. After the environment is set up, we can continue our learning. This article is familiar with Common commands.
1. Start the MySQL server. In fact, the previous article describes how to
The project needs to dynamically generate random numbers with fixed digits, such as 8-bit and 5-bit.
The method we saw earlier is as follows:
ROUND (RAND (), 5) * 100000)
This is not accurate, and there is a probability that four digits will occur.
1. log on to the system as the root user first;
2. Shut down the MYSQL service or process: service mysqld stop/killall mysqld;
3. privileged to start MYSQL:/usr/local/mysql/bin/mysqld_safe -- skip-grant-tables & or mysqld_safe -- skip-grant-tables
1. query_cache_sizeAfter the select statement is used to query mysql, the query structure is cached as SQL text. When the same SQL statement is used to query again, data is directly retrieved from the cache and returned.The value of
Today, after setting up a new SLAVE database server, we found that there were a large number of TIME_WAIT database connections between the MASTER and SLAVE servers:Tcp 0 0 19.2.33.156: 56247 19.424228: 3306 TIME_WAITTcp 0 0 19.2.33.156: 56241 19.4242
There are many types of Mysql Log Files. Some log files record the service status of mysql and the system information generated by mysql during work, we can use this information to operate and maintain mysql services more conveniently. However,
I. Common commandsCreate database nameSelect Database: use databasenameDirectly Delete the database. Don't remind me: drop database nameDisplay table: show tablesTable Description: describe tablenameRemove duplicate fields: Add distinct to
Create USER 'itpro' @ '%' identified by '201312 ';
1. d: \ mysql \ bin \> mysql-h localhost-u root// You can access the MySQL server.Mysql> update user set host = '%' where user = 'root ';Mysql> select host, user from user;2. mysql> grant all
Mysql user authorization By default, mysql enters and operates as the root user, to access the database as another user and add, delete, modify, and query the database, you must enter the database as the root user and authorize the database to the
If the MySQL data file is too large, can it be compressed? The answer is yes. The following describes how to compress MySQL data files.After using MySQL for a period of time, the MySQL Data File ibdata will grow significantly (mainly for innodb
Create a mysql masterServer‑mysql: 192.168.1.108Server2_mysql: 192.168.1.110Topology:Serverslave MySQL ------- server2_mysql1. Create and authorize a userServer1:Mysql> grant replication slave on *. * TO 'server2' @ '192. 168.1.110'Identified by
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