Hi;
I am trying to give the command of showing all databases in MYSQL, using " show" command but it does not work, although when I choose the database I already know is there and then give command of "show tables;", then the show command works, here is the command I type when mysql is running:
c:\mysql\bin\ show databases;

and then this is the answer i get:

" show is not recognized as an internal or external command, operable command or batch file"

but as I mensioned If I use:
"use mysql"
(as you know this database ( mysql) is already build in MySQL)
and then give the command of :
show tables from Mysql;
then it shows all tables form this database, I wonder why the command does now work on showing database,
as I have read this command in SAMS Teach your self MySQL .
your reply is appreciated.
Thanx

if you're starting out with MySQL i recommend you use MySQLFront (www.mysqlfront.de) it provides an Access-style GUI which makes MySQL a much more pleasant (and powerful) experience.


------------------------
Poolio

MSN:

www.eliziumdesign.com

Thank you for reply,

it seems that MySQL-Front is not available anymore;
is there any other tools which make connection and importing database to Mysql easier. after 2 weeks of installing Mysql I have not been able to import Ms access data into it,
thanx

Manou, i can send you a copy of MySQLfront, send me an e-mail and i will e-mail it to you.

------------------------
Poolio

MSN:

www.eliziumdesign.com