I would like to be able to access my mysql tables via cmd prompt.

[zoran]

I would like to be able to access my mysql tables via cmd prompt.

but when I type:

C:\XAMPP\mysql\bin\mysql *.sql

I get only one database displayed as being on the localhost.

[trq]

mysql doesn't take a file name as an argument, what exactly are you trying to do?

[zoran]

I just want to display all my databases and tables in them using cmd (dos) prompt. I am new to this so I cant explain the command I typed as it came from a tutorial

[trq]

So... you login.

 

mysql -u<uyourusername> -p

 

you will get a mysql> prompt.

 

Then,  to view databases....

 

SHOW DATABASES;

 

to view tables within a database.....

 

USE databasename;
SHOW TABLES;

[zoran]

I type in :

C:\xampp\mysql> -u<'root'> -p

and get

'-u' is not a recognised as an external or internal command operable program  or  a batch file

[trq]

You should be using....

 

C:\xampp\mysql -uroot -p

[zoran]

does not work still...

[trq]

Weird.

 

Try without any options then and see if it prompts you for a username / password.

[zoran]

I dont follow

all I type is C:\xamp\mysql> -uroot -p

what options do you meen?

[trq]

all I type is C:\xamp\mysql> -uroot -p

 

There is no > after mysql, look again.....

 

C:\xampp\mysql -uroot -p

 

what options do you meen?

 

-u and -p are options (or arguments) to the mysql command.

[zoran]

I dont know how to get cmd display  the prompt without the >

i.e. C:\xampp\mysql

I use cd to change directories to go up, and cd C:\ to get all the way back and start again to the directory I want, so the prompt  line is always ending with a >

[trq]

Ah now I see. So....

 

C:\xampp\mysql>

 

Is your prompt? I thought that was what you where actually typing.

 

Is the mysql command within the C:\xampp\mysql directory? If it is, go to that directory and type the command I showed you.

 

This would mean the entire line would look like....

 

C:\xampp\mysql>mysql -uroot -p

 

Including the prompt.