3,250
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: + Line 29:
Line 30: − {{warning box| this is still alpha, only for testing }} − + − + Line 122:
Line 122: + Line 129:
Line 130: + + + + + + + + +
no edit summary
</blockquote>
</blockquote>
__TOC__
__TOC__
{{Note box| Mysql 5.7 support is up to 31 Oct 2023 so 8 months before SME10 EOL which is 30 June 2024.}}
== Description ==
== Description ==
==Installation==
==Installation==
<tabs container><tab name="For SME 10">
<tabs container><tab name="For SME 10">
yum install smeserver-extrarepositories-centos-sclo -y
yum install smeserver-extrarepositories-centos-sclo -y
yum install --enablerepo=smecontribs smeserver-mysql57
yum install --enablerepo=smecontribs,centos-sclo-rh smeserver-mysql57
source /etc/profile.d/mysql57.sh
source /etc/profile.d/mysql57.sh
and enjoy mysql57
and enjoy mysql57, no more commands nor reboot required !
</tab>
</tab>
<tab name="For SME 9">
<tab name="For SME 9">
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.
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.
#SME9
service mysql57-mysqld stop
service mysql57-mysqld stop
expand-template /root/.my.cnf
expand-template /root/.my.cnf
exit
exit
service mysql57-mysqld start
service mysql57-mysqld start
#SME10
systemctl stop mysql57-mysqld
expand-template /root/.my.cnf
expand-template /var/opt/rh/rh-mysql57/lib/misc/set.password
scl enable rh-mysql57 bash
/opt/rh/rh-mysql57/root/usr/libexec/mysqld --socket=/var/lib/mysql/mysql57.sock --bootstrap --user=mysql --skip-grant-tables < /var/opt/rh/rh-mysql57/lib/misc/set.password
exit
systemctl start mysql57-mysqld
=== Bugs ===
=== Bugs ===