So I installed MySQL on my machine. How do I now connect to this to edit permissions and such? I'd like to use something like Navicat to do so, as my SQL is rather rusty. So what username/password ...

For example, type:mysqldump -u root -p sourcedatabase | mysql -h localhost newdatabase Browse the database from the command line or with a tool such as phpMyAdmin to verify that the copy operation ...

Maybe I'm going about this the hard way, but here's what I'm trying to do:I need to run a script on a central workstation that will run a query on two remote MySQL boxes and return the output of ...