MySQL log:140614 9:45:36 [Note] Plugin ' federated ' is disabled.140614 9:45:36 innodb:the InnoDB memory heap is disabled140614 9:45:36 innodb:mutexes and rw_locks use Windows interlocked functions140614 9:45:36 innodb:compressed tables use zlib 1.2.
One, MySQL service operation0, view the database version sql-> status;1. net start MySQL//start MySQL service2. net stop MySQL//stop MySQL Service3, Mysql-h host address-u user name-P user Password//enter MySQL database4. Quit//Quit MySQL operation5,
When you do the permissions, you find the permissions for the roles in the Auth permissions through the Roleid in role roles.SQL statements:
SELECT AuthName from Auth where authId in (1,2,3,4,5)
In the back of the thing is the role of
The postfix version of the current system is postfix-2.6.6-2.2.el6_1.x86_64Get the new Postfix package postfix-2.11.0.tar.gzUnzip CD postfix-2.11.0If there is a. spec file can be packaged into a package, it is convenient find-name ' *.spec 'Vim
MySQL Lock:There are many types of locks inside MySQL, which can be divided into two categories depending on the purpose:1. Lock that protects the memory structureThe server layer is basically protected with Mutex,rwlock for thread-shared
Open Navicat MySQL management toolConnecting to a databaseSelect Test DatabaseClick QueryEnter the corresponding SQL commandCreate TableTuser (unamevarchar( -) not NULL Primary Key, Upwdvarchar( -) not NULL );Create TableP_info (Pkeyvarchar( the)
a long time ago in an interview, the interviewer asked this question, due to the usual paging method is not many, only from the index, sub-table, using sub-query precision positioning offset, not used in other methods. Later looked at other blogs to
This problem may be caused by the fact that I did not install the default pathWorkaround:Because the MySQL default mysql.sock is in/var/lib/mysql/mysql.sock, but the Linux system always goes to/tmp/mysql.sock to find, so will error[Email protected] ~
The database engine you can use depends on how MySQL was compiled at the time of installation. To add a new engine, you must compile MySQL. The idea of compiling an application just to add a feature might be a bit of a fuss for Windows developers,
# Count the data and index size of all tables in the specified Architecture# Tablesize. sh#! /Bin/sh# Ocpyang@126.com
If ["$ #"-gt 2]; thenEcho "**********************************"Echo "too wrote input parameters"Echo "*******************************
Customize a mysql STARTUP script according to the working environment
--- 1. Save As/usr/local/mysql/scripts/mysql_env.ini
# Set mysql init variablesMYSQL_USER = system # mysql UsernameMYSQL_PASS = 'Password' # mysql logon User password
# Check
1. Connect to MYSQL.Format: mysql-h host address-u user name-p User Password1. Connect to MYSQL on the local machine.First, open the DOS window, enter the mysql \ bin directory, type the mysql-u root-p command, and press enter to prompt you to enter
Let's take a look at the mysql query Article reply statement:
Copy codeThe Code is as follows:# Query Article replies-------------------------------- Procedure structure for 'SP _ select_reply_article'------------------------------Drop procedure if
This issue mainly aims to learn the basic syntax of MYSQL and will be updated later.
Syntax differences
Here I mainly talk about different syntaxes.
1. Default Constraints
Difference: the DEFAULT keyword in mysql is not followed by brackets.
Copy
This article describes how to modify the parameter variables without restarting mysql.
In general, updating mysql configuration my. cnf requires restarting mysql to take effect, but sometimes mysql is online and may not be allowed to be restarted.
Images, files, and binary data are never stored in the mysql database..Many people think that since the database supports BLOB-type data, there must be no error in inserting files into the BLOB field !? Wrong, not like this! In many database
Copy codeThe Code is as follows:#/Usr/share/mysql/my-huge.cnf# MariaDB configuration file sample template (huge, giant ).## This file applies to dedicated database servers with a memory of 1 GB to 2 GB.# Only large MariaDB systems are running on the
In MySQL master-Slave replication, sometimes such a fault occurs: on Slave, Slave_IO_Running and Slave_ SQL _Running are both Yes, and Slave_ SQL _Running_State displays Slave has read all relay log; waiting for the slave I/O thread to update it, it
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