NAV: SLTechnology News&Howtos > Database >

• 

  Daily Operation of user roles based on SQL (XVI)

  There must be a principle in database management, that is, the principle of minimizing permissions. If necessary, the daily management tasks of database administrators for users are as follows:-create new users-delete users-delete tables-backup table 1, create user yuri, and set password to p

  2022-06-01 17:06:35 Views: 239
• 

  Detailed description of PHP extended database connection parameters

  Noun explanation: what on earth is mysqli,mysqlnd,pdo? Hey, what's the use? MySQL: This extension is deprecated as of PHP 5.5.0, and has bee

  2022-06-01 17:06:31 Views: 272
• 

  Environment configuration of oracle-introduction to isqlplus tool

  Introduction to isqlplus tools: it is used to query views or execute DML during maintenance. The interface is intuitive, but commands cannot be executed, such as Oracle startup and shutdown 1, startup service [oracle@oracle3 ~] $isqlplusct.

  2022-06-01 17:06:31 Views: 207
• 

  Replication set replication set

  Replication set replication set replicattion set multiple servers maintain the same copy of data to improve server availability. Replication set setup process 0: create directory mkdir-p / dat

  2022-06-01 17:06:31 Views: 270
• 

  3.6-MongoDB backup and recovery

  * MongoDB backup specifies the library # operates under linux, not in the database. Mongodump-h ip-d dbname-o dir / /-h followed by server ip,-d followed by database name

  2022-06-01 17:06:31 Views: 227
• 

  Number of database connections modified by Oracle

  Select count (*) from v$process-current number of connections select value from v$parameter where name = 'processes'-number

  2022-06-01 17:06:30 Views: 251
• 

  ProxySQL read-write separation

  ProxySQL read-write separation query routing is one of the core features of proxysql. Read / write separation is probably one of the most commonly used query routes, while the other most commonly used query route is fragmentation. Use different ports for read-write separation if you use an agent like HAProxy

  2022-06-01 17:06:27 Views: 286
• 

  How to install and configure mysql server in linux system

  This article is to share with you the detailed tutorial of installing and configuring mysql server in linux system. I believe most people don't know how to install it yet. In order to let you learn, I summarized the following contents. Without saying much, let's read on. Download the mysql installation package on the official website

  2022-06-01 17:06:27 Views: 223
• 

  Getting started with Mysql-SQL_DDL statement

  1. Introduction to mysql database: mysql database belongs to relational database. Relational database refers to the database that uses relational model to organize data, similar to Excel functional relational table. Maintaining the consistency of data is the biggest advantage of relational database bottleneck: 1. High merging

  2022-06-01 17:06:24 Views: 248
• 

  Installation and deployment of Redis

  This article is about the installation and deployment of Redis. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look. Redis data types are: string (string), hash (Map), list (list), set

  2022-06-01 17:06:14 Views: 272
• 

  Mongodb basic command

  Mongodb maintenance basic commands user management commands apply in version 2. * version 3. * some changes 1. View detailed sharding information mongos > sh.status ()-Sharding Status-sharding versi

  2022-06-01 17:05:44 Views: 283
• 

  Oracle 11g R2 Network listener Lab

  In a single instance environment (not RAC), the listener and the instance must be on the same machine. Communication between the two machines must use a network protocol to communicate, if browsing the web requires the use of http protocol, remote connection requires the use of RDP/ssh/telnet, and so on. There is an or.

  2022-06-01 17:05:44 Views: 259
• 

  Oracle database import and export steps

  Database backup (export): first of all: connect to dba database method: connect to the database with sysdba, user name: sys password: oracle first method: sqlplus / nologconn sys/oracle@41SGEORA

  2022-06-01 17:05:44 Views: 286
• 

  The amount of MySQLl data is different, resulting in different indexes.

  1. Test environment: MySQL 5.7.172, test table structure mysql > show create table

  2022-06-01 17:05:43 Views: 212
• 

  How to view the version of mysql

  About MySQL MySQL is a relational database management system developed by MySQL AB in Sweden and belongs to Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the most

  2022-06-01 17:05:37 Views: 221
• 

  Add authentication for MongoDB

  MongoDB does not have account opening authentication by default, and unless public network access is not open, this mode is extremely insecure. It is recorded that the steps to add authentication are as follows: when you configure to create a user, you need to close: # authentication file used for communication between security:## replica sets # key

  2022-06-01 17:05:37 Views: 221
• 

  Commands for mysql to view database information

  MySQL is a relational database management system, which is developed by MySQL AB Company of Sweden and belongs to the product of Oracle. MySQL is one of the most popular relational database management systems, and MySQL is the best RD for WEB applications.

  2022-06-01 17:05:25 Views: 285
• 

  Statements for emptying table data in mysql database

  The mysql cleanup table data command has the following two statements: statement 1:delete from table name; statement 2:truncate table table name; comparison: (1) the delete statement without the where parameter can delete all inner parts of the mysql table.

  2022-06-01 17:05:20 Views: 241
• 

  Query and delete user information in Oracle

  Query all user information in Oracle, delete users, tables, prohibit foreign keys, etc. 1. View all users: select * from dba_users; select * from all_users; select

  2022-06-01 17:05:20 Views: 286
• 

  How to solve the problem that the mysql service cannot be started in the win7 system

  MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems, and MySQL is the best RDBM for WEB applications.

  2022-06-01 17:05:20 Views: 230