Setting up MySql 5 in Ubuntu
Something that will probably be needed if you going to be developing in Ruby on Rails on Ubuntu is MySql. So here’s a very quick run through of how to set it up. As per Ubuntu-usual, it is really easy to setup and the longest part of the setup, depending on your internet connection, is the download of MySql server 5.
1) Open up and terminal and type sudo apt-get install mysql-server
2) Open the /etc/mysql/my.cnf file in your text editor and replace 127.0.01 with your computer’s IP address
3) During the install it should ask you for root password for mySql but if it doesn’t type the following:
mysql> SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(’myPasswordHere’);
Obviously where I’ve typed myPasswordHere you’ll enter your desired password.
I am currently working on nice little Ruby on Rails post so check back soon!