how to create database?
I am very new to database. I don't know much about it. May you please help me creating my first database. Thankyou!
12 Sep 2020 | 218
~ Satty
raman gulati answered this.
29 Jan 2022
If you are using cPanel, you will have an option of MySql Database on homepage.
Clicking there you will be redirected to a page, where you will be asked to enter database name.
Your database name must be unique.
After entering Database name, click on Create Databse button. This will create a databse for you.
All done for creating a database, but the job is not done yet.
Now you will need an user for your database which will have permission to CRUD database.
CRUD stands for :-
C - Create : To create data.
R - Read : To read data.
U - Update : To update data.
D - Delete : To delete data.
To create a user, you will have to go MySql Database Wizard option next to the MySQL Database option from homepage.
Here you will be asked to fill the credentials for an user to be created.
Credentials like username and password.
After filling all the details click on Create User button.
A new user will be created, now you will need to GRANT PERMISSION to the user in database.
To do so, add your USER to the DATABASE and grant the required permissions (generally ALL).
To grant permission, select the checkbox near to all the permission types as in the picture below :
Now simply click on Next Step button and follow the steps to get your Database with User with Required permissions created.
All done.
1 likes
Top related questions
No related question available! Ask Your Question.
Related queries
Latest questions
What do you mean by Industry?
08 Jan 2023
| 1044
"आप ऑनलाइन पैसा कैसे कमा सकते हैं"– "How Can You Earn Money Online"???
26 Dec 2022
| 1164
https://gplinks.co/AIAex
23 Nov 2022
| 277
किस भगवान के पास था कौन-सा दिव्य धनुष 🙏🏻🏹 - पूरा जाने।
03 Nov 2022
| 962
जिस दिन आपके सब्जी में आमला मिलना शुरू हो गया ... - पूरा पढ़ें।
03 Nov 2022
| 856
100 Best Memes of the Month!
20 Oct 2022
| 1017
Top 10 Memes of this Week!
20 Oct 2022
| 727
HOW TO SET GOALS LIKE A STOIC?
07 Oct 2022
| 531
Top 10 Powerful visuals on Life and Psychology?
07 Oct 2022
| 559
