[root@china213 bin]# mysql -uroot -p
Enter password:
mysql> use mysql
Database changed
mysql> select host,user from user;
mysql> create user vmsdba identified by ‘vmsdba’;
Query OK, 0 rows affected (0.00 sec)
mysql> create database vms_db; #已经创建数据库就不用再创建了
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on vms_db.* to vmsdba;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
mysql> update user set host = ‘localhost’ where user = ‘root’ and host=’%’;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> flush privileges;
注:现在新版的sqlyog工具可以直接在客户端进行修改增加用户和授权了,比到命令行里面输入命令方便多了。
到工具–用户管理 界面可以看到详细的操作菜单的,如图所示:
历史上的今天:
- 2015: 2015079期双色球预测(0)
暂无评论