登录
mysql -u root -p --default-character-set=utf8
创建用户步骤
//创建用户
create user '123456'@'%' identified by '123456';
create user '123456'@'127.0.0.1' identified by '123456';
//授权
GRANT ALL ON *.* TO '123456'@'%';
GRANT ALL ON *.* TO '123456'@'127.0.0.1';
//刷新
flush privileges;
更新root密码
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
#最新版MySQL请采用如下SQL:
mysql> UPDATE user SET authentication_string=PASSWORD('newpassword') where USER='root';
#5.刷新权限
mysql> FLUSH PRIVILEGES;
命令行基本操作
//显示所有的数据库
show databases;
//登录某个数据库
use Sir;
//显示某个数据库所有的表
show tables;
//显示某个表的列内容
show columns fome student;
//创建数据库
create database Sir;
//删除数据库
drop database Sir;
//导入已有数据
source /home/sir.sql