mysql用户创建授权_MySQL用户创建和授权

环境

MySQL 5.1 &＃43; 命令行工具

问题

MySQL用户创建和授权

解决

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

C:\Users\Wentasy>mysql -uroot -p

mysql> CREATE USER music IDENTIFIED BY &＃39;music&＃39;;

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(&＃39;0&＃39;, &＃39;1&＃39;))

);

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&＃64;localhost IDENTIFIED BY &＃39;music&＃39;;

4.以新创建的用户登录查看数据库

C:\Users\Wentasy>mysql -umusic -p

C:\Users\Wentasy>mysql -umusic -p

Enter password: *****

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.1.43-community MySQL Community Server (GPL)

Type &＃39;help;&＃39; or &＃39;\h&＃39; for help. Type &＃39;\c&＃39; to clear the current input statement.

mysql> show databases;

&＃43;--------------------&＃43;

| Database |

&＃43;--------------------&＃43;

| information_schema |

| music |

&＃43;--------------------&＃43;

2 rows in set (0.00 sec)

mysql> use music;

Database changed

mysql> show tables;

&＃43;-----------------&＃43;

| Tables_in_music |

&＃43;-----------------&＃43;

| tb_playlist |

| tb_records |

| tb_user |

&＃43;-----------------&＃43;

3 rows in set (0.01 sec)

mysql>

参考资料

&＃64;Wentasy 博文仅供参考&＃xff0c;欢迎大家来访。如有错误之处&＃xff0c;希望批评指正。原创博文如需转载请注明出处&＃xff0c;谢谢 :) [CSDN博客]