MySQL Operations: Difference between revisions
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
Connect to the database then execute: | Connect to the database then execute: | ||
<syntaxhighlight lang='sql'> | <syntaxhighlight lang='sql'> | ||
VERSION() | SELECT VERSION(); | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 23:14, 29 March 2021
Internal
Version
Connect to the database then execute:
SELECT 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'