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)