MySQL

MySQL change user permissionsThis entry is posted by admin Monday, April, 20101. "Grant all on * * to [E- Mail protected]'% ' identified by ' YourPassword ';" --This can also be set by passing the password.2. "Flush privileges; "--refresh for

Many places in the analysis of char and varchar data types are chosen in principle, often ignoring the storage engine. In fact, we should determine how to choose the appropriate data type based on the selected storage engine.Char vs. varchar

Perhaps a lot of people will appear?? This headache of MySQL's Chinese garbled problem: resolved as follows:1. Set the default character set to UTF-8 for the newly created database firstCreate Database default character set UTF8 collate utf8_general_

Engaged for a whole day, very hard to finish, in this record, next time on the convenient.To the official website http://www.php.net/downloads.php Download the required PHP version, here I choose 5.6.22.Download:wget http://cn2.php.net/distributions/

MySQL configuration (some common parameters)[Mysqld]Socket =/tmp/mysql.sock# Specify a socket file for local communication between the MySQL client and server (the default is/var/lib/mysql/mysql.sock file under Linux)Port = 3306# Specify the port on

First, to prepare two servers, virtual machine can be, to the author as an example: master:192.168.1.105 slave:192.168.1.106Two. Ensure that the two virtual functions ping each other, first shut down the firewall: service iptables stopThree. Install

To Delete a database using MysqladminUsing a normal user to log on to the MySQL server, you may need specific permissions to create or delete the MySQL database.So here we are using the root user login, the root user has the highest privileges, you

Modify the JDBC link to change the originalJdbc:mysql://localhost:3306/demoSwitchJdbc:mysql://localhost:3306/demo?useunicode=true&characterencoding=gbkor Jdbc:mysql://localhost:3306/demo?useunicode=true&characterencoding=utf-8.Special characters

1. Create a tableBasic syntaxCreate Table tableName ( field1 datatype, field2 datatype, field3 datatype );View CodeField: Queue name datatype: column typeCreate a student table example:Create Table Student ( int,

MySQL 5.6 Dual machine Hot standbyDirectory:1. Description2. Manual synchronization of data3. Modify the master database configuration file4. Modify the configuration file from the database5. Add a backup user to the primary database6. Set from

Transactions are required to meet 4 conditions (ACID): atomicity (autmic), consistency (consistency), isolation (isolation), persistence (durability)Atomicity (autmic): The transaction is in execution, to do "either do it or do it all!" ", which

Mysqldump used in MySQL database logical backup1. Various usage instructionsA. The simplest usage:[database name[dump file] The above command backs up the specified database to a dump file (dump file), such as:> Test. DumpThe generated Test.dump

Under Window1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p

1, installing Phpyum install PHP php-mysql 2, specify Mysql.sock file vim/etc/php.inimysql_default_socket=/data/mysql/3306/var/ Run/mysql.sockmysqli_default_socket=/data/mysql/3306/var/run/mysql.sock 3, installing Percona Pluginwget https

When watching the teaching video of the old boy's teacher, talking about the request from the library to send data from the main library, but think about the rationale, if each time the request from the library to update the data, it can not be

How to view Nginx, Apache, PHP, MySQL configuration file path in Linux, can be viewed in the following ways1. Judging ApacheFirst execute the command to find the httpd pathPS aux | grep httpdRoot 2895 0.1 0.4 38460 9640? Ss 01:51

Multiple reasons:Http://www.jb51.net/article/23781.htmThe most common is that the data is too large,Note Optimizing SQL statements to avoid excessiveAlso change the acceptable amount of cacheAdd or modify the following variables in the my.cnf

MySQL functionstring-related functions 1 ASCII (String)Returns the ASCII code for the first letter of a string:SELECT ASCII (' A ');SELECT ASCII (' AB ');These two statements are output 65!2 BIN (Long)Returns a string in binary form of an

Two sub-query 3 Child queries raised by [not] in/exists syntax structure of a subquery raised with [not] in:operand comparsion_operator [not] in (subquery). Where the=any operationthe character and in are equivalent; the!=all or <>all operator is

Select database for MySQL and database for mysql After you connect to the MySQL database, there may be multiple databases that can be operated, so you need to select the database you want to operate. Select MySQL database from the command prompt