由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - MySQL数据库用户管理求助
相关主题
mysql -- could not use the databasemySQL DELETE怎么都是error,哪里不对而来?
winmysqladmin中的databases不显示数据库MySQL语句请教
zz: Oracle推出免费数据库产品Entry Level SQL Server Database Professional position available from EGI
database project请教MySQL database backup
bbs.mit.edu 的database 是咋样的?1个DBA,一个系统管理员
anonymous login in mysql?请教个数据管理的问题
help!!! who's familiar with mysql command[合集] 数据库这门课值得学吗?
快速搜索very large database的问题问个数据库问题
相关话题的讨论汇总
话题: mysql话题: user话题: error话题: database话题: 1046
进入Database版参与讨论
1 (共1页)
l****n
发帖数: 12
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*****e
发帖数: 126
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

dy
发帖数: 12
3
Should be "use mysql" ba. That's the database which holds the "user" table.

【在 m*****e 的大作中提到】
: MySQL can hold more than 1 databases. So you have to choose which
: is the current one.
: Type command 'use user;'

m*****e
发帖数: 126
4
Yes, you are right! There is no such thing as a user database.

【在 dy 的大作中提到】
: Should be "use mysql" ba. That's the database which holds the "user" table.
1 (共1页)
进入Database版参与讨论
相关主题
问个数据库问题bbs.mit.edu 的database 是咋样的?
如何实现DB底层的功能?anonymous login in mysql?
[转载] 关于网站数据库的一个问题help!!! who's familiar with mysql command
建一个小的购物网站,数据库用什么比较合适?快速搜索very large database的问题
mysql -- could not use the databasemySQL DELETE怎么都是error,哪里不对而来?
winmysqladmin中的databases不显示数据库MySQL语句请教
zz: Oracle推出免费数据库产品Entry Level SQL Server Database Professional position available from EGI
database project请教MySQL database backup
相关话题的讨论汇总
话题: mysql话题: user话题: error话题: database话题: 1046