You've opened a new tab!

Sound familiar? You know IE holds back the Internet right?

Here you'll be able to find my brief notes on computer/linux things I'm currently doing, and if I had any troubles, details about how they were overcome.

My public GPG key
My public SSH key

My github

My nicknames:

  • cgerpheide (official)
  • phoxicle (IRC, forums, twitter)
  • HorseRayX (AOL -- haven't used this one since I was 11)

A list of my favorite XKCDs:

C0mput3rz & T3chno1ogy

Useful SQL commands for TYPO3/LAMP

Note that some commands are at the shell prompt (#) and some at the MySQL prompt (>). Set your root password after a fresh install:

# mysqladmin -u root password NEWPASSWORD

In SQL, create a new database as well as a new user

> CREATE USER 't3user'@'localhost' IDENTIFIED BY 'passwd';

Select the database and grant privileges to your new user

> USE typo3
> GRANT ALL ON typo3.* TO 't3user'@'localhost' IDENTIFIED BY 'passwd';

Exit and reload the grant tables (not always necessary)

# mysqladmin -u root -p reload

Now see if it worked by logging in

# mysql -u t3user -p typo3