Re: Chinese characters not displaying in Workbench latest version
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 Neil Tompkins wrote: MySQL workbench On 21 Nov 2011, at 13:36, Chris Tate-Davies chris.tatedav...@inflightproductions.com wrote: What are you using to view the data? On Mon, 2011-11-21 at 08:22 -0500, h...@tbbs.net wrote: ; 2011/11/20 20:27 +, Tompkins Neil Does anyone know why Chinese characters are not displaying correctly in a replicated database on a slave machine ? I'm just getting square boxes. What displays them? it sounds to me as if the display lacks something, not so much MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Facebook Trapped In MySQL a 'Fate Worse Than Death'
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 Wednesday 13 July 2011 7:33:43 am Hank wrote: Given the choice between doing right the first time, or having the second largest site on the internet, I'll take the latter, and deal with the problems of not doing it right the first time. -Hank On Tue, Jul 12, 2011 at 10:45 AM, Jerry Schwartz je...@gii.co.jp wrote: Let this be a lesson to all of those designers who say That will never happen. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Aggregation question
On Thursday 24 April 2008 12:26:09 pm Gary Greenberg wrote: except that there is no entry for April 20th as there were no transactions at that day. I need a query to return me zero for that day. I.e. I need uninterrupted sequence of dates. I am beating my head at this problem for 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 does not read good books has no advantage over the man who can't read them. - Mark Twain It is our choices, Harry, that show what we truly are, far more than our abilities. — J. K. Rowling Wear the old coat and buy the new book. — Austin Phelps I'm not a teacher: only a fellow traveler of whom you asked the way. I pointed ahead – ahead of myself as well as you. — George Bernard Shaw -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Decimal - Maximum is 30
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 grain of sand in the universe at this scale. If we rescale by making use of the digits we're allowed to the left of the decimal point, we can probably describe the location of every atom in the universe instead. You must be working on something absolutely mind-blowing for this amount of precision to be insufficient. I think you missed something in your formula, You just have a 1 dimension dealt with here. That would be every grain in that line. But when i first read the statement before i had the same conclusion that 10^30 would normally be enough for anyone, I noticed years ago Nasa used MYSQL -2000 to be exact.. NASA switches from Oracle to MySQL In November a team at NASA's Marshall Space Flight Center finished the transition of the NASA Acquisition Internet Service (NAIS) from Oracle to MySQL. NAIS sends e-mail notifications to users based on specified interests and enables users to query the Web site (nais.nasa.gov) for updated opportunities. Dwight Clark, project leader of NAIS, claims to have noticed an increase in speed of performance without experiencing any problems. The switch to Open Source software was primarily driven by costs, and MySQL was found to be the most robust product available. The President's Information Technology Advisory Committee recommended in September that the federal government encourage open-source software as an alternative for software development for high-end computing and allow open-source development efforts to compete on a level playing field with proprietary solutions in government procurements. Read the whole story at Federal Computer Week: http://www.fcw.com/fcw/articles/2000/1204/pol-nasa-12-04-00.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Newbie: A single number
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 comment_approved )as a On Monday 21 January 2008 6:07:46 pm Mário Gamito wrote: Hi, I'm trying to get a single number out of a SELECT statement: SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by comment_approved But instead i get two rows: |-- |comment_approved | COUNT (comment_agent) | |-- |0| 1 | |-- |1|47 | |-| I've Google about it but found no answer (my bad, probably). What I want is to have just 47 as a result of the SELECT. Any help would be appreciated. Warm regards, Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: secure host and user name for non static ip address
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 membership.. And accept someone will run away with your data. If you are worried about your password or access use ssl across the net, because you cannot trust everyone between you and your site. Also what happens if it goes across a wireless link and all someone is doing is listening.. Regards Michael On 10/10/07, Stephen Sunderlin [EMAIL PROTECTED] wrote: QUESTION: What are the most secure permissions settings for administrator access to connect to my server without using a static IP address? MY ISP changes my DSL ip address almost daily so when I log on to MySQL Administrator with 'myusername'@'currentipaddress' using password 'mypassword' I have grant permission to the new ip address. I also have and account: 'username'@'%' with no password with SELECT, INSERT, UPDATE and DELETE privileges only for general users for this membership site. Are there any security issues with this? Any input or direction for informed reading on the issue would be appreciated. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unbiased opinion needed on access control procedure
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 to your competitors since they dont have to do the leg work to get the data, first into that nice database.. On 10/10/07, Matt Juszczak [EMAIL PROTECTED] wrote: Hi all, I'm looking to get an unbiased opinion of two possible methods for controlling access to database servers. Here are the specs: * 6 database servers, all firewalled off to the outside world, but accessible to each other on port 3306 unrestricted * 10 web servers total, but only half of those need to connect. Which option? A) GRANT replication slave ON *.* TO [EMAIL PROTECTED]; GRANT replication slave ON *.* TO [EMAIL PROTECTED]; GRANT replication slave ON *.* TO [EMAIL PROTECTED]; GRANT SELECT ON database.* TO [EMAIL PROTECTED]; GRANT SELECT ON database.* TO [EMAIL PROTECTED]; B) GRANT REPLICATION SLAVE ON *.* TO ruser; GRANT SELECT on database.* TO otheruser; A: Pro: Granular control per host, although the permissions are always identical, we still block the webservers that don't need access. Con: Hard to manage, 40 webservers = 40 users with the same permissions, 10 slaves = 10 users with the same permissions B: Pro: Simple to manage. One user allows access from anywhere on the internal network (since the servers are firewalled off to the outside) Con: Any server on the internal network can connect as that specific user to the database. Could cause problems with old code, etc. if passwords aren't changed. Which option do you use in your setup? Which do you see more fit? Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ERROR 2002 (HY000): Can't connect to local MySQL server
List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Regards Michael Cole -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: how to enable logging, MySQL 5.0.37 FreeBSD 6.2
There is a sql log that you can enable in the config file. If you look at the config file now it will most likely only have one log file, Look at MSQL manual and logging. I dont have the setting infront of me at the moment. If you cannot find give a yell. On Wednesday 25 April 2007 10:06: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/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error 1111 (Weird.)
Ok the Query i am trying to run is very long with many joins it is only run a couple of times every two weeks for payroll. It worked well on 4.1alpha and we have now upgraded to 5.0.24a-log Running on 64 Bit AMD Linux Each section of the query works correctly and if i run only a two or 3 day selection no problems but when i run 4 or more days i get this error. Error code I think it has to do with the size of the query not the query itself. As if i remove a large section out and run it it will work. Remove a different section and also it will work. It has about 30 joined 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]