[ANN] Beta release v05.011 of the BLOB Streaming Daemon
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.blobstreaming.org/download. For more details see: http://www.blobstreaming.org/documentation or visit my BLOG at http://bpbdev.blogspot.com Some of the new features in 5.011: - S3 storage of BLOBs is now supported. - Backup will backup BLOBs stored in S3 on the S3 server itself. - The PBMS enabled MySQL java connector has been updated and is now working again. - The PrimeBase Media Streaming web site has been updated and the documentation has been made more user friendly. If you have any questions or comments feel free send them directly to me. Barry - Barry Leslie SNAP Innovation Softwareentwicklung GmbH Senior Software Engineer Tel: (001) 250 595 4228 Fax: (001) 250 595 4233 Email: barry.les...@primebase.com Web: www.PrimeBase.com SNAP Innovation Softwareentwicklung GmbH, D-22765 Hamburg, Max-Brauer-Allee 50, Germany Amtsgericht Hamburg HRB 61066, Geschäftsführer: Ulrich Zimmer, Paul McCullagh - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
5.1.42 community version select ordno=' ' error
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! Shuming Wang
Default privileges of a new user?
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?
Re: Default privileges of a new user?
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 that host alone. -- Thanks Suresh Kuna MySQL DBA 2010/3/2 PengXiaoxun fikm...@163.com 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?
5.1.42 community version select ordno=' ' error (2)
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! Shuming Wang
Re: 5.1.42 community version select ordno=' ' error (2)
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=' '
5 rows
select * from table1 where ordno=' '
2 rows
I cannot reproduce this, with either mysql 5.1.35 or 5.5.1-m2:
mysql create table table1 (ordno char(3) not null);
Query OK, 0 rows affected (0.00 sec)
mysql insert into table1 values (' '),(' '),(' '),('000'),('abc');
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
mysql select * from table1 where ordno=' ';
+---+
| ordno |
+---+
| |
| |
| |
| 000 |
| abc |
+---+
5 rows in set (0.00 sec)
mysql select * from table1 where ordno' ' or ordno=' ';
+---+
| ordno |
+---+
| |
| |
| |
| 000 |
| abc |
+---+
5 rows in set (0.00 sec)
mysql
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Default privileges of a new user?
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? You need to complete your installation by removing the anonymous user accounts. This is described here in the Installation portion of our manual: http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html Then issue the command SHOW GRANTS FOR 'monty'@'%'; http://dev.mysql.com/doc/refman/5.1/en/show-grants.html If the only privilege this user has is 'USAGE' then the only privilege they have is the ability to authenticate with the MySQL instance. This is a 'no-privileges' account. http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_usage Additional explanation of how MySQL security works is located in the following sections of Chapter 5 of the manual: http://dev.mysql.com/doc/refman/5.1/en/security.html http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html http://dev.mysql.com/doc/refman/5.1/en/user-account-management.html -- Shawn Green MySQL Principle Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
