Website service management system wdcp series Tutorial 9

After we have installed the website service management system wdcp, we may have questions like this or that during use. Below are some points for you to learn. If you do not know anything, go to the wdlinux forum to find related tutorials. 1. how does wdcp reject or block others' domain names... after we have installed the website service management system wdcp, we may have questions like this or that during use. Below are some points for you to learn. If you do not know anything, go to the wdlinux forum to find related tutorials.
1 , Wdcp How to reject or block malicious targeting of others' domain names
Because of record filing and check, sometimes we cannot allow someone else's domain name or illegal domain name to direct to US
However, we cannot limit or control the direction of others, because the domain name control is not in our hands.
But how can we limit it on the server?
It's easy. you only need to allow the default IP address to access the page and cannot open it.
What should I do in wdcp?
1. if you have not modified the default site, just delete the/www/web/default/index. php file.
2. if you have modified the default site, you only need to open the default site, but you can create a default site that cannot be opened.
 
2 , Wdcp How to modify mysql with the Yijian installation package Data Directory
The default installation directory of mysql in wdcp and one-click package is
/Www/wdlinux/mysql Directory
The data directory is in
/Www/wdlinux/mysql/var
What should I do when the database capacity is large or the partition space is too small? You only need to put the database data in another directory or partition.
The operation methods can be as follows:
1. modify the/www/wdlinux/etc/my. cnf file
2. use the partition Mount directory or file connection form
Here, only the description of modifying the my. cnf file is actually very simple.
1. create a storage directory, as shown in figure
Mkdir-p/data/mysql/var
2. stop mysql
Service mysqld stop
3. modify the configuration file
Vi/www/wdlinux/etc/my. cnf
Add the following line in the [mysqld] section:
Datadir =/data/mysql/var
For example

Save and exit
4. move or copy the data to the new directory, as shown below:
Cp-pR/www/wdlinux/mysql/var // data/mysql/
5. start mysql
Service mysqld start
So far, complete
Mysql data has been moved to the new directory.
2. Methods and instructions for changing the password of the root user in the mysql database
The wdcp management system stores the root user password of mysql to facilitate the creation and management of databases.
At the same time, for security considerations, after the password is changed for the first time in the background, the encrypted storage
That is to say, after the initial installation, the plaintext storage is used, and after the background modification, the ciphertext storage is used.
The file path and content are as follows:
Cat/www/wdlinux/wdcp/data/dbr. inc. php
　　
$ Sqlrootpw = 'wdlinux. cn ';
$ Sqlrootpw_en = '0 ';
?>
$ Sqlrootpw = indicates the database password
$ Sqlrootpw_en = indicates whether the password is encrypted.
0 indicates that the password is not encrypted. 1 indicates that the password is encrypted. the plaintext is displayed as shown in the preceding figure during initial installation. However, after modification, the ciphertext is saved. if you want to modify the password, it is shown as above.
In plaintext, 0
Then, after the background is modified, it will automatically become the ciphertext, 1
This encryption is implemented in the wdcp system. if you find that the password is incorrect or you have modified the root user password in other methods, such as phpmyadmin or mysql console, you can directly modify it in the above file.
 
You can set N user access and N address access for the corresponding database in the mysql database.
You can also set up to access N databases and connect to N addresses.

Generally, localhost or 127.0.0.1 is used locally.
For security, remote access or connection is disabled by default.

3 How to enable or set mysql remote connection in the wdcp background
However, how to enable or set up remote connection for mysql in the wdcp background requires remote connection. The following describes how to set up remote connection in the wdcp background:
1. log on to the background
2. mysql management
3. create a database user, as shown in figure


Replace the username, password, IP address, and database with what you want.

Note: the IP address in the host name is set according to your actual situation, that is, the remote IP address you need to connect to. if you are using a local connection, it is the IP address of your local internet access.

If the connection is not available after it is added, check whether the firewall (iptables) has enabled access to port 3306.
 
This tutorial is taken from the wdlinux Forum http://www.wdlinux.cn/bbs/. for more information, see!