MySQL Operations: Difference between revisions
Jump to navigation
Jump to search
| Line 26: | Line 26: | ||
=Configuration File= | =Configuration File= | ||
{{External|https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#default-option-file-locations-on-linux-unix-mac}} | {{External|https://mariadb.com/kb/en/configuring-mariadb-with-option-files/#default-option-file-locations-on-linux-unix-mac}} | ||
Default location: | |||
/etc/my.cnf | |||
=Change Root Password= | =Change Root Password= | ||
Revision as of 20:18, 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
Default location:
/etc/my.cnf
Change Root Password
/usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h now510.local password 'new-password'