Connect to MySQL database

[miraan]

This may seem REALLY obvious, but I am a beginner at MySQL and I have just created a new database in phpmyadmin. I have now opened up the mysql console in cmd, but how do I actually connect to the database. My server would just be localhost. I do not know the basic syntax to connect to a mysql database actually within the mysql cmd. The mysql cmd is the one where it looks like:

mysql>

Please help.

[realin]

i dont understand why you need a console based interface when you got nice gui like PHPmyadmin and mysql query tools if u are a starter level user.
Anyways to connect to mysql thru command line, you path variable shoul be poiting towards bin directory, and if u dontknow how to do that then simply goto install directory and browse into bin folder. say

c:\mysql_install_die\bin

then in the command line write mysql -u username password
to change/select the schema/database write use schema_name
then ur queries ..

hope this helps
cheers !!

[miraan]

Hi, can you give me an example of this please. I do not want to use phpmyadmin because I want to get used to the console.

[realin]

Hi, can you give me an example of this please. I do not want to use phpmyadmin because I want to get used to the console.

i have given u an example already.. please read the above reply

[r035198x]

...

then in the command line write mysql -u username password
...

Better make that

mysql -u username -p 

and then type the password when prompted.
<nitpicking>