MySQL

Setting up MySQL and using MySQL Workbench (via SSH Tunnel) on Amazon EC2

Here are the instructions on how to get MySQL Workbench up and running on Amazon EC2 after creating a "Getting Started on Fedora Core 8" AMI instance.

1. ssh into your instance forwarding port 3306
ssh -i ~/ec2key.pem root@your-ec2-ip-or-hostname
I normally put localhost instead of 127.0.0.1, but OSX gives me grief by
2. Install MySQL
yum install mysql-server
3. Configure MySQL to start on startup
ntsysv
check "mysqld"
4. Start up MySQL
/etc/init.d/mysqld start
5. Set root password
mysqladmin -u root password new-password-here

Now, Launch MySQL Workbench

Getting Trac 0.11.7 Installed on CentOs 5.4 is Painful

So I just went through a few hours of pain moving Trac from my old faithful FC 6 (3 years uptime!!!) to Centos 5.4. I tried to battle SELinux for a while, but finally surrendered to it as I will discuss later.

Problem 1: ImportError: No module named genshi
Problem 2: Permission denied: 'path-to-trac-projects/projectname/VERSION'

Problem 1 occurred because I installed Genshi before installing python-devel.
The installation will go fine if you don't, but
YOU HAVE TO INSTALL PYTHON-DEVEL FIRST OR YOU WILL FACE THE SAME PAIN.

Syndicate content