Mysql Viewer
Moderator: General Moderators
- Mastermind
- Forum Commoner
- Posts: 36
- Joined: Thu Mar 10, 2005 2:38 am
- Location: CDO,Philippines
- Contact:
Mysql Viewer
How to view your mysql databases and fields using DOS Prompt
MySQL has a command line tool found in the bin directory.
on widows this is usually in:
c:\MySQL\bin
or
c:\program files\mysql server %version%\MySQL\bin
I don't know where it resides on *nix
once there just log in using mysql -u username -p
it will prompt you for a password and whola, you can start running queries.
to change to your database, just use "use %database%;"
on widows this is usually in:
c:\MySQL\bin
or
c:\program files\mysql server %version%\MySQL\bin
I don't know where it resides on *nix
once there just log in using mysql -u username -p
it will prompt you for a password and whola, you can start running queries.
to change to your database, just use "use %database%;"