MySQL Forums
Forum List  »  MySQL Workbench

MySQL WorkBench: cannot install requires mysql
Posted by: Kirk Woellert
Date: March 14, 2013 06:09PM

1) Which MySQL Workbench version do you use/did you try?
mysql-workbench-gpl-5.2.47-1el6.x86_64.rpm

2) On which operating system do you use WB?
RHEL 6.4 64bit
3) If relevant: which MySQL Server version do you use and is it a local or remote machine?
MySQL 5.6
The server is remote. Login via vnc as non-root user.
4) Specify the part of MySQL Workbench you have the problem with.
Installation.

Background: Linux noob. Mysql noob. Given task to install Apache, mysql, etc. I could use an assist!

Note: Initially configured vncserver with OS root login access. Installed WorkBench (mysql-workbench-gpl-5.2.47-1el6.x86_64.rpm) under root session. I did test and WorkBench launched under the root session. Later realized the security flaw of root access via vncserver. Now vncserver access is via account "mpnl" that must sudo for root privs.

Finally managed to uninstall mysql 5.1 completely (I think).
- stop all services service mysql stop
- chkconfig mysql off to disable it from restarting
- delete the previous mysql user account if it exists
- kill processes ps auxwww | grep mysql
- yum remove packages including the client: yum remove mysql-server
- Remove from RPM based distros (as root) rpm -qa | grep -i mysql and rpm -e mysql-<package_name>
- manual delete of install directory rm -rf /var/lib/mysql
- search for .frm extension

Installed mysql 5.6 using community RPMs. Installed following packages successfully:
libzip-0.9-3.1.el6.x86_64.rpm
pexpect-2.3-6.el6.noarch.rpm
MySQL-shared-5.6.10-1.el6.x86_64.rpm
MySQL-shared-compat-5.6.10-1.el6.x86_64.rpm
MySQL-client-5.6.10-1.el6.x86_64.rpm
MySQL-server-5.6.10-1.el6.x86_64.rpm

-ran mysql_install_db script --user=mysql
-reset all the root passwords (actual passwds not shown of course)
shell> mysql -u root
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'::1' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR 'root'@'host_name' = PASSWORD('newpwd');

-reset the mysql user account
- su to mysql user
-ran mysqld_safe script
- confirmed mysql is running as mysql user not as root
[root@mpnl Downloads]# ps auxww | grep mysql
mysql 9805 0.0 0.0 106228 1364 ? Ss 18:29 0:00 /bin/sh /usr/bin/mysqld_safe --user=mysql
mysql 9893 0.1 5.0 715236 93704 ? Sl 18:29 0:05 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/lib/mysql/mpnl.err --pid-file=/var/lib/mysql/mpnl.pid
root 10219 0.0 0.0 103244 816 pts/1 S+ 19:57 0:00 grep mysql

-tested I could login to mysql prompt:
[root@mpnl Downloads]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.6.10 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Thinking I got a good mysql intall, I tried to install WorkBench again:
[root@mpnl Downloads]# rpm -ivh mysql-workbench-gpl-5.2.47-1el6.x86_64.rpm
error: Failed dependencies:
mysql is needed by mysql-workbench-gpl-5.2.47-1el6.x86_64
[root@mpnl Downloads]#

This is the output when I try to use Yum with local install option:
[root@mpnl Downloads]# yum localinstall mysql-workbench-gpl-5.2.47-1el6.x86_64.rpm
Loaded plugins: product-id, refresh-packagekit, rhnplugin, security, subscription-manager
This system is receiving updates from Red Hat Subscription Management.
This system is receiving updates from RHN Classic or RHN Satellite.
Setting up Local Package Process
Examining mysql-workbench-gpl-5.2.47-1el6.x86_64.rpm: mysql-workbench-gpl-5.2.47-1el6.x86_64
Marking mysql-workbench-gpl-5.2.47-1el6.x86_64.rpm to be installed
rhel-6-server-cf-tools-1-rpms | 2.8 kB 00:00
rhel-6-server-rhev-agent-rpms | 2.8 kB 00:00
rhel-6-server-rpms | 3.7 kB 00:00
Resolving Dependencies
--> Running transaction check
---> Package mysql-workbench-gpl.x86_64 0:5.2.47-1el6 will be installed
--> Processing Dependency: mysql for package: mysql-workbench-gpl-5.2.47-1el6.x86_64
--> Running transaction check
---> Package mysql.x86_64 0:5.1.67-1.el6_3 will be installed
--> Processing Conflict: MySQL-client-5.6.10-1.el6.x86_64 conflicts mysql
--> Processing Conflict: MySQL-client-5.6.10-1.el6.x86_64 conflicts mysql
--> Processing Conflict: MySQL-server-5.6.10-1.el6.x86_64 conflicts mysql
--> Processing Conflict: MySQL-server-5.6.10-1.el6.x86_64 conflicts mysql
--> Processing Conflict: mysql-5.1.67-1.el6_3.x86_64 conflicts MySQL
--> Finished Dependency Resolution
Error: mysql conflicts with MySQL-server-5.6.10-1.el6.x86_64
Error: MySQL-client conflicts with mysql-5.1.67-1.el6_3.x86_64
Error: MySQL-server conflicts with mysql-5.1.67-1.el6_3.x86_64
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
[root@mpnl Downloads]#



Edited 2 time(s). Last edit at 03/17/2013 08:52AM by Kirk Woellert.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL WorkBench: cannot install requires mysql
4800
March 14, 2013 06:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.