MySQL数据库用户管理求助 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MySQL数据库用户管理求助

MySQL数据库用户管理求助# Database - 数据库

l*n2000-10-22 07:10

1 楼

我想删除匿名用户，但是出错，怎么解决，谢谢！
$ /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49 to server version: 3.22.32-log
Type 'help' for help.
mysql> delete from user where user="";
ERROR 1046: No Database Selected
mysql> delete from user where user=" ";
ERROR 1046: No Database Selected
mysql> delete from user where user=' ';
ERROR 1046: No Database Selected
mysql> delete from user where user='';
ERROR 1046: No Databa

m*e2000-10-22 07:10

2 楼

MySQL can hold more than 1 databases. So you have to choose which
is the current one.
Type command 'use user;'

【在 l****n 的大作中提到】

: 我想删除匿名用户，但是出错，怎么解决，谢谢！
: $ /usr/local/mysql/bin/mysql -u root -p
: Enter password:
: Welcome to the MySQL monitor. Commands end with ; or \g.
: Your MySQL connection id is 49 to server version: 3.22.32-log
: Type 'help' for help.
: mysql> delete from user where user="";
: ERROR 1046: No Database Selected
: mysql> delete from user where user=" ";
: ERROR 1046: No Database Selected