本文共 671 字，大约阅读时间需要 2 分钟。

//登陆root#mysql -uroot -p//change to user mysql databasemysql> use mysql;//add user and passwordmysql>create user 'show_building'@'localhost' identified by 'this is his password';//create databasemysql>create database show_building;//change the access rightmysql> grant all privileges on show_building.* to show_building@localhost identified by 'his passwd';//flushmysql> flush privileges;//exit and re-login as the new user# mysql -ushow_building -p//show the database which linked to the usermysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || show_building      |+--------------------+2 rows in set (0.00 sec)

转载地址：http://kdcqi.baihongyu.com/