首页 › MySQL › mysql 建立数据库 和用户

a6985600 发表于 2013-1-29 16:21:10

mysql 建立数据库 和用户

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;

查看完整版本: mysql 建立数据库 和用户