mysql的基本操作

登录

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