Changes

From SME Server
Jump to navigationJump to search

Software Collections:MySQL (view source)

Revision as of 00:35, 20 October 2017

388 bytes added ,  00:35, 20 October 2017
→‎Configure private/public access: copy editing for easy comprehension
Line 1: Line 1:  
{{WIP box}}
 
{{WIP box}}
 +
{{Warning box| if you want an easy way to install and configure mysql55 on SME9 : try the contrib : [[MySQL55]]}}
 
<blockquote style="float: right;">
 
<blockquote style="float: right;">
 
[[File:softwarecollections.png|100px]]
 
[[File:softwarecollections.png|100px]]
Line 60: Line 61:  
pid-file=/opt/rh/mysql55/root/var/run/mysqld/mysqld.pid
 
pid-file=/opt/rh/mysql55/root/var/run/mysqld/mysqld.pid
 
</nowiki>
 
</nowiki>
 +
 +
===mysql command line access===
 +
To access the new instance of mysql from the command line you need to specify the appropriate connect string in the command line, using one or the other of these:
 +
 +
mysql --socket=/var/lib/mysql/mysql55.sock
 +
    
===Start/Stop MySQL===
 
===Start/Stop MySQL===
−
{{Note box|How to connect to mysql55, for using 'mysql' will invoke the CLI of the standard MySQL version and not the scl version. Not even when trying to start /opt/rh/mysql55/bin/mysql, it will invoke the 'old' MySQL.}}
+
 
 
MySQL is now installed and can be started and stopped manually via:
 
MySQL is now installed and can be started and stopped manually via:
 
  /etc/rc.d/init.d/mysql55-mysqld start
 
  /etc/rc.d/init.d/mysql55-mysqld start
Line 79: Line 86:     
====Configure private/public access====
 
====Configure private/public access====
−
If your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN) the ports and access privileges need to be set. For this issue the following commands (where 5432 is the port that MySQL can be reached on):
+
You will need to make some additional adjustments if your SME Server is hosting the application and is being accessed by other hosts either locally (LAN) or remotely (WAN). Privileges for the ports and access privileges need to be set. Use the following commands to modify the configuration. This example uses port 3307 as the port to connect to MySQ; you may need to use a different port for your specific set up.
 +
 
 
  config setprop mysql55-mysqld TCPPort 3307
 
  config setprop mysql55-mysqld TCPPort 3307
 
  config setprop mysql55-mysqld UDPPort 3307
 
  config setprop mysql55-mysqld UDPPort 3307
 
  config setprop mysql55-mysqld access private
 
  config setprop mysql55-mysqld access private
−
followed by the event to update the firewall rules:
+
 
 +
Follow that with event signals to update the SME configuration.
 +
 
 
  signal-event remoteaccess-update
 
  signal-event remoteaccess-update
−
You can toggle between private and public access followed by the remoteaccess-update command.
+
 
 +
You can toggle between private and public access by changing the value of the "mysql55-mysqld access" property. Remember to follow any change with the remoteaccess-update command.
    
==Other articles in this category==
 
==Other articles in this category==
Mophilly
81

edits

Retrieved from "https://wiki.koozali.org/Special:MobileDiff/27052...34004"

Navigation menu