Originally Posted by Old Pedant
Well, I certainly wouldn't leave it as root/root even on my local server.
In any case, if you are uploading the database to some web host, more than likely they will assign both the user name and password to you. It's extremely unlikely that they will give you root access. (I know, for example, that GoDaddy doesn't allow this when you ask them to set up a MySQL DB for you.)
Do you know how to change it mate for local use? Ive troed a couple of things from google and neither have worked