MySQL 操作笔记 - Samuel Learning - BlogJava

View Post

MySQL 操作笔记

1. 分配权限给某个用户

GRANT ALL ON addressbooksample.* TO ming@localhost

2. 创建用户,并分权限

GRANT ALL ON addressbooksample.* TO lily@localhost IDENTIFIED BY "123"

3. 改变用户(包括root)的密码

use mysql;

update user set password=PASSWORD("000") where user="lily";

flush privileges;

4.安装Mysql服务到Windows服务

mysqld-nt -install

5.启动Mysql服务

net start mysql

6.卸载Mysql服务

mysqld-nt --remove

posted on 2005-12-09 19:23 MingIsMe 阅读(111) 评论(0) 编辑收藏所属分类: 10 Database