How can I tell which Database MySQL is using?

How do I know which database MySQL is using?

MySQL provides a command using which you can use to know the current selected database. SELECT DATABASE(); This command can be executed both from MySQL workbench or MySQL command line.

How do you know which DB we are using?

How to know which database is in use currently? For using a particular database, MySQL has <code>Use </code> statement. After you execute USE statement, by default all the query will be executed against the database mentioned in USE statement. "select database()".

How do I find where MySQL database is located?

Resolution1Open up MySQL's configuration file: less /etc/my.cnf.2Search for the term "datadir": /datadir.3If it exists, it will highlight a line that reads: datadir = [path]4You can also manually look for that line. ... 5If that line does not exist, then MySQL will default to: /var/lib/mysql.