MySQL Operations: Difference between revisions

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


=Version=
=Version=
Connect to the database then execute:
<syntaxhighlight lang='sql'>
VERSION()
</syntaxhighlight>


=Logs=
=Logs=

Revision as of 23:08, 29 March 2021

Internal

Version

Connect to the database then execute:

VERSION()

Logs

/var/log/mariadb/

/var/log/mysql/

Data Directory

/var/lib/mysql

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