Hello people
Im so lost. I do not know how to configure a database and a user the best way. I can see there is a lot of ways to create a user an a database. But what is the best way to do it?
I have plans on doing a lot of different websites, and I would like to have a different user to each database with a password. Is that a good way to do it?
Lets say I am making a new website.
So I go into Xampp and will create a new user.
1. Shall I first create the user or the database and then create a new database?
2. You can also first create the database, and then go into your new database and choose privileges and add a new user. Then you can choose "Grant all privileges on database "your database" But If you create the user first, shall I then choose this option "Grant all privileges on wildcard name (username\_%)" But what is the best way to do it? Create the database or the user first?
3. You can also go into your database and see the users that can use the database and under "edit privileges" there is a category named "Database-specific privileges" where there is this option "Add privileges on the following database" where you can choose a database. What does that do?
4. When i choose one of my databases and choose the option "privileges" then I can see, that all my users have access to the database. I just want to have one specific user to each database. I don't want all my users to have access to all of my databases. How do I that?
Like you can hear, im very confused about all these ways to make users and databases. But I just want a separate database and user to each of my websites. So I easily can upload the database in Xampp to my webhosting company, when it is done. Will you please help me and tell me the best way to make a database with one user to each of my websites.