mysql -u root -p
create database biobank;
use biobank;
mysql->source 路径/xx.sql
create user 'dummy'@'localhost' IDENTIFIED BY 'ozzy498';
grant all privileges on biobank.* to 'dummy'@'localhost' ;
reset password=>set password for 'dummy'@localhost=password('ozzy498');
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
create database biobank;
use biobank;
mysql->source 路径/xx.sql
create user 'dummy'@'localhost' IDENTIFIED BY 'ozzy498';
grant all privileges on biobank.* to 'dummy'@'localhost' ;
reset password=>set password for 'dummy'@localhost=password('ozzy498');
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;