Tag: MySQL

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 »
By halfgaar, 3 weeks ago, on August 11, 2010, at 09:08 | No comments

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; create user 'jack'@'localhost' identified by 'password'; use bla grant all on bla.* to 'jack'@'localhost' identified by 'password'; Read More »
By halfgaar, 6 months ago, on March 16, 2010, at 12:03 | No comments

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 »
By halfgaar, 8 months ago, on January 11, 2010, at 14:01 | No comments

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 »
By halfgaar, 1 year ago, on August 23, 2009, at 12:08 | 1 comment

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 »
By Rowan Rodrik, 1 year ago, on March 09, 2009, at 14:03 | 2 comments

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 »
By Rowan Rodrik, 2 years ago, on February 04, 2009, at 20:02 | 1 comment

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 »
By Rowan Rodrik, 2 years ago, on December 27, 2008, at 19:12 | 1 comment

Purging a MySQL database without losing meta data

When I clone a production database to a development database, I always need to empty the development database first. I could never find an SQL command to completely purge a database, bur, recently, I learned something about MySQL that surprised me: MySQL doesn't lose the user rights for a database when you drop it. So, purging a MySQL database (without losing any access data meta data about that DB) is as simple as issuing the following statements: Read More »
By Rowan Rodrik, 2 years ago, on July 12, 2008, at 01:07 | No comments