View Single Post
  #1   (View Single Post)  
Old 1st April 2014
J65nko J65nko is offline
Administrator
 
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 4,128
Default Show default MySQL database

With MySQL you can easily switch between databases. The following SQL snippet allows you to make sure that you are working with the correct database:
Code:
-- MySQL show current, default or database in use ...

select "Current database in use ...." 
 union
select database() ;
Example:
Code:
mysql> source show-use ;
+------------------------------+
| Current database in use .... |
+------------------------------+
| Current database in use .... |
| Siralas2013                  |
+------------------------------+
2 rows in set (0.00 sec)

mysql> use Siralas2012 ;
Database changed

mysql> source show-use ;
+------------------------------+
| Current database in use .... |
+------------------------------+
| Current database in use .... |
| Siralas2012                  |
+------------------------------+
2 rows in set (0.00 sec
__________________
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump
Reply With Quote