Re: Chinese characters not displaying in Workbench latest version

2011-11-21 Thread Michael Cole
I think what he was asking is, Are you running the Mysql workbench on the same machine? You may not have the correct Fonts. Being replicated the character sets of the two dbs should be the same have you checked that they actually are set to the same? On Monday, November 21, 2011 9:20:10 PM N

Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'

2011-07-12 Thread Michael Cole
He is pushing his own products here, Looking at other implications of moving to a NoSQL system I would stay with an SQL system. NoSql has its place, but maybe not in such an environment. http://blogs.adobe.com/asset/2011/04/nosql-but-even-less-security.html Regards Michael Cole. On

Re: Aggregation question

2008-04-23 Thread Michael Cole
or the whole day and did not make > much of a progress. If someone has any idea how to resolve this problem, > I'll appreciate a tip greatly. Make a new list of just dates then join them both together. -- Regards, Michael Cole LPIC-1 "The man who

Re: Decimal - Maximum is 30

2008-01-31 Thread Michael Cole
On Friday 01 February 2008 7:32:33 am Warren Young wrote: > The average grain of sand is a bit smaller than a millimeter.  There are > a million millimeters per kilometer. > > 10^11 * 10^13 * 10^6 = 10^30 > > In other words, the current system is sufficient for establishing the > location of every

Re: Newbie: A single number

2008-01-21 Thread Michael Cole
You have two rows the zero which has a single row and the other row If the answer you are after is 48. select sum(ct_ct_comment_agent) from (SELECT comment_approved, COUNT(comment_agent) as ct_comment_agent from wp_comments WHERE comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by comme

Re: Unbiased opinion needed on access control procedure

2007-10-11 Thread Michael Cole
Dont trust anything, The more secure you can be the better, What happens if you have not patched a single server (maybe you are testing) then someone gets into it and then has unrestricted access to all the DB's.. Never trust your own users even, If the data is worth money to you it is worth more

Re: secure host and user name for non static ip address

2007-10-11 Thread Michael Cole
My take on this never have no password.. At no time any data you have someone else will also want therefore running a open query with nopasword on the system for a couple of hours will get access to your system.. Allways use passwords, If the users dont want passwords then you dont need any membe

Re: ERROR 2002 (HY000): Can't connect to local MySQL server

2007-06-20 Thread Michael Cole
gt; > > > > # Default to using old password format for > > > > compatibility with old and > > > > > # shorter password hash. > > > # Reference: > > http://dev.mysql.com/doc/mysql/en/Password_hashing.html > > > > old_passwords=1 > > >

Re: how to enable logging, MySQL 5.0.37 FreeBSD 6.2

2007-04-24 Thread Michael Cole
:19 Ray wrote: > I am trying to debug another application and I need to enable logging of > all queries (temporary only) to MySQL (5.0.37). OS is FreeBSD 6.2. MySQL > installed from ports. -- Regards Michael Cole -- MySQL General Mailing List For list archives: http://lists.mysql.com

Error 1111 (Weird.)

2007-04-16 Thread Michael Cole
sections and in those sections it has many unions. Any ideas would be greatly apperciated. -- Regards Michael Cole -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]