On 5/20/05, Chris Green chris@areti.co.uk wrote:
I always have this problem when I come back to using mysql.
How do I find out what mysql databases I have set up?
The mysql daemon (mysqld) is running, I can run 'mysql' and I get the 'mysql>' prompt but that's it, there seems ot be no simple way of finding out what databases there are there to use.
In postgresql it is simply typing \l (as in "l" for list) at the psql prompt. You can also \h for a list of useful commands. Worth a try, anyway! Jen