MySQL命令

qsbaq

                                               
用户root用户登陆
添加一个本地用户，名为username密码为password
GRANT ALL PRIVILEGES ON dbname.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION;
添加一个远程用户，名为username密码为password

GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'password' WITH GRANT OPTION;
添加完用户后要重新启动mysql服务
把messageboards.leaveword表的值追加到msgboards.leaveword表

               
               
               
                insert into msgboards.leaveword(name,title,content,belong) select name,ti
tle,content,belong from messageboards.leaveword;


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u2/60524/showart_474523.html