connecting to database

[ball420]

what is the best way to connect to a database remotly so that i can create tables and what not. on my local machine i use wamp5, somthing with a gui would be nice. help!!!!

[bubblegum.anarchy]

SQLyog: http://www.webyog.com/en/

[doogles]

you could go into your MySQL DOS box and simply type in your password then enter the following:

 

use [database name];

 

then do what you wish.

 

Or if you working with PHP, do something like:

 

$conn=mysql_connect("localhost", "[username]", "[password]");
mysql_select_db("[database name]", $conn);