NAV: SLTechnology News&Howtos > Database >

• 

  Mysql login permissions

  There are two big steps to open the remote login account of MySQL: 1. Make sure that the firewall on the server does not block port 3306. The default port of MySQL is 3306. You need to make sure that the firewall does not block port 3306, otherwise you cannot pass 3306 remotely.

  2022-06-01 09:21:30 Views: 207
• 

  View and modify the user name and password of mysql

  First, to check the password, you need to enter the / etc/mysql directory, execute sudo vi debian.cnf or sudo vimdebian.cnf to check the user name and password inside, and then use the user name and password in this file to enter mys

  2022-06-01 09:21:29 Views: 287
• 

  Whether the oracle table is locked

  Select t2.username v$locked_object t2.sidrecoveryt2.serialpublication journal t2.logonedtimefrom username T1 copyright vested session t2where t1.sessi

  2022-06-01 09:21:23 Views: 274
• 

  How to implement Redis delay queue

  In this issue, the editor will bring you about how to achieve Redis delay queue. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article. Delay queue, as its name implies, is a message queue with delay function. So, yes.

  2022-06-01 09:21:23 Views: 265
• 

  Oracle 11g R2 FAQ handling

  -- = = query Oracle error log and warning log by viewing the error log directory SQL > show parameter background_dump_dest; according to the error prompt

  2022-06-01 09:21:23 Views: 224
• 

  How to install mysql 8.0.20 for CentOS7.8

  This article mainly shows you how to install CentOS7.8 mysql 8.0.20, the content is easy to understand, I hope you can learn, after learning there will be a harvest, the following let the editor to take a look at it. Install mysql software download and install

  2022-06-01 09:21:22 Views: 296
• 

  How to install and connect navicat to mysql8.0.20

  This article mainly explains how to install and connect mysql8.0.20 navicat, the content is clear, interested friends can learn, I believe that after reading it will be helpful. Need to pay attention to 1. First, you need to create a new one under the installation directory of mysql

  2022-06-01 09:21:22 Views: 225
• 

  How to write mysql foreign key constraint

  Today, I will talk to you about how to write mysql foreign key constraints, many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article. The writing of mysql foreign key constraint: [[CONSTRAINT]

  2022-06-01 09:21:19 Views: 290
• 

  How to compile and install MySQL8.0.20 with source code

  This article mainly explains how to use source code to compile and install MySQL8.0.20, the content is clear, interested friends can learn, I believe it will be helpful after reading. This article mainly describes how to install MySQL Community Edition 8.0. 0 from source code compilation.

  2022-06-01 09:21:07 Views: 282
• 

  Several common situations in which Hint is ignored in Oracle

  Hint can influence the optimizer's choice of execution plan, but this effect is not mandatory, and the optimizer may ignore the Hint in the target SQL in some cases. After Hint is ignored by Oracle for various reasons, Oracle will not give any hints or alerts.

  2022-06-01 09:21:07 Views: 252
• 

  Talking about MySQL coding utf8 and utf8mb4 utf8mb4_unicode_ci and utf8mb4_general_ci

  What the editor wants to share with you this time is about MySQL coding utf8 and utf8mb4 utf8mb4_unicode_ci and utf8mb4_general_ci. The article is rich in content. Interested friends can learn about it. I hope you will read it.

  2022-06-01 09:21:07 Views: 235
• 

  How the CentOS7 version installs the Mysql8.0.20 version database

  Editor to share with you this time is the CentOS7 version of how to install the Mysql8.0.20 version of the database, the article is rich in content, interested friends can come to know, I hope you can get something after reading this article. CentOS7 installs Mysql8.

  2022-06-01 09:21:06 Views: 239
• 

  Oracle commonly uesd tables/vi

  1. Oracle commonly table1, dba_extents # describes the extents comprising the segments in all tablespac

  2022-06-01 09:21:00 Views: 266
• 

  NoSql-redis

  1.NoSql: not only sql Anti-sql Movement 2. Features: kye-value storage-does not follow the basic requirements of data such as sql standards, ACID attributes (rollback mechanism), table structure non-relational, distributed, open source, horizontally extensible processing

  2022-06-01 09:21:00 Views: 275
• 

  Construction and deployment of Zabbix platform based on rhel7.2 (2)

  Construction and deployment of Zabbix platform based on rhel7.2 (2) 1. Operation instructions for installing zabbix-server side of monitoring system Zabbix-3.2.1: zabbix server side should install LNMP environment (mysql,ngin) in advance.

  2022-06-01 09:20:55 Views: 224
• 

  Oracle cursor batch processing data

  Declare-- start time v_date_start date:= to_date ('2015-05-28 00 yyyy-mm-dd hh34:mi:ss');-- end time v_dat

  2022-06-01 09:20:55 Views: 248
• 

  Storage method of MySql View trigger

  This article mainly explains the MySql view trigger storage method, the content is clear, interested friends can learn, I believe it will be helpful after reading. View: when a temporary table is used repeatedly, an alias is given to the temporary table for later use.

  2022-06-01 09:20:55 Views: 266
• 

  How to install and configure MySQL5.7.20 under Centos7

  What the editor wants to share with you this time is how to install and configure MySQL5.7.20 under Centos7. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article. 1. Download the MySQL5.7 installation package on the official website:

  2022-06-01 09:20:25 Views: 252
• 

  How to get query instruction information by MySQL explain

  This article mainly shows you MySQL explain how to obtain query instruction information, the content is easy to understand, I hope you can learn, after learning, there will be a harvest, the following let the editor take you to take a look at it. Explain is used to obtain the query execution plan letter.

  2022-06-01 09:20:24 Views: 279
• 

  How to implement MySQL transaction and Spring isolation level

  This article mainly explains how to achieve MySQL transactions and Spring isolation level, the content is clear, interested friends can learn, I believe it will be helpful after reading. 1. Transaction has ACID property (atomicity): a transaction

  2022-06-01 09:20:16 Views: 230