登录
mysql -uroot -p
查看数据库
SHOW DATABASES;
创建数据库
CREATE DATABASE bottle;
删除数据库
DROP DATABASE bottle;
选择数据库
USE bottle;
查看有哪些用户
SELECT host,user,password FROM mysql.user;
创建用户
CREATE USER 'bottle' IDENTIFIED BY 'abcdPassword';
删除用户
DROP USER bottle;
为用户分配权限
GRANT ALL ON bottle.* TO 'bottle';
flush privileges;
查看表结构
desc t_user;
服务的启动和停止
service mysqld start
service mysqld stop
service mysqld restart
/etc/inint.d/mysqld start
/etc/inint.d/mysqld stop
/etc/inint.d/mysqld restart
网友评论