MySQL使用者建立和授權

環境

MySQL 5.1 + 命令列工具

問題

MySQL使用者建立和授權

解決

1.以 root使用者登入建立新使用者

C:\Users\Wentasy>mysql -uroot -p        mysql> CREATE USER music IDENTIFIED BY 'music';

2.以root使用者登入建立資料庫

create database music default charset utf8;        create table tb_user  (      tb_user_id int(11) primary key auto_increment,      tb_user_account varchar(32) not null,      tb_user_password varchar(16) not null,      tb_user_nick varchar(16) not null,      tb_user_name varchar(32) not null,      tb_user_gender bit(1),      tb_user_phone varchar(16) ,      tb_user_email varchar(40),      check(tb_user_gender in('0', '1'))  );        create table tb_playlist  (      tb_playlist_id int(11) primary key auto_increment,      tb_user_id int(11) not null,      tb_playlist_title varchar(255) not null,      constraint FK_TB_USER_ID foreign key(tb_user_id) references tb_user(tb_user_id)  );        create table tb_records  (      tb_records_id int(11) primary key auto_increment,      tb_playlist_id int(11) not null,      tb_records_name varchar(40) not null,      constraint FK_TB_PLAYLIST_ID foreign key(tb_playlist_id) references tb_playlist(tb_playlist_id)  );

3.以root使用者登入狀態使用者授權

mysql> GRANT ALL PRIVILEGES ON music.* TO music@localhost IDENTIFIED BY 'music';