March 26, 2014

Fedora 20 Install MySQL Server 5.5 and Workbench 6

MySQL Server 5.5

The MySQL packages has been renamed. The now official open source version of MySQL is MariaDB. To install the same version of MySQL on Fedora as in Enterprise Linux, such as RHEL, install these packages.

yum install community-mysql-server community-mysql-libs community-mysql

To start the mysqld.

service mysqld start

Set MySQL root password to 'root'.

mysqladmin -u root password root

Finally login and test password.

$ mysql -u root -p
Enter password: <root>

MySQL Workbench 6

The workbench rpm is orphan, so you need to download and install it manually. http://dev.mysql.com/downloads/tools/workbench/

$ rpm -pi /home/magnus/Downloads/mysql-workbench-community-6.0.9-1.fc20.x86_64.rpm 
error: Failed dependencies:
 libctemplate.so.2()(64bit) is needed by mysql-workbench-community-6.0.9-1.fc20.x86_64
 liblua-5.1.so()(64bit) is needed by mysql-workbench-community-6.0.9-1.fc20.x86_64
 libtinyxml.so.0()(64bit) is needed by mysql-workbench-community-6.0.9-1.fc20.x86_64
 libvsqlitepp.so.3()(64bit) is needed by mysql-workbench-community-6.0.9-1.fc20.x86_64
 libzip.so.2()(64bit) is needed by mysql-workbench-community-6.0.9-1.fc20.x86_64
 python-paramiko is needed by mysql-workbench-community-6.0.9-1.fc20.x86_64

Little bit of searching for installing dependeny packages, with 'yum provides', e.g.

yum provides "*/libctemplate.so.2"

And finally ending up with all required packages.

yum install -y ctemplate-devel compat-lua-libs tinyxml vsqlite++ libzip python-paramiko

Then run install of workbench again and start workbench and connect to you localhost.

No comments: