Search
Common usage instructions / database related instructions
Instructions for server server connection to database
1、
How to connect MySQL database and MariaDB data source configuration instructions
2、
How to connect PostgreSQL data source configuration instructions
3、
How to connect Oracle data source configuration instructions
4、
How to connect Microsoft SQL Server data source configuration instructions
You can consult us for other databases
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