Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Max Reinsch
5,740 PointsMySQL
I want to continue the Deep dive on Databases but don't know how to sort out a MySQL workbench.
I'm having trouble Downloading, installing and running the MySQL workbench (I don't even know where I should be downloading it from).
I have Ubuntu 12.04.
Also, is it free to use MySQL/MySQL servers?
14 Answers
Scott Evans
4,236 Pointssudo apt-get -f install
Scott Evans
4,236 PointsYes, MySQL is free.
apt-get install mysql-server
Scott Evans
4,236 PointsRegarding MySQL workbench,
If you have downloaded the package.deb from the workbench downloads page, you can then install it using..
sudo dpkg -i package.deb
Give it a try and post any output / errors.
Max Reinsch
5,740 Points"E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied) E: Unable to lock the administration directory (/var/lib/dpkg/), are you root?"
^ result after typing "apt-get install mysql-server" into terminal.
I'm heading back to the console Deep Dive to gain a fair understanding of the terminal.
Thanks for the response Scott.
Scott Evans
4,236 PointsTry adding
Sudo
Before the apt-Get command
Max Reinsch
5,740 Points~/Downloads$ sudo dpkg -i mysql-workbench-community-6.0.9-1ubu1204-i386.deb Selecting previously unselected package mysql-workbench-community. (Reading database ... 633051 files and directories currently installed.) Unpacking mysql-workbench-community (from mysql-workbench-community-6.0.9-1ubu1204-i386.deb) ... dpkg: dependency problems prevent configuration of mysql-workbench-community: mysql-workbench-community depends on libctemplate0; however: Package libctemplate0 is not installed. mysql-workbench-community depends on libpcrecpp0 (>= 7.7); however: Package libpcrecpp0 is not installed. mysql-workbench-community depends on libtinyxml2.6.2; however: Package libtinyxml2.6.2 is not installed. mysql-workbench-community depends on libzip2 (>= 0.10); however: Package libzip2 is not installed. mysql-workbench-community depends on python-paramiko; however: Package python-paramiko is not installed. mysql-workbench-community depends on python-pysqlite2; however: Package python-pysqlite2 is not installed. dpkg: error processing mysql-workbench-community (--install): dependency problems - leaving unconfigured Processing triggers for hicolor-icon-theme ... Processing triggers for shared-mime-info ... Processing triggers for desktop-file-utils ... Processing triggers for bamfdaemon ... Rebuilding /usr/share/applications/bamf.index... Processing triggers for gnome-menus ... Errors were encountered while processing: mysql-workbench-community
I managed to install the server but attempting to install the workbench.
Scott Evans
4,236 PointsHello again Max try this ¬
sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb
Scott Evans
4,236 Pointssudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb
ignore the above
Scott Evans
4,236 PointsGive me 5 minutes and I'll advise you on what you need to do.
Max Reinsch
5,740 Points"~$ sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb sudo: gdebi: command not found"
Scott Evans
4,236 Pointssudo apt-get install gdebi
then
sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb
Max Reinsch
5,740 Pointssudo apt-get install gdebi
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies.
gdebi : Depends: gdebi-core (= 0.8.5build1) but it is not going to be installed
mysql-workbench-community : Depends: libctemplate0 but it is not going to be installed
Depends: libpcrecpp0 (>= 7.7) but it is not going to be installed
Depends: libtinyxml2.6.2 but it is not going to be installed
Depends: libzip2 (>= 0.10) but it is not going to be installed
Depends: python-paramiko but it is not going to be installed
Depends: python-pysqlite2 but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
Scott Evans
4,236 Pointsapt-get -f install
Max Reinsch
5,740 Points"E: Could not open lock file /var/lib/dpkg/lock - open (13: Permission denied) E: Unable to lock the administration directory (/var/lib/dpkg/), are you root?"
Max Reinsch
5,740 PointsAs far as I can see, I am using the root. =/
Scott Evans
4,236 PointsDesktop short cuts in ubuntu, not sure about then I'm more of a terminal warrior :D
But im glad you managed to get that far.
Max Reinsch
5,740 PointsThanks Scott! I felt I was pushing my luck there a bit. =P
Really appreciated. =)
Scott Evans
4,236 PointsNo worries my friend, accept my answer if it helped you
Max Reinsch
5,740 PointsLet me know how to accept your answer and I will; I'm also new to the forums. ;)
Scott Evans
4,236 PointsJust click the Best answer button next to the add comment button on the answer that helped you the most.
Max Reinsch
5,740 PointsFor some strange reason, it's not being displayed at all for me (tried on various browsers). I've contacted Treehouse via facebook and email. I'll best an answer as soon as the problem is resolved.
Cheers again Scott.
Scott Evans
4,236 PointsAnytime my friend.
Max Reinsch
5,740 PointsIt's because I selected the topic General Discussion. Changed; sorted.
Max Reinsch
5,740 PointsMax Reinsch
5,740 Points"sudo apt-get -f install"- Seems successful. No errors. " sudo apt-get install gdebi"- Seems successful. No errors.
I had some trouble, then realised I had to change directory to Downloads then used- "sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb".
I can now run the Program with mysql-workbench.
Sorry for being so tedious, I'm very new to Console theory.
As a side note, is it possible for me to now make a desktop shortcut?