Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
linux_wiki:network_services_overview_database_services [2016/10/08 18:06] billdozor |
linux_wiki:network_services_overview_database_services [2019/05/25 23:50] (current) |
||
---|---|---|---|
Line 31: | Line 31: | ||
* mariadb -> the client | * mariadb -> the client | ||
* mariadb-server -> the server | * mariadb-server -> the server | ||
+ | |||
+ | \\ | ||
+ | Documentation (what can go in the /etc/my.cnf config) | ||
+ | <code bash> | ||
+ | / | ||
+ | |||
+ | # then search for ' | ||
+ | / | ||
+ | </ | ||
---- | ---- | ||
Line 66: | Line 75: | ||
SELinux: Allow mariadb to use the new port | SELinux: Allow mariadb to use the new port | ||
<code bash> | <code bash> | ||
- | semanage port -a -t mysqld_port_t | + | semanage port -a -t mysqld_port_t -p tcp 5502 |
</ | </ | ||
Line 74: | Line 83: | ||
systemctl restart mariadb | systemctl restart mariadb | ||
</ | </ | ||
+ | |||
+ | \\ | ||
+ | Remote clients would need to connect like this example (specifying a port)< | ||
+ | * -h 192.168.1.151 | ||
+ | * --port=5502 | ||
+ | * -u root -> Database username | ||
+ | * -p -> Prompt for password | ||
---- | ---- |