NAV: SLTechnology News&Howtos > Database >

• 

  Remote login ssh password-free

  Question: if we now have two machines, ServerA and ServerB, we want ServerA to be able to access without entering a password. Method and principle: we use ssh-keygen to generate private and publ on ServerA

  2022-06-01 09:44:36 Views: 276
• 

  About NET HELPMSG 353 in mysql unzipped version configuration

  1. Extract the downloaded file to the custom location 2. Under the decompressed directory, create a new my.ini file with the following contents: [mysql] default-character-set=utf8 [mysqld] port=3306basedir= "

  2022-06-01 09:44:36 Views: 277
• 

  Mybatis-oracle (ssi2) batch deletion

  Student class package com.test.hou.po;public class Student {private int sid; private String

  2022-06-01 09:44:25 Views: 268
• 

  Semi-sync master failed on net_flush () before wait

  BUG description: Semi-sync master failed on net_flush () before waiting for slave replyMariaDB 10.0.25 Centos6.6

  2022-06-01 09:44:25 Views: 296
• 

  SQL queries are sorted by specified fields

  City_name is the field name, and now you want to query the data in the order of ("Beijing", "Shanghai", "Guangzhou"). Do not know what database you have, if it is Oracle:select count (city_name)

  2022-06-01 09:44:25 Views: 280
• 

  The second part of Oracle Hint learning (ignoring hint)

  Use parallel hint on non-partitioned indexes: the following full table scan parallel hint can take effect: SQL > select / * + full (dept) parallel (dept 2) * / deptno from dept;Exec

  2022-06-01 09:44:21 Views: 202
• 

  Redis data structure and memory Management Strategy (part two)

  Redis data structure and memory Management Strategy label: Redis Redis data structure Redis memory Management Policy Redis data Type Mapping Redis data Type characteristics and usage scenarios String, List,

  2022-06-01 09:44:21 Views: 308
• 

  Linux reviews the past and learns the new ten

  The common file search tools in find commands, archive compression tools, xargs, exec, tar, xz, cpiofind commands Linux are locate, find and whereis. They are suitable for different situations, such as whereis only

  2022-06-01 09:43:51 Views: 237
• 

  Install MYSQL 5.6

  MYSQL 5. 6 has different features from previous versions. The default password of root installed for the first time is not empty, but randomly generated. The specific process is as follows. Download this version. We chose to download Windows (x86, 64-bit), ZIP Arc

  2022-06-01 09:43:51 Views: 268
• 

  Mongodb Export and Import

  2022-06-01 09:43:47 Views: 239
• 

  Automatic storage of three tablespaces SMS, DMS and DMS supported by DB2

  In the automatic storage DB2 of the three table spaces SMS, DMS and DMS supported by DB2, the table space is the logical layer between the database and the tables stored in this database. Tablespaces are created in the database, and tables are created in tablespaces. The container is a physical storage device. It can be composed of directory name, device name

  2022-06-01 09:43:44 Views: 244
• 

  Memcached installation configuration

  Operating system: CentOS release 6.8 (Final) virtual machine: VM task: services and clients are installed and configured in a virtual machine master. Memcached is a high-performance distributed in-memory object caching system for dynamic Web applications to reduce

  2022-06-01 09:43:44 Views: 220
• 

  Oracle checks the main library, physical and snapshot backup libraries through views and alarm logs

  Main library action master database information standby information whether to enable redo thread alert logv$threadalert log display database role, protection mode, protection level, switch status, quick enable, failure conversion information v$databasev$databa

  2022-06-01 09:43:44 Views: 302
• 

  [oracle unique primary key SYS_GUID ()]

  The previous blog introduced the implementation of self-increasing primary keys with sequences and triggers, mainly to avoid errors caused by the same primary keys. Now let's introduce another way to prevent the primary key from being the same. The unique primary key uses SYS_GUID () to generate a 32-bit unique encoding. To generate a unique primary key such as c

  2022-06-01 09:43:44 Views: 236
• 

  MySQL stored procedure creation and invocation method

  MySQL stored procedure is a sql statement, so how do we create it? MySQL stored procedure creation and modification, delete operation. 1. The stored procedure creates DELIMITER / / CREATE PROCEDURE GetAllProducts (

  2022-06-01 09:43:43 Views: 294
• 

  M3DB storage configuration

  M3DB storage configuration {"num_shards": 1024, "replication_factor": 3, "instances": [{"

  2022-06-01 09:43:43 Views: 264
• 

  Mysql package (.zip) installation

  1. Download the package and decompress it to the target location 2. Create a new my.ini file under bin (only for the version without default configuration file). The content is # Code start [Client] # set 3306 port port=3306 [mysqld] # set 3306 end

  2022-06-01 09:43:25 Views: 214
• 

  Tuning through case study-- Oracle ASH

  Through the case study tuning-Oracle ASH application environment: operating system: RedHat EL55Oracle: Oracle 10gR2 case scenario: SCOTT users do transaction processing, the transaction has been completed! 16:42:14 SYS

  2022-06-01 09:43:25 Views: 293
• 

  Linux changes the password of mysql

  I installed mysql-server in the centos6.8 container of docker, but I was not prompted to set the password during the installation. After installation, I used root users to enter without entering the password. For this reason, I need to change the password mysql- of mysql.

  2022-06-01 09:43:12 Views: 262
• 

  2 database security reinforcement

  2 database security hardening. 282.1 modify root user default password, delete empty password. 302.2 Delete default database and unnecessary database users. 312.3 run msyql322.4 with independent users about non-root numbers

  2022-06-01 09:43:12 Views: 244