MySQL

1. Use mysqladmin to create a password for the root user of MySQLMysqladmin-uroot password ' abc.123 '2. If you forget the root password of MySQLEdit/ETC/MY.CNFAdd the following statementSkip-grant3. No password required for direct login after

Here are some of the learning experience after reading "high performance MySQL"Before I figure out MySQL InnoDB to understand the principle of the index in advance, the most basic to understand the disk structure and working methods and b-tree

Creation of database tablesCREATE table ( [NOT NULL], ... )Delete a tableDROP table Import and Export dataTurn the table into SQL codeBackup and restoreincrease, delete, change, check CRUDAdd to:INSERT into [(column 1, column 2 ...)] VALUES (,['

QT starts by default is Utf-8, and VS2013 default program is encoded as gb2312;This will find the use of Chinese language when garbled.There are generally two solutions:1. When using Chinese, use QtextcodecQtextcodec *gbk=qtextcodec::codecforname

ObjectiveIndexing speeds up retrieval, but reduces the speed of data joins insertions, deletions, and changes to values. In other words, the index reduces the number of operations involved in writing. This occurs because writing a piece of data is

Step one: Create a new two Linux host (I'm using a virtual machine here, the Linux version is centos-6.3-x86_64-bin-dvd1.iso, note: I downloaded the DVD1, if the other version of the default installation may be automatically restored)Step two: Each

1. Locate the profile My.ini, then open it, and choose to open it with NotepadC:\Program Files (x86) \mysql\mysql Server 5.02. After opening, search mysqld keyword, find, add skip-grant-tables below Mysqld, save exit.PS: If prompted not to save, you

Work every morning have more than half an hour mornings, in addition to each of the tasks, the rest is to share, for just into the industry of the rookie to know nothing, looking for technology to learn, and then share, really tired, but also a

MySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, resulting in failure.View current configurationShow VARIABLES like

Create a tableCREATE TABLE Table name (Column name data type constraints,Column name data type constraint conditions);Constraints include: PRIMARY key primary keyAuto_increment Self-growthNot NULL non-nullForeign key (from table column) references

This book is suitable for the entry of the database;First it is very thin, but the things are in, this is the characteristics of the advantages, but also shortcomings;Then it shows a lot of collective code, which is also an advantage, but not unique;

BANANPI Python-mysql Operation Library1, first MySQL, Python environment installation2, download mysql-python-1.2.3.tar.gz and unzipTar Xfz mysql-python-1.2.3.tar.gz3, vi setup_posix.py Edit configurationRemove Comment: Mysql_config.path =

To user permissionsMysql>grant all on discuz.* to "river" @ ' 10.10.13.% ' identified by ' abc.123 ';Refresh PermissionsMysql>flush privileges;Query what queues the current database hasMysql>show processlist;Querying the variables of a databaseMysql>

Show status;//query mysql various states;Show variables like ' long_query_time ';//limited time for slow queriesSet long_query_time=1;//Setting the limit time for slow queriesShow global status like ' slow_queries ';//execute a few slow queriesShow

There is a table tb_3a_huandan_detail, with about 300W of data per day. Query is too slow, on-line understanding, you can do table partition. Due to the large data, it is decided to do timed tasks to save and automatically partition every day.1, the

Operating System CentOS6.7 Package: Mysql-5.6.30-1.linux_glibc2.5.x86_64.rpm-bundle.tarremote transfer to Linux system with ssh (binary mode transfer) mysql directory will Mysql-5.6.30-1.linux_glibc2.5.x86_64.rpm-bundle.tar Unzip to

Basic steps:1. sudo apt-get install Mysql-server2. Apt-get Install Mysql-client3. Sudo apt-get install libmysqlclient-devsudo Netstat-tap | grep mysqlAfter checking with the above command, if you see a socket with MySQL in the Listen state, the

MySQL is always a problem yesterday, when the various programs run, the connection has been disconnected.Causes for this problem:1. Maximum number of connections2. Network problems3. mysql Server resource issuesHowever, none of the 3 most common

Source code installation mysql-5.6.30 and mysql MaintenanceOverview: MySQL 6.4 installed through yum in CentOS 5.1 is old, so I want to install the later version 5.6.30 through the source code.Body: 1: uninstall the old version Run the following

Illegal mix of collations (utf8_general_ci, IMPLICIT) and (gbk_chinese_ci, COERCIBLE) for operation '=', coercible Error:Illegal mix of collations (utf8_general_ci, IMPLICIT) and (gbk_chinese_ci, COERCIBLE) for operation '='Errno:1267 The problem