Skip to content

Tag: MySQL

Ytec, WordPress and Aihato.nl

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. Read More »

Making mysqldump work on a zimbra installation

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: Read More »

Show privileges for mysql users

(source) To show one users privilges in mysql: Read More »

Setting password for mysql user in .my.cnf

Sometimes you want automated access for root on your MySQL database. One way of accomplishing that is by doing this: Read More »

Creating new MySQL database and user

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'; Read More »

Changing lost MySQL root password

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 Read More »

Expanded output in MySQL prompt

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. Read More »

MediaWiki problems with MySQL VARBINARY padding

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. Read More »

Lost my Sysop rights in the 15Monkeys wikis

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. Read More »

Images not showing after upgrade to MediaWiki 1.13

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. Read More »