Connection database configuration instructions, database installation instructions, database command instructions - WGCLOUD

Common usage instructions / database related instructions

Instructions for connecting the server to the database (the following databases are supported as data sources to store data)

1、MySQL database, MariaDB database connection configuration instructions
2、PostgreSQL database connection configuration instructions
3、Oracle database connection configuration instructions
4、openGauss database connection configuration instructions
5、OceanBase database connection configuration instructions
6、Microsoft SQL Server database connection configuration instructions
7、Kingbase database connection configuration instructions
8、Dameng database connection configuration instructions
For PolarDB database connection, please refer to the instructions in (1) or (2) above. For Wanli database connection, please refer to the instructions in (1) above. For other databases, please consult us

Instructions for database installation, creation, export, and import

1、Download MySQL 5.7 installation package
2、MySQL settings allow ROOT remote access：MySQL 5.7 or 5.6 Description ，MySQL8 Description
3、MySQL commands for creating databases, importing SQL files, and exporting databases
4、How to set MySQL case insensitive in Linux
5、If the password setting for MySQL 5.7 does not take effect, enter the following command to process it
6、PostgreSQL commands for creating databases and importing SQL files
7、Encrypt the database username and password in the configuration file
8、CentOS 7 offline installation of MySQL 5.7
9、CentOS 8 installs MySQL 8 using yum
10、Ubuntu 20 installs MySQL 8 using the apt method
11、Ubuntu 20 installs PostgreSQL using the apt method
12、Linux installation instructions for PostgreSQL