Differences

This shows you the differences between two versions of the page.

--- linux_wiki:network_services_overview_database_services [2016/10/01 23:57]
billdozor [Network Services Overview: Database Services]
+++ linux_wiki:network_services_overview_database_services [2019/05/25 23:50] (current)
@@ Line 12: / Line 12: @@
   * Configure the service for basic operation
   * Configure host-based and user-based security for the service
+----
+====== Lab Setup ======
+The following virtual machines will be used:
+  * server1.example.com (192.168.1.150) -> Perform any client testing here
+  * server2.example.com (192.168.1.151) -> Install the database here
 ----
@@ Line 23: / Line 31: @@
   * mariadb -> the client
   * mariadb-server -> the server
+\\
+Documentation (what can go in the /etc/my.cnf config)
+<code bash>
+/usr/libexec/mysqld --verbose --help | less
+# then search for 'Variables'
+/Variables    <enter>
+</code>
 ----
@@ Line 58: / Line 75: @@
 SELinux: Allow mariadb to use the new port
 <code bash>
-semanage port -a -t mysqld_port_t 5502 -p tcp
+semanage port -a -t mysqld_port_t -p tcp 5502
 </code>
@@ Line 66: / Line 83: @@
 systemctl restart mariadb
 </code>
+\\
+Remote clients would need to connect like this example (specifying a port)<code bash>mysql -h 192.168.1.151 --port=5502 -u root -p</code>
+  * -h 192.168.1.151  -> Remote hostname to connect to (can be an IP)
+  * --port=5502  -> Use this remote port
+  * -u root  -> Database username
+  * -p  -> Prompt for password
 ----