几条有用的MySQL命令
Sunday, 21. May 2006, 00:14:17
建库时指定编码：
CREATE DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
赋予用户权限：
GRANT ALL PRIVILEGES ON dbname.* TO dbuser@localhost IDENTIFIED BY "dbpass";
错误“ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client.”的对策：
SET PASSWORD FOR dbuser@"localhost"=OLD_PASSWORD('yourPassword');
CREATE DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
赋予用户权限：
GRANT ALL PRIVILEGES ON dbname.* TO dbuser@localhost IDENTIFIED BY "dbpass";
错误“ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client.”的对策：
SET PASSWORD FOR dbuser@"localhost"=OLD_PASSWORD('yourPassword');
WIDGETIZE