3,230
edits
Changes
From SME Server
Jump to navigationJump to search→Resetting the MySQL root password
[[File:Mysql.png]]
[[File:Mysql.png]]
</blockquote>
</blockquote>
__TOC__
== Description ==
== Description ==
=== Version ===
=== Version ===
{{ #smeversion: smeserver-mysql57}}
{{#smeversion: smeserver-mysql57}}
=== Maintainer ===
=== Maintainer ===
[mailto:tests@pialasse.com[[User:Unnilennium|Unnilennium]]]
[mailto:tests@pialasse.com][[User:Unnilennium|Unnilennium]]
==Installation==
==Installation==
{{warning box| You have to do the signal-event post-upgrade; signal-event reboot; or your mysql57 installation will remain in a definitive failed state. They are MANDATORY. }}
{{warning box| You have to do the signal-event post-upgrade; signal-event reboot; or your mysql57 installation will remain in a definitive failed state. They are MANDATORY. }}
yum install --enablerepo=smecontribs,centos-sclo-rh smeserver-mysql57
yum install --enablerepo=smecontribs,centos-sclo-rh smeserver-mysql57
== Usage ==
== 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:3309), some will just assume 3306 and just ignore anything else.
By default mysql57 uses a socket for connections.
PHP applications that are aware of sockets are few, and most typically try to connect to a port. You will have to craft 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:3309), some will just assume 3306 and just ignore anything else.
Possible host strings (localhost can be replaced with 127.0.0.1 if needed):
Possible host strings (localhost can be replaced with 127.0.0.1 if needed):
* localhost:/var/lib/mysql/mysql57.sock
* localhost:/var/lib/mysql/mysql57.sock
* localhost;unix_socket=/var/lib/mysql/mysql57.sock
* localhost;unix_socket=/var/lib/mysql/mysql57.sock
PHP applications that are aware of sockets are few, and most of them will try to connect to a port. To enable mysql57 to use a port you will need to do the following:
config setprop mysql57-mysqld port 3309 LocalNetworkingOnly no
signal-event post-upgrade;signal-event reboot
mysq57 should now be listening on port 3309. you can check this using netstat:
netstat -atn |grep 3309
Beware that some applications just assume the running port number, so to connect to mysql55 on 3307 instead of stock mysql on 3306 you will need to carefully investigate and modify your application accordingly e.g.
* localhost:3309
* localhost:3309
{{Warning box|1=Note that you may experience issues with PHP connecting to the correct port if you use localhost. There is an obscure bug in PHP which means you will need to use 127.0.0.1 instead of localhost. Please see See bug https://bugs.contribs.org/show_bug.cgi?id=10616 for more information}}
For Wordpress adjust the DB_HOST value in the wp-config.php file accordingly.
For Wordpress adjust the DB_HOST value in the wp-config.php file accordingly.
== command line ==
== command line ==
For your convenience, aliases have been added : mysql57, mysqlshow57, mysqladmin57, mysqldump57, mysqlimport57 and mysqlbinlog57
For your convenience, aliases have been added : mysql57, mysqlshow57, mysqladmin57, mysqldump57, mysqlimport57 and mysqlbinlog57
Assuming you have a wordpress database setup, the following will connect to database wordpress in mysql57 server, and present the mysql prompt so you can work with the database.
mysql57 wordpress
mysql57 wordpress
However the full command line to access, per instance to mysql55 server with the mysql client against its version would be :
mysql57
Alternatively:
The complete path to the specific version of mysql57 server with the mysql client would be:
Note that using the regular 5.1 client may work, but can lead to unexpected results:
# /opt/rh/rh-mysql57/root/usr/bin/mysql --socket=/var/lib/mysql/mysql57.sock
mysql --socket=/var/lib/mysql/mysql57.sock
or use TCP on port 3309:
PHP applications that are aware of sockets are few, and most of them will try to connect to a port. To enable mysql57 to use a port you will need to do the following
{{Note box|1=Note see usage details in https://wiki.contribs.org/Software_Collections:MySQL55}}
# config setprop mysql57-mysqld port 3309 LocalNetworkingOnly no
# config show mysql57-mysqld
# mysql57-mysqld=service
LocalNetworkingOnly=no
port=3309
status=enabled
# signal-event post-upgrade; signal-event reboot
# /opt/rh/mysql57/root/usr/bin/mysql --protocol=TCP --port=3309
Note that using the regular 5.1 client may work, but can lead to unexpected results. Please avoid this type of command invocation:
# mysql --socket=/var/lib/mysql/mysql57.sock
== Resetting the MySQL root password ==
== Resetting the MySQL root password ==
expand-template /root/.my.cnf
expand-template /root/.my.cnf
expand-template /var/service/mysql57-mysqld/set.password
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
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/service/mysql57-mysqld/set.password
exit
service mysql57-mysqld start
service mysql57-mysqld start
Only versions released in smecontrib are listed here:
Only versions released in smecontrib are listed here:
{{ #smechangelog: smeserver-mysql57}}
{{#smechangelog: smeserver-mysql57}}
[[Category: Contrib]]
[[Category: Contrib]]
[[Category: Software Collections]]
[[Category: Software Collections]]
