Two Easy Ways to Determine MySQL Database File Location

Two Easy Ways to Determine MySQL Database File Location:

mysql -u root -p
select @@datadir;
+-----------------+
| @@datadir |
+-----------------+
| /var/lib/mysql/ |
+-----------------+
1 row in set (0.00 sec)

Or simply edit the my.cnf file – which in my case on this RHEL VM is in /etc/my.cnf
datadir=/var/lib/mysql
More from LonzoDB on AWS