Website Service Management System series of Tutorials (ix)

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

After we have installed the website service Management system WDCP, in the use process may appear this or that kind of question, below gives everybody to arrange the time to come out, facilitates everybody to study. Also do not know the words, you can go to the Wdlinux forum to find relevant tutorials.

1, WDCP How to deny or prevent other people's domain name malicious point

Because of the reasons for filing, also because of inspection reasons, sometimes, we can not allow someone else's domain name or illegal domain name point to us

However, we can not limit or control the direction of others, because the domain name control is not in our hands

But we can make restrictions on the server.

Very simple, just let the default IP access page, can not open, it

Specific to WDCP, how to operate?

1 if the default site has not been modified, just remove/www/web/default/index.php this file

2 If you have modified the default site, as long as the default site can not open the line, but to create a default site can not open

2, WDCP and a health installation package how to modify the MySQL data directory

The default installation directory for MySQL in WDCP and one-click packages is

/www/wdlinux/mysql Directory

The Data directory is

/www/wdlinux/mysql/var

What if the database is large or the partition is too little? Just put the database data in another directory or partition to

The method of operation can have several

1 Modifying/WWW/WDLINUX/ETC/MY.CNF files

2 using a partition to mount a directory or File connection form

Here, only the instructions to modify the my.cnf file, in fact, very simple

1 Create a storage directory, such as

Mkdir-p/data/mysql/var

2 Stop MySQL

Service Mysqld Stop

3 Modifying the configuration file

Vi/www/wdlinux/etc/my.cnf

Add the following line in the [mysqld] section

Datadir=/data/mysql/var

The following figure

Save exit

4 move or copy data to a new directory, as follows

cp-pr/www/wdlinux/mysql/var//data/mysql/

5 Start MySQL

Service mysqld Start

At this point, complete

MySQL data has been moved to the new directory

2, about the MySQL database root user password modification method and explanation

The WDCP management system stores MySQL root password to facilitate the creation and management of databases

At the same time, in order to consider security, after the first time in the background to modify the password, encrypted storage

In other words, the initial installation is good, is the clear text storage, background modification is the ciphertext storage.

File path and content, as follows

cat/www/wdlinux/wdcp/data/dbr.inc.php

$SQLROOTPW = ' wdlinux.cn ';

$SQLROOTPW _en= ' 0 ';

?>

$SQLROOTPW = Database Password

$SQLROOTPW _en= Indicates whether the password is encrypted

0 o'clock means unencrypted, 1 means encryption, the initial installation is as shown above, but the text is modified, the secret is saved if you want to modify this password, as shown above

In plain text, 0

Then, after the background modification, it automatically becomes ciphertext, 1

This encryption is implemented in the WDCP system, where the password is found to be incorrect or otherwise, such as the Phpmyadmin,mysql console to modify the root user password, can be directly in the above file can be modified

In the MySQL database corresponding database, you can set n user access, n address access

Corresponding user, you can also set access to n database, n address connection

Generally local is localhost or 127.0.0.1

For security reasons, the default is no remote access or connection.

3. How to open or set MySQL remote connection in WDCP background

But some how to open or set MySQL remote connection in the WDCP background special applications or requirements are required to remote connection, in the background of the WDCP set method, as follows

1 Login Background

2 MySQL Management

3 New database users, as shown below

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

Note: The IP in the host name, according to your actual situation to set, that is, you need to connect the remote IP, if you are a local connection, is your local Internet IP

If it's not connected yet, check to see if the firewall (iptables) has 3306 port access

This article is excerpted from Wdlinux Forum, reproduced please specify!