Website Service Management System WDCP series of Tutorials (vii)

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

After everyone installs 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 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

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

To create a database and database user in the WDCP background, you must have the root password in the WDCP, otherwise you cannot create

So, some users say that after phpMyAdmin modified the root password, it is not possible to create, that is for sure, because you changed the root password, but WDCP do not know, do not know what the new password is, that can also create? The answer is definitely not.

So how do you correct the root user's password? Isn't it hard to change it, of course not?

As long as in the background of the WDCP can be modified, it is strongly recommended in the WDCP background, the following figure

Is there a way to do that if it has been modified or modified elsewhere?

There's a description of the connection above.

or modified with this tool, the wdcp2.2 version begins to provide

Log on to the server with SSH

sh/www/wdlinux/tools/mysql_root_chg.sh

It's okay.

This tool is modified and can also be modified when you forget the root user password, which is mandatory

Note: The root user in this case is the root user in the MySQL database, not the root user of the Linux system.

This tutorial is excerpted from Wdlinux forum Http://www.wdlinux.cn/bbs, reprint please specify!

Website Service Management System WDCP series of Tutorials (i)

Website Service Management System WDCP series of Tutorials (ii)

Website Service Management System WDCP series of Tutorials (iii)

Web Service Management System WDCP series of Tutorials (iv)

Web Service Management System WDCP series of Tutorials (v)

Web Service Management System WDCP series of Tutorials (vi)