1.登录数据库指令:
mysql -u root -p
一般来说,root为默认超级用户。
2.创建一个数据库:
create database xxx;
创建一个名为xxx的数据库。
3.查看所有的数据库的库名:
show databases;
±-----------------------+
| Database |
±-----------------------+
| db_student_manager_web |
| information_schema |
| mysql |
| performance_schema |
| spider |
| sys |
| weixin |
±-----------------------+
4.查看数据库用户的权限:
show grants for xxx@localhost;
±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
±-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------