On Oktober, the 25th, in what will be known to future generations as a historical move, Wiebe changed the A record of www.aihato.nl to point to the new production site running at Ytec. The new site, a collaboration by Ytec and me, based on WordPress, has been in development since May. At least, that's when I started taking notes. There had been some discussion, wire-framing and design done before that time.
By Rowan Rodrik, 6 years ago, on November 09, 2010, at 17:11 |
Zimbra installs its own mysql and there is no workable mysqldump command. There is a mysql command wrapper script (/opt/zimbra/bin/mysql) that loads an environment to set password and such, but there is no such thing for mysqldump. I copied that wrapper script to /usr/local/bin/mysqldump so that user zimbra can no run mysqldump. This is it:
By halfgaar, 7 years ago, on October 08, 2010, at 15:10 |
(source) To show one users privilges in mysql:
By halfgaar, 7 years ago, on September 30, 2010, at 11:09 |
Sometimes you want automated access for root on your MySQL database. One way of accomplishing that is by doing this:
By halfgaar, 7 years ago, on August 11, 2010, at 09:08 |
I often need to make a MySQL database and a user that can do anything in it: create database bla character set utf8 collate = utf8_general_ci; use bla grant all on bla.* to 'jack'@'localhost' identified by 'password';
By halfgaar, 7 years ago, on March 16, 2010, at 12:03 |
When you don't know the current mysql root password and you want to change it, do this: /etc/init.d/mysql stop mysqld --skip-grant-tables & mysql -p use mysql; update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; flush privileges; quit; killall mysqld /etc/init.d/mysql start
By halfgaar, 7 years ago, on January 11, 2010, at 14:01 |
When you have tables with a large amounts of columns, it can be easy to show the columns vertically, as opposed to horizontally. In Postgresql, you can toggle this with \x. In MySQL it's a little bit different.
By halfgaar, 8 years ago, on August 23, 2009, at 12:08 |
I have been wanting to protect a certain page on my Dutch 15Monkeys wiki for weeks. I could install the ReCaptcha extension already (the best Captcha there is), but it's just that one page that's being spammed. So far, I've been unsuccessful in regaining my Sysop right for that wiki. I need these rights if I'm going to protect these pages.
By Rowan Rodrik, 8 years ago, on March 09, 2009, at 14:03 |
I am constantly bugged by spammers in my 15 Monkeys wiki farm[1, 2], but I wasn't allowed to protect the victim pages anymore. So, I wondered where my Sysop rights had gone.
By Rowan Rodrik, 8 years ago, on February 04, 2009, at 20:02 |
When I upgraded two of my MediaWiki installations[1, 2] a while ago, images were no longer being displayed. I found out that this was due to some problem with a change to the image.image_name column.
By Rowan Rodrik, 8 years ago, on December 27, 2008, at 19:12 |