Skip to navigation

Archive for the 'mysql' Category

Installing Limesurvey

Thursday, August 16th, 2012

Notes to future self: Download limesurvey tarball and unpack into web root. Edit [limesurvey-root-dir]/config.php: Change $databaseuser from ‘root’ to ‘limesurvey’ Choose and insert $databasepass, the password for the limesurvey mysql user. If applicable, change rooturl to reflect directory where you unpacked the limesurvey tarball. Change the default password for the default limesurvey user ‘admin’. This […]

My first RMySQL session

Thursday, January 21st, 2010

# ‘fai1’ is an empty MySQL database for which ‘mpromber’ has all privileges mycon

MySQL settings in ~/.my.cnf

Thursday, January 21st, 2010

You can specify default settings for MySQL in the file ~/.my.cnf (create it if it doesn’t exist). E.g., you could spare yourself typing your password each time you connect with an entry in that file like this: [client] password=’mypassword’ This gets loaded in addition to the system configuration file, which for me is at /etc/mysql/my.cnf.

How to run a web server off a usb flash drive

Monday, November 19th, 2007

Actually, turns out to be really easy: Install Slax on the USB flash drive. Here’s how I did it. Download the Xampp module for Slax. I got version 1.6.2 from here. Copy the Xampp_1_* file that you downloaded to the modules folder on your USB flash drive. Boot off the USB flash drive. Open a […]

Drupal: how to disable broken module manually

Wednesday, November 14th, 2007

I did something wrong applying a patch to a module. This resulted in a broken site — I wasn’t able to see the Administration page anymore to disable the module (or any page for that matter). Log on to your server via SSH. mysql -p Gets you into mysql. To see your databases: show databases; […]