1、安装perl程序
1 2 | yum -y install perl-Time-HiResyum -y install perl-DBI |
1 2 3 4 5 6 7 8 9 | service mysqld stop/usr/bin/mysqld_safe --skip-grant-tables &use mysql;update user set password=password(‘yournewpasswordhere‘) where user=‘root‘;flush privileges;exit;#远程访问access deniedGRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘admina‘ WITH GRANT OPTION;flush privileges; |
1、分组拼接（GROUP_CONCAT）
1 2 3 4 5 | net stop mysqlmysqld —removemysqld —install MySQL —defaults-file=D:/Mysql/my.ininet start mysql#表要重新建 |
原文：http://www.cnblogs.com/apescode/p/6247318.html