Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

Development Tools

MySQL

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
Scott Evans
4,236 Points

sudo apt-get -f install

"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?

Scott Evans
Scott Evans
4,236 Points

Yes, MySQL is free.

apt-get install mysql-server

Scott Evans
Scott Evans
4,236 Points

Regarding 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.

"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
Scott Evans
4,236 Points

Try adding

Sudo

Before the apt-Get command

~/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
Scott Evans
4,236 Points

Hello again Max try this ¬

sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb
Scott Evans
Scott Evans
4,236 Points

sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb

ignore the above

Scott Evans
Scott Evans
4,236 Points

Give me 5 minutes and I'll advise you on what you need to do.

"~$ sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb sudo: gdebi: command not found"

Scott Evans
Scott Evans
4,236 Points

sudo apt-get install gdebi

then

sudo gdebi mysql-workbench-community-6.0.9-1ubu1204-i386.deb

sudo 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
Scott Evans
4,236 Points

apt-get -f install

"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?"

As far as I can see, I am using the root. =/

Scott Evans
Scott Evans
4,236 Points

Desktop 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.

Thanks Scott! I felt I was pushing my luck there a bit. =P

Really appreciated. =)

Scott Evans
Scott Evans
4,236 Points

No worries my friend, accept my answer if it helped you

Let me know how to accept your answer and I will; I'm also new to the forums. ;)

Scott Evans
Scott Evans
4,236 Points

Just click the Best answer button next to the add comment button on the answer that helped you the most.

For 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.

It's because I selected the topic General Discussion. Changed; sorted.