20 May
2005
20 May
'05
2:01 p.m.
On Fri, May 20, 2005 at 12:36:12PM +0100, Martyn Drake wrote:
Chris Green wrote:
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.
At the mysql> prompt:
show databases;
will reveal what databases there are. Of course, depending on the location of your MySQL installation (mine is /var/lib/mysql) you can see the database files themselves.
Thanks, that's what I needed. Why doesn't 'help' at the mysql prompt tell you that most useful command?! (I realise the help is only showing the interpreter commands rather than the SQL ones but they might make an exception for 'show')
--
Chris Green (chris@areti.co.uk)
"Never ascribe to malice that which can be explained by incompetence."