Programmer Help

The following is a summary of a Li's learning of MySQL built-in functions, hoping to help you; if you don't know mysql, you can read another blog of a Li first mysql Foundation 1: Date function 2: String function 1: Date function Function name describe current_date() Date of becom ...

My environment is the VMware virtual machine centos7. It's easier to install mysql in win environment, but it's hard to remember various commands when installing in linux. So I sorted out the installation process of Mariadb, Some centos7 has installed MariaDB by default. You can check whether you ha ...

Blog directory 1, Cacti 1. Introduction to Cacti 2. The function and characteristics of cacti 3. Data types of cacti monitoring 2, Install and configure Cacti monitoring server 1. Configure LAMP environment 2. Install SNMP and RRDTOOL tools 3. Deploy English cacti to connect mariadb 4. Client accessing English cacti's WEB interface 5. Deploy ...

(1) Part 1: basic jar package running (Tomcat does not need to be configured) [http://60.205.183.114:8081/] 1. Configure Alibaba cloud (Esc student server, image Centos7.7) and connect to the terminal remotely. 2. Install and configure the JDK (refer to https://www.jianshu.com/p/093413f2a04f)a) Install the jdk. b) Find the jdk path configurat ...

1. Implement vsftpd virtual user access based on mysql authentication This scenario is implemented using two servers, one ftp server and one database server 1.1 Install Database [root@c5 ~]#yum -y install mariadb-server [root@c5 ~]#systemctl start mariadb.service [root@c5 ~]#systemctl enable mariadb 1.2 Install vsftpd, mariadb-devel, pam-devel ...

Practice content Read 100,000 records from a table in MariaDB and write them to MongoDB after processing. Specific implementation 1. Create a new Spring Boot application that relies on the following: <!-- Web application --> <dependency> <groupId>org.springframework.boot</groupId> ...

1. Deploy the separated LAMP to two servers, and php loads the xcache module 1) Install httpd, PHP, PHP MySQL on c2 server [root@c2 ~]# yum install httpd php php-mysql -y 2) Installing the database mariadb server on the mariadb server [root@mariadb ~]# yum install mariadb-server -y 3) Start service [root@c2 ~]# systemctl start httpd [root@mari ...

rsyslog+mariadb+loganalyzer An architecture that can use web pages to view logs Environment preparation: just like the centralized log server architecture mentioned in the previous course, this architecture is built on the server, that is, the host with IP address of 192.168.1.55 Environment preparation and setting of server side Packages requ ...

By default, the password of the newly installed mariadb is empty. You can log in to the database by directly entering mysql in the shell terminal. If it is the first time you have just installed it, use the MySQL? Secure? Installation command to initialize it. # mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED ...

11. SSL configuration of proxysql configuration Note: during the writing time of the article from April 201904 to may 201905, subsequent official updates in github were not written~~ SSL Support 1, SSl settings [SSL configuration for backends] Starting with version v1.2.0e, ProxySQL supports SSL connections to the backend. An attempt to config ...