MySQL用户创建和授权

MySQL 5.1 + 命令行工具

问题

MySQL用户创建和授权

解决

1.以 root用户登录创建新用户

C:UsersWentasy>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';

（编辑：济南站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!