登陆:
# mysql -u root -p
退出:
mysql>\q
修改root密码:
mysql>set password for root@localhost = password('新密码');
查询所有数据库:
mysql> show databases;
查看用户:
mysql> use mysql;
mysql>select user from user;
添加用户:
mysql> use mysql;
mysql> create user 'username'@'host' identifiend by 'password';
删除用户:
mysql> use mysql;
mysql> drop user 'user'@'host';
查看单个用户所有情况:
mysql> use mysql;
mysql>select * from mysql.user where user='root'\G
-- \G使每个字段打印到单独的行,也有;的作用
给用户添加所有权限:
mysql> grant
-> all privileges
-> on *.*
-> to user@'host'
-> identified by 'password';
创建数据库设置编码为utf8:
create database 数据库名 character set utf8;
alter database 数据库 default character set utf8;
mysql常用指令登陆:# mysql -u root -p退出:mysql> \q修改root密码:mysql> set password for root@localhost = password('新密码');查询所有数据库:mysql> show databases;查看用户:mysql> use mysql;mysql> select user from user;添加用户:mysql> use mysql;mysql>