mysql: [Warning] Using a password on the command line interface can be insecure. It's that simple—you've now restored your database dbname in the condition it was when you dumped it.

I tried using the following commands to shutdown and startup MySQL and although it did, it also changed the permissions on the databases and I could no longer work with them in phpmyadmin until i ...

You can copy a MySQL database to a website using a tool such as phpMyAdmin or by using the MySQL command line. Create a new target database, export the data from the source database and import it ...