MySQL command-line program

Is there a windows or linux program to make MySQL queries in a command-line software? something classy kinda like MS-DOS or something like that? not something Web-based like PHP-MyAdmin.

Any suggestions?