This is a guide to setting up SquirrelSql on Ubuntu..
1. Download SquirrelSql from : http://sourceforge.net/projects/squirrel-sql/files/1-stable/3.3.0/squirrel-sql-3.3.0-install.jar/download
2. Unzip the tarball by doing $ tar zxf <path-to-tarball>. To install the jar, $ java -jar <path-to-jar-file> . Then follow the on screen instructions (make sure to check MySql among the checkboxes) and you're done.
3. To connect to the database, you need a mysql driver. Download it from : http://dev.mysql.com/downloads/connector/j/
4. Fire up SquirrelSql and choose the "Drivers" on the vertical tab on the left.
5. Scroll to MySql and double click on it. Click on the 'Extra Class path' tab.
6. Click 'Add' and browse to the .jar friver file you downloaded at step3. Then hit 'Ok'.
7. Next, choose 'Aliases' on the vertical tab on the left and hit the '+' sign to add a new Alias.
8. Enter a name of your choice for the alias and in the driver dropdown menu select MySql.
9. For the url, enter the url that points to the database. For my local copy of the database I put. jdbc:mysql://localhost
10. Enter the username and password that you configured for your local db 'efldbadmin' and whatever password you choose. If connecting to staging use the password from dev.py
11. Hit 'Test' and then 'Connect'. You should get a 'Connection Successful' message.
You're done! ^_^
1. Download SquirrelSql from : http://sourceforge.net/projects/squirrel-sql/files/1-stable/3.3.0/squirrel-sql-3.3.0-install.jar/download
2. Unzip the tarball by doing $ tar zxf <path-to-tarball>. To install the jar, $ java -jar <path-to-jar-file> . Then follow the on screen instructions (make sure to check MySql among the checkboxes) and you're done.
3. To connect to the database, you need a mysql driver. Download it from : http://dev.mysql.com/downloads/connector/j/
4. Fire up SquirrelSql and choose the "Drivers" on the vertical tab on the left.
5. Scroll to MySql and double click on it. Click on the 'Extra Class path' tab.
6. Click 'Add' and browse to the .jar friver file you downloaded at step3. Then hit 'Ok'.
7. Next, choose 'Aliases' on the vertical tab on the left and hit the '+' sign to add a new Alias.
8. Enter a name of your choice for the alias and in the driver dropdown menu select MySql.
9. For the url, enter the url that points to the database. For my local copy of the database I put. jdbc:mysql://localhost
10. Enter the username and password that you configured for your local db 'efldbadmin' and whatever password you choose. If connecting to staging use the password from dev.py
11. Hit 'Test' and then 'Connect'. You should get a 'Connection Successful' message.
You're done! ^_^
squirrel rocks...works like charm on Ubuntu..thanks for help :)
ReplyDelete