I'm moving a Wordpress site on to Linode. I was able to move all of the data from all of the DBs by using mysqldump on the existing site, using rsync to move the data, and the the "mysql source" command to rebuild the databases on Linode.

My question is, how do I move all of the Mysql IDs and passwords? Even though I used the --all-databases option on the mysqldump it does not appear like the IDs/passwords were moved.

Thanks, Len

Users and privileges are stored in the "mysql" database, in particular the "db" and "user" tables. Log in to MySQL as root and try to dump/reload them. Make sure you make backups, because this might break your database if you don't do it properly.

On the other hand, if you're moving from a shared host, you'll probably have to recreate the users manually.