MySQL Database SetupPlease, log into your cPanel and click on MySQL Databases. Look for the “Create Database” button: Here you create the MySQL database that will be used by your SMF instalation for storing all comments, polls and results, and almost everything else that SMF needs to remember. Pick a simple name for the database (e.g. ‘smfdb’), fill it in and click on the “Create Database” button. Now that you have created the database, you also need to make sure that SMF will be able to access it. You need to create a MySQL user that has privileges for accessing the database. Again, go to cPanel -> MySQL Databases and find the “Create User” button. Right above it, fill in a username and password for the MySQL user. It is a good idea to keep the username the same as the name of the database. Ready? Take a note of the password and username you selected and click on the “Create User” button. At this point, the only thing left to do about database setup is to grant privileges to the user for the database. On the cPanel -> MySQL Databases page, find the two drop-down menus for users and databases, select your SMF database and the user you have created, leave the Privileges: ALL checked and click on “Add User to Database”. 
We’re now ready to proceed with the SMF installation. |