每次搭建mysql数据库都要网上找找相关的命令。很麻烦,就想写一篇全的,备忘一下。
首先 登陆mysql
mysql -u root -p
创建一个数据库
CREATE DATABASE stfoa;
然后呢,给这个数据库添加一个执行用户
insert into mysql.user(Host,User,Password) values('localhost','stfoa',password('stfoa'));
insert into mysql.user(Host,User,Password) values('%','stfoa',password('stfoa'));
flush privileges; //提交
给这个用户赋权
grant all privileges on stfoa.* to stfoa@localhost identified by 'stfoa';
grant all privileges on stfoa.* to stfoa@'%' identified by 'stfoa';
flush privileges; //提交