3,250
edits
Changes
From SME Server
Jump to navigationJump to searchCreated page with "{{warning box| this is in alpha test, not for production yet}} == Description == This contrib purpose is to help configuring mysql57 on SME9 using software collection. Mos..."
{{warning box| this is in alpha test, not for production yet}}
== Description ==
This contrib purpose is to help configuring mysql57 on SME9 using software collection.
Most of configuration options are explained for mysql here : [[MySQL]] are also available for mysql57 ( except innoDB options). Only difference is to prefix mysqld and mysql.init db entry by "mysql57-".
Note that default behaviour will be socket only, and if you enable networking, it will listen on 3309 locally. You then will need to open port to 3307 to access remotely. Also if you want another port you need to define mysql57-mysqld property port to whatever you want. Also remember that default mysql port is reserved to original mysql server
this RPM will allow you to have 2 versions of mysql running!!!
see also for reference: [[Software_Collections:MySQL]]
For SME9 Software collection is only available for x64 architectures.
=== Version ===
{{ #smeversion: smeserver-mysql57}}
=== Maintainer ===
[mailto:tests@pialasse.com[[User:Unnilennium|Unnilennium]]]
==Installation==
yum --enablerepo=smedev smeserver-mysql57
signal-event post-upgrade
signal-event reboot
== command line ==
/opt/rh/mysql57/root/usr/bin/mysql --socket=/var/lib/mysql/mysql57.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 mysql57-mysqld stop
expand-template /root/.my.cnf
expand-template /var/service/mysql57-mysqld/set.password
/opt/rh/mysql57/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql57.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql57-mysqld/set.password
service mysql57-mysqld start
=== Bugs ===
Please raise bugs under the SME-Contribs section in [http://bugs.contribs.org/enter_bug.cgi bugzilla]
and select the smeserver-mysql57 component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-mysql57|title=this link}}.
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |component=smeserver-mysql57|noresultsmessage="No open bugs found."}}
===Changelog===
Only versions released in smecontrib are listed here:
{{ #smechangelog: smeserver-mysql57}}
[[Category: Contrib]]
[[Category: Software Collections]]
== Description ==
This contrib purpose is to help configuring mysql57 on SME9 using software collection.
Most of configuration options are explained for mysql here : [[MySQL]] are also available for mysql57 ( except innoDB options). Only difference is to prefix mysqld and mysql.init db entry by "mysql57-".
Note that default behaviour will be socket only, and if you enable networking, it will listen on 3309 locally. You then will need to open port to 3307 to access remotely. Also if you want another port you need to define mysql57-mysqld property port to whatever you want. Also remember that default mysql port is reserved to original mysql server
this RPM will allow you to have 2 versions of mysql running!!!
see also for reference: [[Software_Collections:MySQL]]
For SME9 Software collection is only available for x64 architectures.
=== Version ===
{{ #smeversion: smeserver-mysql57}}
=== Maintainer ===
[mailto:tests@pialasse.com[[User:Unnilennium|Unnilennium]]]
==Installation==
yum --enablerepo=smedev smeserver-mysql57
signal-event post-upgrade
signal-event reboot
== command line ==
/opt/rh/mysql57/root/usr/bin/mysql --socket=/var/lib/mysql/mysql57.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 mysql57-mysqld stop
expand-template /root/.my.cnf
expand-template /var/service/mysql57-mysqld/set.password
/opt/rh/mysql57/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql57.sock --bootstrap --user=mysql --skip-grant-tables < /var/service/mysql57-mysqld/set.password
service mysql57-mysqld start
=== Bugs ===
Please raise bugs under the SME-Contribs section in [http://bugs.contribs.org/enter_bug.cgi bugzilla]
and select the smeserver-mysql57 component or use {{BugzillaFileBug|product=SME%20Contribs|component=smeserver-mysql57|title=this link}}.
{{#bugzilla:columns=id,product,version,status,summary |sort=id |order=desc |component=smeserver-mysql57|noresultsmessage="No open bugs found."}}
===Changelog===
Only versions released in smecontrib are listed here:
{{ #smechangelog: smeserver-mysql57}}
[[Category: Contrib]]
[[Category: Software Collections]]
