Archive

Posts Tagged ‘MySQlWorkBench’

Setting up MySQLWorkBench on Ubuntu

February 22, 2010 Leave a comment

Download MySQLWorkBench from the following portal;-

http://dev.mysql.com/downloads/workbench/

MySQL Workbench can be easily installed on Ubuntu/Gnome. Just download the binary .deb file from the MySQL web site for workbench (currently named mysql-workbench-oss-5.2.16-1ubu904-i386.deb), save it to your home directory. Then run:

sudo apt-get install liblua5.1-0 libzip1 libmysqlclient15off
sudo dpkg -i mysql-workbench-oss-5.1.18-1ubu904-i386.deb (adapt the name accordingly)

Selecting previously deselected package mysql-workbench-oss.
(Reading database ... 145956 files and directories currently installed.)
Unpacking mysql-workbench-oss (from mysql-workbench-oss_5.2.16-1ubu910_i386.deb) ...
dpkg: dependency problems prevent configuration of mysql-workbench-oss:
 mysql-workbench-oss depends on python-paramiko; however:
 Package python-paramiko is not installed.
 mysql-workbench-oss depends on python-pexpect; however:
 Package python-pexpect is not installed.
dpkg: error processing mysql-workbench-oss (--install):
 dependency problems - leaving unconfigured
Processing triggers for desktop-file-utils ...
Errors were encountered while processing:
 mysql-workbench-oss
root@qasim-laptop:/media/BlackAir# apt-cache search python-paramiko
python-paramiko - Make ssh v2 connections with python
bzr - easy to use distributed version control system

Then, you have MySQL Workbench listed under “Applications > Programming”.

Following packages are also required;-

python-pexpect (module for automating interactive applications)

python-paramiko (ssh2 protocol for python)

Manage DB Connection:

Error:

Couldn’t load library libmysqlclient_r.so: libmysqlclient_r.so: cannot open shared object file: No such file or directory

possibly missing symbolic link

# cd /usr/lib

# root@qasim-laptop:/usr/lib# ln -s libmysqlclient_r.so.16 libmysqlclient_r.so

Error:

Test connect failed
Access denied for user ‘root’@’localhost’ (using password: NO)

Enter the correct password and Test Connection again.

Advertisements
Categories: Linux Tags: ,
%d bloggers like this: