# 创建用户
create user 'user01'@'127.0.0.1' identified by '666666';
# 赋予全部权限
grant all privileges on *.* to 'user01'@'127.0.0.1' identified by '666666';
# 赋于指定权限
grant select,insert on <database>.<table> to '<user>'@'<ip>' identified by '<password>';
远程
select host from user where user ='root'
update user set host = '%' where user = 'root';
flush privileges;
存储过程
基本语法
-- 创建存储过程
delimiter $$
create procedure proc01()
begin
select empno,ename from emp;
end $$
delimiter ;
-- 调用存储过程
call proc01();
插入测试数据
delimiter $$
create procedure proc_batch_insert()
begin
declare pre_name bigint;
declare ageval int;
declare i int;
set pre_name = 187635267;
set ageval = 100;
set i = 1;
while i < 10000000 do
insert into t_user(name,age, create_time, update_time)
values(concat(pre_name,'@test.com'), (ageval+1)%30, now(), now());
set pre_name = pre_name + 1;
set i = i + 1;
end while;
end $$
delimiter ;
-- 调用存储过程
call proc_batch_insert();
三、常见问题
A、mysql 区分表名字大小写
问题具体描述：linux下mysql区分表名大小写，window下表明不区分大小写
可以通过show global variables like '%lower_case%'; 查看该值设置
