How WordPress Uses mySQL For Blogs
mySQL, the database behind WordPress, could possibly be called the ‘heart’ - after all, unless you ‘pour’ the mySQL data into the blog, it stays a static, lifeless site.
But in any case, mySQL is a very important part of WordPress, so it’s worth knowing a small amount about how it is organized, and how it’s used in WordPress.
The basics of mySQL are simple (at least as far as WordPress is concerned:
- You set up a DATABASE, often in your administration panel (for cPanel users, that can be the mySQL button on the main page).
- You set up a USER account in the same way, and you also give it a PASSWORD.
- You ‘connect’ the DATABASE and USER together. This is because a user account does not automatically connect to a database, for security reasons.
Now if you’re using a setup like Fantastico (another button in your cPanel main page), all this is done for you - but whether it does it, or you do, the result is these three pieces - DATABASE, USER, and PASSWORD.
There’s also a fourth one - HOST - this is the server mySQL runs on (strictly speaking, it’s the connection it runs on, but you get the idea). It’s usually called localhost, although some sites avoid calling it that for security reasons (GoDaddy for example will use a long, cryptic name for it, depending on your account).
And in case you’re wondering, these are the four pieces of information that you need when setting up a WordPress blog by hand, by editing the wp-config.php file:
define('DB_NAME', 'putyourdbnamehere');
define('DB_USER', 'usernamehere');
define('DB_PASSWORD', 'yourpasswordhere');
define('DB_HOST', 'localhost');
The good news is you now know all you’ll need for a WordPress mySQL set up - and even MORE than you need if you use a cPanel setup program like Fantastico!
| ActiveBlogging.com - for information on making your blog successful! Get information like this - and more - inside! Details here or Join Today! |
