Checking which databases are installed

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

I want to check which databases are installed on my FreeBSD installation. This is what I did: pkg_info | grep mysql
How do I check all in one go whether also sqlite, postgresql, firebird is installed?

Thanks in advance

2

I would first try:
pkg_info | grep -i sql
The -i switch will ignore case-sensitive strings (I hope that is correct).
If it does return, example mysql, you can try:
(as root)
find / -name mysql
This should at least tell where mysql has install example: /usr/mysql/somedatabase
and to connect to your mysql database, check to see if mysql is in the $PATH
which mysql # if not add it to your permissions.

Another tool to use and enginneer your database is Mysql Query Browser

I hope this helps.

3

Thanks, but how does this command find firebird? The idea is not to manage databases, but rather how to use grep when there is a set of strings to be found. Any ideas?

4

Ok, then maybe try:
pkg_info | grep -i '(sql|firebird)'
This will search for either sql or firebird
I think that should do it.