MySQL Basic Knowledge

MySQL版本: Server version: 5.1.44 Source distribution
修改root密码
如果没有密码使用下面的命令, 将密码设为"123456"
$ mysqladmin -u root password 123456
如果有密码使用下面的命令, 将密码改为"123456"
$ mysqladmin -u root -p password 123456
Enter password:
用户账户管理
添加账户:
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#user-account-management
提到的方法不适用:
mysql>
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'

IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
根据http://dev.mysql.com/doc/refman/5.1/en/adding-users.html所说, 要先create user, 然后再使用grant, 根据尝试, 在mysql中, 语句不区分大小写. 正确的方法如下:
mysql> create user 'frank'@'localhost' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'frank'@'localhost' INDENTIFIED BY '123456' WITH GRANT OPTION;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INDENTIFIED BY '123456' WITH GRANT OPTION' at line 1
mysql> GRANT ALL PRIVILEGES ON *.* TO 'frank'@'localhost' WITH GRANT OPTION;Query OK, 0 rows affected (0.00 sec)
mysql>
以上语句创建了名为"frank"的用户,  密码为"123456", 该用户为超级用户, 只能从local host登录.
mysql> create user 'frank'@'%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to 'frank'@'%' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql>
上面的语句创建了名为"frank"的超级用户, 密码为"123456", 该用户可以从任意主机登录. 创建localhost的"frank"用户是必须的:
It is necessary to have both accounts for
monty
to be able to connect from anywhere
as monty
. Without the
localhost
account, the anonymous-user
account for localhost
that is created by
mysql_install_db
would take precede