|
MySQL常见操作命令汇总
1.查看所有的数据库
mysql>show databases;
2. 创建数据库
mysql>create database databasename;
3. 删除数据库
mysql>drop database databasename;
4. 创建用户
mysql>CREATE USER ‘username’@‘host’IDENTIFIED BY ‘password’;
5.显示所有用户
mysql>SELECT DISTINCT CONCAT ('User:''',user,'''@''',host,''';')As query FROM mysql.user;
未完待续
Archiver|手机版|科学网 ( 京ICP备07017567号-12 )
GMT+8, 2024-9-25 06:19
Powered by ScienceNet.cn
Copyright © 2007- 中国科学报社