centos7 builds wordpress blog

Install apache yum install -y httpd Start apache systemctl start httpd Set apache to power on automatically systemctl enable httpd Access public network address to check whether apache is normal Install MySQL database wget -i http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10 ...

Posted by pedroteixeira07 on Mon, 11 May 2020 19:01:44 +0200

11. MySQL View Learning Notes (Detailed)

view Meaning: Understand as a virtual table and use it like a regular table A new feature of MySQL version 5.1 is data generated dynamically from tables For example: a comparison between a dance class and an ordinary class Differences between views and tables: Name Create Grammar Keyword Use Occupy physical space view ...

Posted by coolbeansdude51 on Sun, 10 May 2020 09:10:57 +0200

PHP-7.1.6 source compilation and installation

Explain php5 and php7 can be installed in an apache server at the same time, but only one of them can run. The other needs to comment out the corresponding LoadModule in the apache configuration file 1. Download and install [root@dl-001 src]# wget http://cn2.php.net/distributions/php-7.1.6.tar.gz [root@dl-001 s ...

Posted by cdinca on Tue, 05 May 2020 20:06:12 +0200

Compile and install MariaDB-10.1.30

Environment related: OS: CentOS release 6.9 IP: 192.168.1.10 CPU: 4 cores MEM: 2G DISK: 50G 1. Experiment host clone Refer to "CentOS6 experimental machine template building and deployment" Clone an experimental machine, adjust the memory to 2G and the CPU to 4 cores, and further configure the host na ...

Posted by geus on Tue, 05 May 2020 08:37:43 +0200

Slow log of MySQL Event scheduled tasks

Preface Recently, we are trying to use a log system, graylog, to collect the slow query log of mysql for subsequent analysis, monitoring and alarm. The test steps have been completed and the logs have been collected successfully. During the test, you need to brush some slow query logs. In order to brush more logs and not have a greater impact o ...

Posted by murp32 on Mon, 04 May 2020 13:43:41 +0200

MySQL 5.7 SSL configuration and enable

1, Start SSL on installation [root@linux-node local]# /usr/local/mysql5.7/bin/mysqld --initialize --basedir=/usr/local/mysql5.7 --datadir=/usr/local/mysql5.7/data/ --user=mysql [root@linux-node local]# /usr/local/mysql5.7/bin/mysql_ssl_rsa_setup After running this command, the following pem files will be generated in the data directory by ...

Posted by matty on Mon, 04 May 2020 06:00:33 +0200

java socket realizes the server, and the client has simple network communication. Chat

There are some serious bug s in the code written before to realize simple network communication. Write in detail later. According to the last code, mainly increased the user registration, login page, and realized the real-time display of the current login status of the number of people. And solve some bug s not found last time. (refer to previo ...

Posted by Byron on Mon, 04 May 2020 03:09:22 +0200

Using rundeck scheduler to set up sending mail

1. Configure QQ mailbox to send mail 1.1 enable the SMTP service and obtain the authorization code 1.2 select account Start related services and generate authorization code 2. Enable sendmail service and postfile service [root@zydatahadoop001 rundeck]# service sendmail stop [root@zydatahadoop001 rundeck]# chkconfig sendmail off [r ...

Posted by shivangp on Sun, 03 May 2020 23:51:10 +0200

Force sql to use an index

SQL HINT (SQL HINT) is an important means to optimize the database, which is to add some hints in sql to optimize the effect. Let's learn about use index, ignore index, and force index; 1. Add use index after the query statement. You can suggest indexes to MySQL for reference, so that MySQL does not consider other indexes. explain select co ...

Posted by daniel244rock on Sat, 02 May 2020 20:40:36 +0200

MySql Foundation - Building MySql Database: Installing MySql-server, MySql-client

1 Build MySQL Server1.1 Question This case requires familiarity with the use of MySQL's official installation package to quickly build a database server: Install MySQL-server, MySQl-client packagesModify the password of the database user rootConfirm MySQL service program is running and root is controllable 1.2 Program This course will use the ...

Posted by beaux1 on Sat, 02 May 2020 18:45:31 +0200