这里会显示出您选择的修订版和当前版本之间的差别。
— |
vps:mysql:user-add-delete [2011/09/14 14:42] (当前版本) |
||
---|---|---|---|
行 1: | 行 1: | ||
+ | ====== mysql添加用户、更改密码 ====== | ||
+ | |||
+ | ===== mysql创建数据库 ===== | ||
+ | | ||
+ | |||
+ | 建立数据库gamesp | ||
+ | |||
+ | create database gamesp; | ||
+ | |||
+ | ===== MySQL添加用户 ===== | ||
+ | |||
+ | |||
+ | grant all on 数据库名.* to 用户名@localhost identified by '密码'; | ||
+ | |||
+ | |||
+ | grant all on gamesp.* to newuser@localhost identified by 'password'; | ||
+ | |||
+ | 说明: | ||
+ | |||
+ | (1)grant all 赋予所有的权限 | ||
+ | |||
+ | (2)gamesp.* 数据库 gamesp 中所有的表 | ||
+ | |||
+ | (3)newuser 用户名 | ||
+ | |||
+ | (4)@localhost 在本地电脑上的 mysql server 服务器 | ||
+ | |||
+ | (5)identfified by 'password' 设置密码 | ||
+ | |||
+ | |||
+ | |||
+ | ===== MySQL删除用户 ===== | ||
+ | <code> | ||
+ | use mysql | ||
+ | mysql>Delete FROM user Where User="xxxxx" and Host="localhost"; | ||
+ | mysql>flush privileges; | ||
+ | </code> | ||
+ | |||
+ | |||
+ | ===== MySQL修改密码 ===== | ||
+ | <code> | ||
+ | mysqladmin -uroot -plk317921web password "111111" | ||
+ | </code> |