标题: mysql 的基本使用一 [打印本页] 作者: 88513539 时间: 2011-6-26 12:54 标题: mysql 的基本使用一 windows下
C:\mysql5\bin>mysql -uroot -panywolfs.com
/删除现有的数据
drop database anywolfs_db;
/创建数据库
create database anywolfs_db;
/创建用户
create user anywolfs(用户) identified by 'anywolfs.com(密码)';
/查看所有数据库
show databases;
/查看系统表
use mysql;
show tables;
/查看所有用户
select * from user;
/修改用户的密码
update user set password=password('anywolfs.com') where user='anywolfs';
或者(linux下)：
/usr/local/mysql/bin/mysql -uroot -panywolfs -e "update user set password=PASSWORD('00000000') where user='anywolfs'" mysql
/usr/local/mysql/bin/mysql -uroot -pbips2000 -e "flush privileges" mysql
/为用户赋权
grant select,insert,delete,create,drop on anywolfs_db.* (*.* 或test.*/user.*/..) to anywolfs@localhost (用户@localhost/用户@%/用户@127.0.0.1) identified by '密码'；