3,254
edits
Changes
From SME Server
Jump to navigationJump to search→Usage
<!-- we define the language -->
<!-- we define the language -->
{{#vardefine:lang| {{lc: {{#titleparts: {{PAGENAME}} | | -1}} }} |en }}
{{#vardefine:lang| {{lc: {{#titleparts: {{PAGENAME}} | | -1}} }} |en }}
{{Infobox contribs
{{Warning box|1=currently in alpha test stage, please use only on test server and use --enablerepo=smetest with yum commands}}{{Infobox contribs
|name={{#var:contribname}}
|name={{#var:contribname}}
|image=Mariadb-logo-vert_blue-transparent.png
|image=Mariadb-logo-vert_blue-transparent.png
Some of the properties are not shown, but are defaulted in a template or a script. Here a more comprehensive list with default and expected values :
Some of the properties are not shown, but are defaulted in a template or a script. Here a more comprehensive list with default and expected values :
{| class="wikitable"
{| class="wikitable"
!property
!property {{#var:contribname}}-mariadb
!default
!default
!values
!values
!
!
|-
|-
|DbName
|LocalNetworkingOnly
|nextcloud
|yes
|string
|yes,no
|for mysql db
|default provides only socket acces
|-
|-
|DbPassword
|TCPPort
|GENERATED
|
|string
|port empty
|for mysql db
|keep empty for security prupose
|-
|-
|DbUser
|port
|nextcloud
|
|string
|port number
|for mysql db
|default 3313 if empty
|-
|-
|access
|access
|
|
|private, public,<nowiki>''</nowiki>
|default empty for only localhost access
|-
|-
|status
|status
|enabled
|enabled
|enabled,disabled
|enabled,disabled
|
|}
{| class="wikitable"
!property {{#var:contribname}}-mysql.init
!default
!values
!
|-
|status
|enabled
|enabled,disabled
|
|}
|}
===Usage===
===Usage===
you can access using command line with the following commands, a few similar ones. in doubt you can use the --socket=/var/lib/mysql/mariadb105.sock after the mysql command you want.
mysql105
msqlshow105
mysqladmin105
mysqldump105
mysqlimport105
mysqlbinlog105
Alternatively:
The complete path to the specific version of mysql57 server with the mysql client would be:
/opt/rh/rh-mariadb105/root/usr/bin/mysql --socket=/var/lib/mysql/mariadb105.sock
or
mysql --socket=/var/lib/mysql/mariadb105.sock
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.
some other php app migh need something like
some other php app migh need something like
localhost;unix_socket=/var/lib/mysql/mariadb105.sock
localhost;unix_socket=/var/lib/mysql/mariadb105.sock
=== Resetting the MySQL root password ===
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.
Any restart of the server will do the job
systemctl restart {{#var:contribname}}-mariadb.service
=== Uninstall ===
=== Uninstall ===
yum remove {{#var:smecontribname}} {{#var:contribname}}
yum remove {{#var:smecontribname}} rh-{{#var:contribname}}*
=== Bugs ===
=== Bugs ===
<!-- Please keep there the template revision number as is -->
<!-- Please keep there the template revision number as is -->
[[contribtemplate::2| ]]
[[contribtemplate::2| ]]
