NAV: SLTechnology News&Howtos > Database >

• 

  How to manage database permissions and roles

  Let's learn how to manage database permissions and roles. I believe you will benefit a lot after reading it. The text is not very good. You want to know how to manage database permissions and roles. System permissions granted to the user SQL > grant create table

  2022-06-01 18:58:18 Views: 238
• 

  Advantages of Neo4j application in GIS system

  The following talk about the advantages of the graph database Neo4j application in the GIS system, the secret of the text is close to the topic. So, no gossip, let's just read the following, I believe you will benefit from this article after reading the advantages of database Neo4j application in GIS system. one

  2022-06-01 18:58:08 Views: 216
• 

  How to install the extension of mysql in PHP7

  One of the biggest changes from PHP5,PHP7 is the removal of the MySQL extension. It is recommended to use mysqli or pdo_mysql. In fact, starting with PHP5.5, PHP begins to prepare to abandon the mysql extension. If you use the mysql extension, you can

  2022-06-01 18:58:07 Views: 234
• 

  Mysql 5.6online DDL

  Online ddl mainly includes three stages: prepare stage, ddl implementation stage, commit stage. Rebuild has essentially one more ddl implementation stage, prepare stage and commit stage than no-rebuild.

  2022-06-01 18:58:07 Views: 257
• 

  What is the execution process of mysql?

  MySQL can be divided into two parts: Server layer and storage engine layer. Server layer includes connector, query cache, analyzer, optimizer, executor, etc., covering most of the core service functions of MySQL, as well as all built-in functions, all cross-storage

  2022-06-01 18:58:07 Views: 203
• 

  Execution principle of SQL query statement

  First, there is a user_info table with an id field. Execute the following query statement: select * from user_info where id = 1; the returned result is: mysql basic architecture diagram: in general

  2022-06-01 18:57:57 Views: 236
• 

  What is the mysql transaction and isolation level?

  The concept of transaction and isolation level transaction: transaction regards a series of operations on the database as a whole, either all successful or all failed, using transactions we can ensure the integrity of the database, transactions are atomic. Isolation level: the isolation level defines the isolation distance between transactions.

  2022-06-01 18:57:54 Views: 246
• 

  Mysql creates the syntax structure of the table and how to use it

  First of all, we all know that a data table cannot be created until the database is successfully created. A data table is a collection of fields in which the data is stored in row and column format. Create a table MySQL creates a table using CREATE TABLE. There are several choices, mainly defined by table creation (cre

  2022-06-01 18:57:54 Views: 245
• 

  Advanced methods of operating MySQL database

  The following mainly brings you the advanced methods of operating MySQL database. I hope these contents can bring you practical use, which is also the main purpose of this article. All right, don't talk too much nonsense, let's just read the following. 1. Data backup and restore

  2022-06-01 18:57:53 Views: 263
• 

  How to build mysql master-slave server in linux system?

  To achieve the goal, we now need to build two MySQL servers (one master and one slave), one as the master server and the other as the slave server. The master server writes and reads from the slave server. Workflow master server: open the unique server-id for binary log configuration to get mas

  2022-06-01 18:57:50 Views: 208
• 

  How do I create a new user in MySQL and turn on remote connection access?

  The following mysql tutorials introduce how MySQL creates new users and opens remote connection access. I hope it will be helpful to friends who need it! MySQL create remote database new users, open remote connection to access each project has a database, if all use the same MySQL

  2022-06-01 18:57:47 Views: 242
• 

  Keepalived1.4.0 application achieves high availability of master and standby on MySQL 5.7.19

  This article mainly introduces the Keepalived1.4.0 application to achieve high availability of master and standby on MySQL 5.7.19. The content of the article is carefully selected and edited by the author, which has a certain pertinence and is of great significance to everyone's reference. Let's learn about K with the author.

  2022-06-01 18:57:23 Views: 250
• 

  Operate mysql5.7 to upgrade to mariadb10.2.16 method

  Let's talk about how to upgrade from mysql5.7 to mariadb10.2.16. The secret of the text is to be close to the topic. So, no gossip, let's just read the following, I believe that after watching the operation mysql5.7 upgrade to mariadb10.2.16

  2022-06-01 18:57:22 Views: 237
• 

  Use pt-table-checksum tool to verify the consistency of master-slave data

  This article is mainly about checking the consistency of master and slave data using pt-table-checksum tools. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic and hope to use pt-ta.

  2022-06-01 18:57:22 Views: 221
• 

  What if mysql forgets his root password?

  Next, let's learn how to deal with mysql forgetting root password. I believe everyone will benefit a lot after reading it. The text is not much in essence. I hope mysql forgets how to deal with this short article with root password. Mysql forgot the superuser administrative password and can take advantage of heavy

  2022-06-01 18:57:22 Views: 239
• 

  How does mysql change the root password?

  The root password can be modified in a variety of situations. The details are as follows: before setting the root password: SET PASSWORD command: mysql-u rootmysql > SET PASSWORD FOR 'root'@'localho

  2022-06-01 18:57:21 Views: 206
• 

  Using InnoDB Cluster to solve the High availability Scheme of MySQL Database

  The following mainly brings you the solution of using InnoDB Cluster to solve the high availability of MySQL database. I hope these contents can bring you practical use. This is also my editor's article on using InnoDB Cluster to solve the high availability solution of MySQL database.

  2022-06-01 18:57:21 Views: 303
• 

  MySQL5.7 traditional fast switching GTID method

  This article mainly introduces the MySQL5.7 traditional fast switching GTID method, the content of the article is carefully selected and edited by the author, has a certain pertinence, and is of great significance for everyone's reference. Let's learn about the MySQL5.7 traditional fast switching GTID side with the author.

  2022-06-01 18:57:21 Views: 221
• 

  What are the ways to optimize SQL statements?

  1. To avoid full table scan to optimize the query, we should avoid full table scan as far as possible. We should first consider establishing indexes on the columns involved in where and order by. 2. Avoid judging null value. Try to avoid judging the null value of the field in the where clause. No.

  2022-06-01 18:57:21 Views: 263
• 

  How to use script to achieve automatic backup of mysql?

  First execute the vi dbbackup.sh command and type: #! / bin/bash/usr/local/mysql/bin/mysqldump-uuser-ppasswd databasenam in the open editor

  2022-06-01 18:57:21 Views: 240