当然你也可以用下面的命令来设置密码:
mysql -u root mysql
mysql> update user set password=password('pass') where user='root';
为将要架设的站点建一个库及其用户
mysql -u root -p mysql
mysql> create database drupal;
mysql> use drupal;
mysql> grant all on drupal.* to
[email=drupal_user@localhost]drupal_user@localhost[/email]
;
mysql> use mysql;
Database changed
mysql> update user set password=password('pass') where user = 'drupal_user';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>\q;
mysqladmin reload