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.)
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.