http://www.gsywx.com/index.php zh-cn http://www.gsywx.com/read.php/38.htm#blogcomment10 xiaoyuwxz <wxz@gsywx.com> Sat, 23 Oct 2010 06:28:23 +0000 http://www.gsywx.com/read.php/38.htm#blogcomment10
修改MY.INI
在文件底部添加
skip-grant-tables
重启启动MYSQL
cmd运行 mysql -u root -p
update user set password=PASSWORD("密码") where user='root';
这时密码已修改好
再修改MY.INI
删除
skip-grant-tables
重启启动MYSQL ]]> http://www.gsywx.com/read.php/46.htm#blogcomment9 xiaoyuwxz <wxz@gsywx.com> Sat, 17 Jul 2010 02:21:35 +0000 http://www.gsywx.com/read.php/46.htm#blogcomment9 如新增用户: ktm
useradd ktm -g www -d /wwwroot/ktm -s /sbin/nologin
echo "ktm" >> /etc/vsftpd/chroot_list
service vsftpd restart ]]> http://www.gsywx.com/read.php/38.htm#blogcomment7 xiaoyuwxz <wxz@gsywx.com> Tue, 20 Apr 2010 16:46:36 +0000 http://www.gsywx.com/read.php/38.htm#blogcomment7 1、只支持mysql5.0.x系统的mysql进行密码的复位，未能判断mysql版本，并进行复位
2、不支持带空格的目录路径 ]]> http://www.gsywx.com/read.php/19.htm#blogcomment5 xiaoyuwxz <wxz@gsywx.com> Thu, 04 Oct 2007 08:19:12 +0000 http://www.gsywx.com/read.php/19.htm#blogcomment5
net stop mysql
net stop w3svc
net stop iisadmin /y
deltree /y D:\beifen\1
md D:\beifen\1
E:\Progra~1\WinRAR\winrar a -y D:\beifen\1\mysql.rar D:\PHPsetup\mysql\data
net start mysql
net start w3svc
net start iisadmin

deltree改用直接删除D:\beifen\1目录，加快了删除目录的执行，然后再创建目录，所以，第一次在做的时候不用手动创建D:\beifen\1这个目录
我测试了下我的服务器174M的数据库压缩为27M，节省了好多磁盘空间。

计划任务一次性添加，执行以下批处理即可。

at 3:00 /every:M d:\beifen\1.bat
at 3:00 /every:T d:\beifen\2.bat
at 3:00 /every:W d:\beifen\3.bat
at 3:00 /every:Th d:\beifen\4.bat
at 3:00 /every:F d:\beifen\5.bat
at 3:00 /every:S d:\beifen\6.bat
at 3:00 /every:Su d:\beifen\7.bat ]]> http://www.gsywx.com/read.php/4.htm#blogcomment3 有问题！！！ <user@domain.com> Wed, 12 Sep 2007 16:16:27 +0000 http://www.gsywx.com/read.php/4.htm#blogcomment3 http://www.gsywx.com/read.php/7.htm#blogcomment1 xiaoyuwxz <wxz@gsywx.com> Thu, 02 Aug 2007 02:55:23 +0000 http://www.gsywx.com/read.php/7.htm#blogcomment1