Topic: [Tutorial] Creating a MySQL Database and Username

[Neša]

The easiest way to make a database and assign a username to it is by using the MySQL wizard in you're cpanel.



Put in the name you would like for your database, we have called ours database1. What a genius name



Now we pick a username and password.



Now we have to assign the permissions, we want this user to have all the permission on database1 so we click on "All Privileges"



This is telling us that we have successfully made the database and username. Now click on return home



Click on the MySQL Databases Link



You should see you're database and the username that is assigned to it. In our case our full database name is smftest_database1 and our full username is smftest_user2. This is the full name and what you need to fill in when you install SMF or any other script that needs MySQL access.

[sheryltoo]

I've set up databases before and I want to set up one again only it was awhile ago so I'm trying to refresh my memory on how to do it.  I thought I rememberd having to set some permissions using CHmod. This isn't mentioned in this tutorial. Does that mean I don't need to change any other permissions after I set up a new database?
Sheryl

[Neša]

You chmod files not the database, after its created, you need to give access to it. You pick a user and give him admin access to the database, so he/she can make tables and do other fancy things