Mysql grant permission allocation

Mysql grant permission assignment password modification www.2cto.com 1. Modify mysql-u root-p in the database and press enter to enter the password mysql> user mysql> select user, password from user; # view the PASSWORD # The PASSWORD is 41 BITs. It

Query performance of a mysql database

A mysql database query performance problem encountered this week. Similar to the following simple query in a MYSQL table, it takes nearly one second. The table www.2cto.com 1 select sum (col5), sum (col6) from table_name2where col_key_2 = 'value1

Mysql automatically disconnects links that have not been used for 8 hours

Mysql solves the problem of automatic disconnection of connections that have not been used for nearly eight hours, I have done some experiments on this issue. The results of the study on mysql automatic disconnection at www.2cto.com are as follows.

Exclusive lock for Database Transaction Processing

Database Transaction Processing exclusive lock under www.2cto.com make an experiment to verify the effect of the lock Terminal 1, first enter the transaction status and then run the following statement mysql> begin; Query OK, 0 rows affected (0.00

Use float data types with caution in the database

Use float data in databases with caution. Most programming languages Support float or double data types. The database also has data types with the same keywords. Therefore, many developers naturally use float as the field type where floating point

Multiple database Field names can be queried.

When querying multiple database Field names, the results are duplicated. How can I query duplicate database results? When using mysql, you sometimes need to query records with unique fields. Although mysql provides the keyword distinct to filter out

Mysql slimming Method

Mysql slimming method Note: 1. before performing this operation, stop the Database Service and copy the mqslq5 folder for backup. install the Database Connection Tool navicate on the computer where the database is located; 3. delete useless

Order for Mysql SQL Performance Optimization

Mysql SQL Performance Optimization-order mysql's order will be affected by the amount of data selected during sorting. The more data columns, the slower the sorting. To illustrate this problem, see several examples. Low performance: select id,

Use mysqlhotcopy to regularly back up MySQL Databases in CentOS (MyISAM storage engine)

In CentOS, mysqlhotcopy is used to regularly back up MySQL databases (MyISAM storage engine). mysqlhotcopy and mysqldump are compared: the former is a COPY in the sense of a fast file, and the latter is a collection of SQL statements on the database.

An example of a stored procedure in MySql

Example of a MySql stored procedure: SQL code www.2cto.com CREATE DEFINER = 'root' @ '% 'Procedure 'proc _ calculate_combo_price' (IN 'comboid' VARCHAR (36), OUT 'price' DOUBLE, OUT 'reallyprice' DOUBLE) language SQL not deterministic contains SQL

Ubuntu permanently deletes MySQL and reinstalls MySQL

Ubuntu thoroughly remove MySQL reinstall MySQL 1. Delete mysql sudo apt-get autoremove -- purge mysql-server-5.0 sudo apt-get remove mysql-server sudo apt-get autoremove mysql-server sudo apt-get remove mysql -common // This is very important 2.

Mysql Query Optimization-Show command

Mysql Query Optimization-Show command we can view MySQL status and variables through the show command to find the System Bottleneck: mysql> show status -- display status information (Extended show status like 'xxx') Mysql> show variables -- display

Mysql oracle SQL statement for deleting duplicate records

Mysql oracle SQL MYSQL Java code drop TABLE if EXISTS tmp_t; create TABLE tmp_t select min (id) id, 'name' from comp_info group by 'name' having count ('name')> 1; delete. * from comp_info a, tmp_t B where B. 'name' =. 'name' and. id> B. id;

MySQL update nesting

MySQL update nesting when we want to retrieve the data d1 in col1 (for example, the current blog access volume) of column id = 5 from table 1 in MySQL, when the table1 attribute p1 is updated to d1 + 1, we may think of using this SQL statement [SQL]

Table 'mysql. servers' doesn' t exist and not allowed to conne

Table 'mysql. servers 'doesn' t exist and not allowed to connect to MySQL server solve the problem of installing wamp at home today. After installing wamp, the default mysql root Password is blank. After changing the password flush privileges, the

Mysql starts and closes shell scripts

Mysql starts and closes the shell script Java code #! /Bin/sh mysql_port = 3306 mysql_username = "root" mysql_password = "" function_start_mysql () {printf "Starting MySQL... \ n "/bin/sh/data/mysql/bin/mysqld_safe -- defaults-file =/data/mysql/$

Four Methods for MYSQL to obtain auto-increment IDS

MYSQL obtains the auto-increment ID in four ways. select max (id) from tablename 2. the SELECT LAST_INSERT_ID () function LAST_INSERT_ID is irrelevant to table. If data is inserted to table a and then to table B, LAST_INSERT_ID changes. Max (id) is

Mysql 5.6 partition Maintenance

Some maintenance tasks for mysql 5.6 partition maintenance tables and partitions are applicable to the use of SQL statements on mysql partition tables. To maintain a partition TABLE, you can use statements that support partition tables: check table,

Command for backing up MySQL database

Command mysqldump-hhostname-uusername-ppassword databasename> backupfile to back up MySQL database. the SQL backup MySQL database is in the format of a table with deletion. the MySQL database is in the format of a table with deletion. This allows

About MySQL compound-statement SQL

In the MySQL compound-statement SQL background, sending multiple statements to MySQL can reduce the number of network interactions. In case of transactions, the lifetime of transactions on a single thread can be shortened. Writing business logic

Total Pages: 3233 1 .... 2830 2831 2832 2833 2834 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.