Mysql命令

1 . 如果想使用’user’和 ‘password’从任何主机连接到mysql服务器的话.

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

2 . 如果你想允许用户myuser从ip为192.168.1.6的主机连接到mysql服务器，并使用mypassword作为密码.

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

3 . 创建utf8数据库

CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

4 . 创建gbk数据库

CREATE DATABASE IF NOT EXISTS yourdb DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;