PengXiaoxun wrote:
I create a new account via the following statement:
CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
Without any privileges granted, the user 'monty' can access the database
information_schema via a remote host.
Why?
How can I create a new user without any privileges actually?
In the last episode (Mar 02), wang shuming said:
> Hi,
>
> Any table with a ordno char(n) not null field
>
> for example
>
> ordno qty
> 35
>0
>1
> 'abc' 3
> '000' 100
>
> select * from table1 where ordno>' ' or ordno=' '
> >
Hi,
Any table with a ordno char(n) not null field
for example
ordno qty
35
0
1
'abc' 3
'000' 100
select * from table1 where ordno>' ' or ordno=' '
> 5 rows
select * from table1 where ordno>=' '
> 2 rows
best regard!
Shumin
Information schema is a Virtual DB, the default "usage" grants privilege
will be there so he can see few databases like test, mysql and
Information_schema but cannot access any data.
If you want to restrict the remote connection, Specify the hostname instead
of '%' so users can only connect from th
I create a new account via the following statement:
CREATE USER 'monty'@'%' IDENTIFIED BY '123456';
Without any privileges granted, the user 'monty' can access the database
information_schema via a remote host.
Why?
How can I create a new user without any privileges actually?
Hi,
Any table with a ordno char(n) not null field
for example
ordno qty
35
0
1
'abc' 3
'000' 100
select * from table1 where ordno>' ' or ordno=' '
> 3 rows
select * from table1 where ordno>=' '
> 0 rows
best regard!
Shumin
Hi,
Beta version 5.011 of the BLOB streaming daemon for MySQL has been released.
The BLOB Streaming Daemon is a MySQL engine that runs as a daemon enabling
the storage and streaming of BLOB data directly in and out of a MySQL
database.
You can download the source code from http://www.blobstream
