Difference between revisions of "Software Collections:MySQL55"
Unnilennium (talk | contribs) |
m (RequestedDeletion moved page MySQL55 to Software Collections:MySQL55: Consistent page naming for software collections pages) |
Revision as of 08:36, 19 March 2017
Description
This contrib purpose is to help configuring mysql55 on SME8 and SME9 using software collection.
This RPM will allow you to have 2 versions of Mysql running side by side. You will have to select the one to use in the setup of the specific application - please see "usage" below. Please note that applications and contribs like phpmyadmin etc. will as standard use the original Mysql DBM for your OS unless you change the database connection to Mysql 5.5.
Most of configuration options are explained for mysql here : MySQL are also available for mysql55 ( except innoDB options). Only difference is to prefix mysqld and mysql.init db entry by "mysql55-".
Note that default behaviour will be socket only, and if you enable networking, it will listen on 3307 locally. You then will need to open port to 3307 to access remotely. Also if you want another port you need to define mysql55-mysqld property port to whatever you want. Also remember that default mysql port is reserved to original mysql server
See also for reference: Software_Collections:MySQL
For SME9 Software collection is only available for x64 architectures.
Version
Maintainer
Installation
for SME8
yum --enablerepo=smecontribs install smeserver-mysql55 signal-event post-upgrade signal-event reboot
for SME9
A description of the Redhat Software Collections can be found here and can be downloaded manually from here
To use these repos on SME please see this page http://wiki.contribs.org/PHP_Software_Collections
For SME 9.x 64-bit ONLY
for the rebase of Red-Hat sfotware collection : http://mirror.centos.org/centos/6/sclo/x86_64/rh/
/sbin/e-smith/db yum_repositories set centos-sclo-rh repository \ Name 'Centos - RH Software Collections' \ BaseURL 'http://mirror.centos.org/centos/$releasever/sclo/$basearch/rh/' \ EnableGroups no \ Visible yes \ status disabled
For the community based software collection: http://mirror.centos.org/centos/6/sclo/x86_64/sclo/
/sbin/e-smith/db yum_repositories set centos-sclo-sclo repository \ Name 'Centos - RH Software Collections' \ BaseURL 'http://mirror.centos.org/centos/$releasever/sclo/$basearch/sclo/' \ EnableGroups no \ Visible yes \ status disabled
Be carefull some collection are available on both repo, and migh conflict : sclo-python27 and (rh/) python27.
After adding it to the database updating the configuration file is required by issuing:
signal-event yum-modify
yum --enablerepo=smecontribs,centos-sclo-rh install smeserver-mysql55 signal-event post-upgrade signal-event reboot
Command line
For your convenience, aliases have been added : mysql55, mysqlshow55, mysqladmin55, mysqldump55, mysqlimport55 and mysqlbinlog55
mysql55 wordpress
will connect you to database wordpress in mysql55 server, and let you with the mysql prompt to work.
However the full command line to access, per instance to mysql55 server with the mysql client against its version would be :
If you need to work with this version of MySql on the command line you will have to specify the right socket.
/opt/rh/mysql55/root/usr/bin/mysql --socket=/var/lib/mysql/mysql55.sock
or use TCP on port 3307:
/opt/rh/mysql55/root/usr/bin/mysql --protocol=TCP --port=3307
Usage
PHP application aware of sockets are few, most of them will try to connect to a port, you will have to find a way to define the one you want to use for your particular app. Some let you put it in a variable, some will just need you to add it after the hostname or ip (localhost:3307), some will just assume 3306 and just ignore anything else.
Possible host strings (localhost can be replaced with 127.0.0.1 if needed):
- localhost:/var/lib/mysql/mysql55.sock
- localhost;unix_socket=/var/lib/mysql/mysql55.sock
- localhost:3307
For Wordpress adjust the DB_HOST value in the wp-config.php file accordingly.
define( 'DB_HOST', 'localhost:/var/lib/mysql/mysql55.sock' );
Resetting the MySQL root password
To reset the password for the MySQL root account. The MySQL root user on SME Server has a random generated password which is generated during installation. You do not need to know this password to login to MySQL with root privileges on SME Server. If you might have changed the MySQL root password you can reset it like this after getting command line access as root user.
service mysql55-mysqld stop expand-template /root/.my.cnf expand-template /var/service/mysql55-mysqld/set.password /opt/rh/mysql55/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql55.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql55-mysqld/set.password service mysql55-mysqld start
Bugs
Please raise bugs under the SME-Contribs section in bugzilla and select the smeserver-mysql55 component or use this link .
Changelog
Only versions released in smecontrib are listed here: