when I install a new wordpress site it tells me the database is called wrdp_10.
some of my sites that I've done in the past have got their individual name instead. i.e. wrdp_mysite.

How can I get it to use a name instead of a number? That way I can easily identify what database is what.

I am using Fantastico for installation.

thanks

Most "one button" installations, such as Fantastico, will use a single name for their database and just keep incrementing a counter (wrdp_1, wrdp_2, ...). You have to install manually if you want to custom name the database. Failing that, you have two choices:
  1. Just keep a list of what database corresponds to what application. Keep a copy of the file on the site so you won't lose track of it. Refer to it whenever you want to do something manually with the databases.
  2. If you can find your way around phpMyAdmin and the Wordpress configuration file(s), you ought to be able to rename the database in phpMyAdmin, and update the name in the config file(s). Not for the extremely faint of heart, but quite possible. Shut down the application using the database first, so that it's not being actively used while being changed.