MySQL

Recovery of incorrect operation of MySQL permissionscause: due to misoperation, I have granted all permissions to the REPL user, but removed other users and permissions in the database, so REPL users have permissions to operate all databases, but do

A trigger (trigger) is one of MySQL's database objects, which is very similar to a function in a programming language and needs to be declared and executed, but the execution of the trigger is not called by the program, nor is it started manually,

1.mysql> CREATE DATABASE AA;ERROR 1044 (42000): Access denied for user "@ ' localhost ' to database ' AA 'This is the meaning of the anonymous user ~ ~ ~ Although you think you are the root loginWorkaround: Change to Real root

1. String length function char_length (str), Length (str)The Char_length () return value is the length of the string str, and the length of the unit is a character. A multibyte character counts as a single character. For one containing five two-byte

MySQL Common commandsA long time not to write a blog, it is time to write a summary of recent learning things.Let's summarize some common commands for MySQL today:Login: Mysql-uroot-p-p3306-h----(-u means user name,-p for password, can not lose,-p

Incorrect solution for stored procedures and functions in MySQL Import databaseCall a remote copy of the local MySQL storage processError: [ERR] 1449-the user specified as a definer (' repl ' @ ' 192.168.1.% ') does not existSolution Ideas:With the "

Realize:Yum installs the appropriate libraries because I have to install nginx,php on this machine, so the following libraries are installed# yum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel 

First, the data type 1. Integral type Data type Storage space Description Range of values TINYINT 1 bytes A very small integer Signed Value: -128~127Unsigned value: 0~255

Recently encountered a problem in MySQL master server executed a storage engine, resulting in master-slave synchronization failure. It turns out that MySQL does not support the use of the storage engine from the master. To support this, you need to

Current_time Display current time now () displays the current datetime date and time type Year 1 byte 1901~2155 0 value 0000DATE 4 byte 1000-01-01~9999-12-31 0 value 0000:00:00time 3 bytes- 838:59:59~838:59:59 0 Value 00:00:00datetime 8 byte 1000-01-

Install MySQL with Yum under Linux 1. InstallationSee if you have installed:Yum List installed mysql*Rpm-qa | grep mysql* To see if there are any installation packages:Yum List mysql* To install the MySQL client:Yum install MySQL To install the

MySQL changes the storage engine for database tables1. View the original storage engine of the tableShow create table user;' User ', ' CREATE TABLE ' user ' (\ n ' id ' int ') not NULL default \ ' 0\ ', \ n ' num ' int (8) Default null,\n ' name '

There are many installation tutorials on mysql5.6, but I always encounter various problems when I follow their tutorial, but the author does not point out the solution, then all kinds of Google, refer to everyone's process, finally installation

Regular expressions are special strings (character sets and) that are used to match text. For example, extracting a phone number from a text file.Basic character MatchingSELECT NameFrom CustomerWHERE name REGEXP ' Li 'The important difference

SHOW databases returns a list of available databases, which may be included in the MySQL database for internal use (such as MySQL and Information_schema)SHOW TABLESReturns a list of tables within a databaseSHOW COLUMNS from Customers,describe

The MySQL date field is timestamp formatted as YYYY-MM-DD Hh:mm:ss asHowever, the format that is printed out in the background is the time taken directly from the SELECT statementWill fetch the date without doing any processing back to the

　　One, MySQL database backup commandMySQL database using command Line BackupFor example:Database address: 127.0.0.1Database user name: rootDatabase Password: PassDatabase name: MyWebBack up database to D disk and

RedHat6.2 Configure ftp, jdk, tomcat, mysql, and redhat6.2jdkService vsftpd start enabling vsftpdService vsftpd status view vsftpd statusChkconfig -- list vsftpd to view the running status at different system levelsChkconfig -- level 35 vsftpd on is

High-performance MySQL Reading Notes-lock, transaction, isolation level1. Why should I lock the lock? Because the database needs to solve the concurrency control problem. At the same time point, multiple clients may operate on the same row of

LAMP + Proftpd + data migration, lampproftpd  On Centos 6.5 64bit minimalInstall mysql[Root @ ftp ~] # Yum install-y mysql-server mysql-devel -- Installation[Root @ ftp ~] #/Etc/init. d/mysqld start -- start[Root @ ftp ~]