Can I change MySQL DB settings... UserName, DBName, PW?

Web hosting discussion, programming, and shared and dedicated servers.
2 posts Page 1 of 1
by dwhittaker » Thu Aug 14, 2014 12:00 pm
The MySQL database that's automatically installed and configured when you install wordpress, auto-generates some horrid settings: DB name, user name and password. I'd like to change these. Where and how? Do I simply edit the wp-admin.php file shown below? That is the longest password I've ever seen and surely I can at least change that I'm hoping. :lol:


// ** MySQL settings ** //
define('DB_NAME', '886XXXXXXX'); // The name of the database
define('DB_USER', '886XXXXXXX'); // Your MySQL username
define('DB_PASSWORD', 'c40ad02dba9acXXXXXXXXXXXXXXXXXXXXX'); // ...and password
define('DB_HOST', 'b.custsql.sonic.net'); // 99% chance you won't need to change this value
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
define('WP_SITEURL', 'http://neptunemedia.netxxxxxxxxxxx');
by cdkeen » Thu Aug 14, 2014 2:44 pm
If you used the once click installer we provide for wordpress you can administer the settings for the database via this url: https://members.sonic.net/databases/ You can change the password for the 3 available users (all,rw,ro), and create new databases if you need.

I would recommend checking out the first link for an understanding of the wordpress password mechanisms (http://eamann.com/tech/wordpress-password-hashing/) and the second for an exhaustive list of how to reset your password in wordpress (http://codex.wordpress.org/Resetting_Your_Password).

I hope that helps! Thanks for choosing Sonic.net!
cdkeen - Sonic.net System Operations
2 posts Page 1 of 1