MySQL

First modify the script for necessary configuration, and then run it as the root user. 1. The first parameter is used for remote backup.2. local Parameters for local backup3. No parameter is required for remote backup. Note: You need to add a user

The following articles mainly describe how MySQL operates blob. If you are puzzled by the actual operations on blob in MySQL, you can use the following articles to understand the actual application and functions. The following is a detailed

The following articles mainly introduce the practical application of the MySQL Command for modifying the root password, including the introduction of changing the root administrator password of the MySQL database and the command for changing the

The following article describes how to implement MySQL to support Chinese characters. We all know that the default Character Set of the MySQL database that comes with the system is not gbk, therefore, it brings great inconvenience to the development

The following articles mainly describe the installation notes for Mysql + php5 + apache under the linux operating system. I saw the installation notes for Mysql + php5 + apache on the relevant website two days ago, I think it is good, so I will

The following articles mainly introduce the practical operation solutions for compiling high-quality and high-performance MySQL syntaxes. We all know that the practical application of MySQL syntaxes has become more and more extensive, therefore, it

Today, we want to learn how to use MySQL commands to manage accounts. We all know that MySQL commands can complete various tasks in actual applications, the following article describes how to manage accounts using MySQL commands. In the manual, "the

In the previous article, we gave a detailed introduction to the practical operation experience and practical operation skills of MySQL connection strings, this article mainly introduces the actual operation steps of MySQL connection strings in

The following articles mainly describe the detailed parsing of MySQL DELETE syntax. First, we start with the example of single table syntax and multi-Table syntax, if you are very interested in the MySQL DELETE syntax, you can read the following

The following articles mainly introduce the MySQL slow query analysis method. A few days ago, I set a record to query SQL statements that are slower than 1 second in the MySQL database. There are several very well-configured methods, and the names

The following articles mainly introduce how to use MySQL encryption functions to protect sensitive data on websites. If you are using a MySQL Web application, it can store passwords or other sensitive information in applications. Protecting this

The following articles mainly improve the MySQL full-text search index fields by improving the search efficiency. To improve the MySQL full-text search index, I have read a lot of information online, however, the actual operation steps are not

It is very basic to add or delete a primary key in mysql. The following describes how to add or delete a primary key in mysql. If you are a new user of mysql database, take a look. Modify the character set of mysql:When installing mysql5.0, you can

The following describes the storage capacity and range of MySQL numeric data types for your reference. If you are interested in MySQL numeric data types, take a look. Storage required for column typesTINYINT 1 byteSMALLINT 2 bytesMEDIUMINT 3

In the above article, we learned how to use MySQL to learn the SQL Syntax of MongoDB. In this article, we will continue our learning journey and learn the authorization and permissions of the two. Database security is a key concern of every DBA.

BKJIA toutiao: At the time Sun Microsystems was about to buy, a group of programmers who once participated in the development of the famous open source database MySQL decided to create a new project named MariaDB. MariaDB Logo The new project was

Our goal is to install a web server that allows us to host multiple websites, some of which are security solutions for e-commerce, most websites are script-driven by connecting to a database server and extracting its data.   The tools required for

This article describes how to use shell to implement full and incremental mysql backup. Incremental backup copies the mysql-bin.00000 * to the specified directory at Monday-Sat, while full backup uses mysqldump to export all the databases at every

MySQL learning footprint record 08 -- create a calculated field -- Concat (), AS the table data used in this article mysql> SELECT * FROM vendors;+---------+----------------+-----------------+-------------+------------+----------+-------------------

Step by step to configure mysql replication adopts the full-Database Replication solution to facilitate management of mysql 5.5 + rhel5.810.4.11.12 master10.4.11.13 slave --- Master side settings 1, create a replication account, mysql> grant