MySQL Operations: Difference between revisions

From NovaOrdis Knowledge Base
Jump to navigation Jump to search
Line 24: Line 24:


<tt>/var/run/mariadb</tt>
<tt>/var/run/mariadb</tt>
=Configuration File=
{{External|https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#default-option-file-locations-on-linux-unix-mac}}


=Change Root Password=
=Change Root Password=

Revision as of 20:17, 17 November 2021

Internal

Version

Connect to the database then execute:

SELECT VERSION();

Logs

/var/log/mariadb/

/var/log/mysql/

Data Directory

/var/lib/mysql

Runtime Directory

/var/run/mariadb

Configuration File

https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#default-option-file-locations-on-linux-unix-mac

Change Root Password

/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h now510.local password 'new-password'

Command Line Client

mysql Command Line Client

Subjects