Thursday, June 21, 2012

One stop guide: Get MySQL running on Ubuntu!!

This tutorial explains the process pretty well. Also highlighted in it are the errors I faced during the process.. http://codeinthehole.com/writing/how-to-set-up-mysql-for-python-on-ubuntu/
$ sudo apt-get install python-dev libmysqlclient-dev
$ pip install MySQL-python

This should let you run the staging database.

For your local mysql databses,
$ sudo apt-get install mysql-server

Then..
mysql -u root -p
>enter password

mysql> CREATE USER 'efldbadmin'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'efldbadmin'@'%' WITH GRANT OPTION;

CREATE DATABASE stg_mullet;

Import sql file into the db:


mysql -u efldbadmin -p stg_mullet < mullet_2012-05-25.sql
Enter password:

DONE!

No comments:

Post a Comment

Popular Posts