whiteblacksheep的博客

1.上传mysql5.6.23安装包到/usr/local/目录下 cd /usr/local rz命令上传mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz2.解压安装包，和修改名字 tar -zxvf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz mv mysql-5.6.23-linu...

一.用户管理1.新建用户>CREATE USER name IDENTIFIED BY 'ssapdrow';2.更改密码　>SET PASSWORD FOR name=PASSWORD('fdddfd');3.权限管理>SHOW GRANTS FOR name; //查看name用户权限>GRANT SELECT ON db_name.* TO n...

一.数据准备–部门表dept部门表(deptno部门编号/dname部门名称/loc地点)create table dept (deptno numeric(2),dname varchar(14),loc varchar(13));insert into dept values (10, ‘ACCOUNTING’, ‘NEW YORK’);insert into dept va...