Posted on January 9, 2021 at 1:40 pm
On older MySQL versions you could use:
/etc/mysql/debian.cnf |
To get MySQL username and password to use for backup purposes.
On newer MySQL v8+ versions you just need to run this command as root user:
mysql -u root -h localhost ... |
Password is not required in this case.
This is because it uses unix_socket authentication as explained here:
https://www.percona.com/blog/2019/11/01/use-mysql-without-a-password/
To allow another Linux user to auto-connect to MySQL with full privileges:
GRANT ALL PRIVILEGES ON *.* TO 'vagrant'@'localhost' IDENTIFIED VIA unix_socket; |
This works also on recent MariaDB versions.
Other Posts
- How to List All Iptables NAT Rules
- Parse or Split FTP URL in Delphi XE using TIdURI
- How to Download a File via FTP in Delphi XE
- Public FTP Server to Test Upload and Download
- How to Parse Command-Line Arguments in Bash
- How to Make Iptables Rules Persistent
- Bash Install Iptables-Persistent Automatically
- Route OpenVPN Connections Through Floating IP
Updated Posts
- How to fix "Clickable elements too close together"
- How to fix "Text too small to read"
- Create Custom Rest Endpoints for WP Rest API
- Timestamp URLs for SHA1 SHA256 Code Sign 2021
- PHP Multi-cURL to Run Parallel cURL Requests (Example)
- The following signatures were invalid: EXPKEYSIG B188E2B695BD4743
- Best Clean Monospace Web Fonts 2021
- Add New Path to Delphi 10.4 Sydney on Library Path