How to Manage MySQL Databases and Users in cPanel

Last updated: February 7, 2026Reviewed date: February 7, 2026Reading time: 5 min read

Patient Tools

Read, save, and share this guide

Use these quick tools to make this medical article easier to read, print, save, or share with a family member.

Patient Mode

Understand this article easily

Switch between simple English and easy Bangla patient notes. This is for education and does not replace a doctor consultation.

How to manage MySQL databases and users in cPanel/phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes,...

For severe symptoms, danger signs, pregnancy, child illness, or sudden worsening, seek urgent medical care.

বাংলা রোগী নোট এখনো যোগ করা হয়নি। পোস্ট এডিটরে “RX Bangla Patient Mode” বক্স থেকে সহজ বাংলা সারাংশ যোগ করুন।

এই তথ্য শিক্ষা ও সচেতনতার জন্য। এটি ডাক্তারি পরীক্ষা, রোগ নির্ণয় বা প্রেসক্রিপশনের বিকল্প নয়।

Article Summary

Key Takeaways

This article explains Managing Database Users in simple medical language.

Educational health guideWritten for patient understanding and clinical awareness.

Reviewed content workflowUse writer and reviewer profiles for stronger trust.

Emergency safety firstUrgent warning signs are highlighted below.

Seek urgent medical care if you notice

These warning signs are general safety guidance. Local emergency numbers and clinical judgment should always come first.

Severe symptoms, breathing difficulty, fainting, confusion, or rapidly worsening illness.
New weakness, severe pain, high fever, or symptoms after a serious injury.
Any symptom that feels urgent, unusual, or unsafe for the patient.

Emergency now

Use emergency care for severe, sudden, rapidly worsening, or life-threatening symptoms.

See a doctor

Book a professional medical evaluation if symptoms persist, worsen, recur often, affect daily activities, or occur in a high-risk patient.

Learn safely

Use this article to understand possible causes, tests, treatment options, prevention, and questions to ask your clinician.

Before reading

RX Patient Tools

Use these quick guides before reading the article, or return to them when you need help preparing questions for a doctor.

Start here Choose the right pathway for symptoms, reports, medicines, or urgent warning signs. Disease article roadmap Read this topic step by step: meaning, symptoms, warning signs, diagnosis, treatment, prevention, and follow-up. Treatment planner Prepare questions about treatment choices, benefits, risks, side effects, and follow-up. Family & caregiver guide Organize symptoms, reports, medicines, questions, and follow-up safely. Nutrition & diet guide Prepare food, hydration, supplement, and medicine-timing questions safely. Prevention guide Organize risk factors, protective habits, screening, and warning signs. Recovery guide Prepare a safe plan for activity, rehabilitation, warning signs, and follow-up.

This article describes how to use cPanel to manage MySQL databases and users. You can add, modify, and delete databases and users, as well as manage user database permissions.

Managing Database Users

To access MySQL databases, you must first create at least one user. The following procedures describe how to manage MySQL database users using cPanel.

Creating a database user

To create a MySQL database user, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account,
In the DATABASES section of the cPanel home screen, click MySQL® Databases:
Under Add New User, in the Username text box, type the MySQL username.
In the Password text box, type the user password.
In the Password (Again) text box, retype the user password.
You can click Password Generator and cPanel generates a random, strong password for you.
Click Create User. cPanel creates the database user.

Changing a user’s password

You can change a database user’s password. You may want to do this for security reasons (changing passwords periodically is a good security practice), or you may need to do this if you forget the password.

To change a MySQL user’s password, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account,
In the DATABASES section of the cPanel home screen, click MySQL® Databases:
Under Current Users, locate the user for which you want to change the password, and then click Change Password.
In the Password and Password (Again) text boxes, type the new password.
You can click Password Generator and cPanel generates a random, strong password for you.
Click Change Password. The new password takes effect immediately.

Renaming a user

To rename a MySQL user, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account,
In the DATABASES section of the cPanel home screen, click MySQL® Databases:
Under Current Users, locate the user that you want to rename, and then click Rename.
In the New name text box, type the new name, and then click Proceed. cPanel renames the user.

Deleting a user

When you delete a user, the user and its database permissions are deleted.

Make sure you do not have any applications that currently use the database user!

To delete a MySQL user, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account
In the DATABASES section of the cPanel home screen, click MySQL® Databases:
Under Current Users, locate the user that you want to delete, and then click Delete.
Click Delete User to confirm the deletion.

MANAGING DATABASES

After you create a database user, you are ready to create a database and associate the user with the new database.

Creating a database

To create a MySQL database, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account
In the DATABASES section of the cPanel home screen,
Under Create New Database, in the New Database text box, type the name of the database.
Click Create Database. cPanel creates the database.
When you create a database, your username is prefixed to the database name. For example, if your username is a username, and you create a database named database, the actual MySQL database name is username_database.

Adding a user to a database

To add a MySQL user to a database, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account
In the DATABASES section of the cPanel home screen,
Under Add User to Database, in the User list box, select the user that you want to add.
In the Database list box, select the database.
Click Add.
Select the checkboxes to grant the user-specific privileges, or select the ALL PRIVILEGES checkbox to grant the user all permissions to the database.
Click Make Changes. cPanel adds the user to the database.

Checking and repairing a database

You can check MySQL databases for errors or possible corruption. If a database check reveals problems, you can repair the database as well.

To check and repair a database, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account
In the DATABASES section of the cPanel home screen,
To check a database:
- Under Modify Databases, in the Check Database list box, select the database.
- Click Check Database.
If a database check indicates problems with a database, you can repair it:
- Under Modify Databases, in the Repair Database list box, select the database.
- Click the Repair Database.

Revoking privileges from a database user

When you revoke a database user’s privileges, the user can no longer access the database. To do this, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account
In the DATABASES section of the cPanel home screen,
Under Current Databases, locate the user for which you want to revoke privileges, and then click the trash can icon.
Click Revoke User Privileges from Database.

Deleting a database

Before you delete a database, make sure that you have a backup copy if you want to save any information that it contains.

When you delete a database, any associated users are not deleted. However, all privileges users have for that database are revoked.

To delete a MySQL database, follow these steps:

Log in to cPanel.
If you do not know how to log in to your cPanel account,
In the DATABASES section of the cPanel home screen,
Under Current Databases, locate the database that you want to delete, and then click Delete.
Click Delete Database. cPanel deletes the database.

References

Safety note: This is not a prescription or diagnosis. For severe symptoms, pregnancy danger signs, children with serious illness, chest pain, breathing difficulty, stroke-like weakness, or major injury, seek urgent care.

Which doctor may help?

Start with a registered doctor or the nearest qualified health center.

What to tell the doctor

Write when the problem started and how it changed.
Bring old prescriptions, investigation reports, and current medicines.
Write allergies, pregnancy status, diabetes, kidney/liver disease, and major past illnesses.
Bring one family member if the patient is weak, elderly, confused, or a child.

Questions to ask

What is the most likely cause of my symptoms?
Which danger signs mean I should go to hospital quickly?
Which tests are necessary now, and which can wait?
How should I take medicines safely and what side effects should I watch for?
When should I come for follow-up?

Tests to discuss

Vital signs: temperature, pulse, blood pressure, oxygen saturation
Basic physical examination by a clinician
CBC, urine test, blood sugar, or imaging only when clinically needed

Avoid these mistakes

Do not use antibiotics, steroid tablets/injections, or strong painkillers without proper medical advice.
Do not hide pregnancy, kidney disease, ulcer, allergy, or blood thinner use.
Do not delay emergency care when danger signs are present.

Medicine safety and first-aid guide

This section is for patient education only. It does not replace a doctor, pharmacist, or emergency care.

Safe first steps

Rest, drink safe water, and observe symptoms carefully.
Keep a written note of symptoms, duration, temperature, medicines already taken, and allergy history.
Seek medical care quickly if symptoms are severe, worsening, or unusual for the patient.

OTC medicine safety

For mild pain or fever, ask a registered pharmacist or doctor before using common over-the-counter pain/fever medicines.
Do not combine multiple pain medicines without advice, especially if you have kidney disease, liver disease, stomach ulcer, asthma, pregnancy, or take blood thinners.
Do not give adult medicines to children unless a qualified clinician advises it.

Avoid these mistakes

Do not start antibiotics without a proper medical decision.
Do not use steroid tablets or injections casually for quick relief.
Do not delay emergency care because of home remedies.

Get urgent help if

Severe symptoms, confusion, fainting, breathing difficulty, chest pain, severe dehydration, or sudden weakness need urgent medical care.

Medicine names, dose, and timing must be decided by a qualified clinician or pharmacist after checking age, pregnancy, allergy, other diseases, and current medicines.

For rural patients and family caregivers

Patient health record and symptom diary

Write your symptoms, medicines already taken, test results, and questions before visiting a doctor. This note stays on your device unless you print or copy it.

Doctor to discuss: Doctor / qualified healthcare provider

Tests to discuss with doctor

Basic vital signs: temperature, pulse, blood pressure, oxygen level if needed
Relevant blood, urine, imaging, or specialist tests only after clinical assessment

Questions to ask

What is the most likely cause of my symptoms?
Which warning signs mean I should go to emergency care?
Which tests are really needed now?
Which medicines are safe for my age, pregnancy status, allergy, kidney/liver/stomach condition, and current medicines?

Emergency warning signs such as chest pain, severe breathing difficulty, sudden weakness, confusion, severe dehydration, major injury, or loss of bladder/bowel control need urgent medical care. Do not wait for online information.

Go to emergency care if you notice:

Severe or rapidly worsening symptoms
Breathing difficulty, chest pain, fainting, confusion, severe weakness, major injury, or severe dehydration

Doctor / service to discuss: Qualified healthcare provider; specialist depends on symptoms and examination.

Step 1
Check danger signs first

If danger signs are present, seek emergency care and do not wait for online information.
Step 2
Record the symptom story

Write when symptoms started, severity, medicines already taken, allergies, pregnancy status, and test results.
Step 3
Visit a qualified clinician

A doctor, nurse, or qualified healthcare provider can examine you and decide which tests or treatment are needed.
Step 4
Do only useful tests

Do tests after clinical assessment. Avoid unnecessary tests, random antibiotics, or repeated medicines without diagnosis.
Step 5
Follow up and return early if worse

If symptoms worsen, new warning signs appear, or treatment is not helping, return for review quickly.

Rural patient practical tips

Take a written symptom diary and all previous prescriptions/test reports.
Do not hide medicines already taken, even herbal or over-the-counter medicines.
Ask which warning signs mean urgent referral to hospital.

This roadmap is for education. A real diagnosis and treatment plan requires history, examination, and clinical judgment.

RX Patient Help

Ask a health question safely

Write your symptom story. A health professional or site editor can review it before any answer is prepared. This box is not for emergency care.

Emergency first: Severe chest pain, breathing trouble, unconsciousness, stroke signs, severe injury, heavy bleeding, or rapidly worsening symptoms need urgent local medical care now.

Website

Name or nickname Phone / contact District / area Age group Sex Severity today

Main symptoms How long has it been happening? Medicines already taken Tests already done Your question 0/1200

Frequently Asked Questions

Is this article a replacement for a doctor?

No. It is educational content only. Patients should consult a qualified clinician for diagnosis and treatment.

When should I seek urgent care?

Seek urgent care for severe symptoms, rapidly worsening condition, breathing difficulty, severe pain, neurological changes, or any emergency warning sign.

References

Add references, clinical guidelines, textbooks, journal articles, or trusted medical sources here. You can edit this area from the RX Article Professional Blocks panel.

Understand this article easily

Article Summary

Key Takeaways

Seek urgent medical care if you notice

Emergency now

See a doctor

Learn safely

RX Patient Tools

Managing Database Users

Creating a database user

Changing a user’s password

Renaming a user

Deleting a user

MANAGING DATABASES

Creating a database

Adding a user to a database

Checking and repairing a database

Revoking privileges from a database user

Deleting a database

References

Prepare before seeing a doctor

Which doctor may help?

What to tell the doctor

Questions to ask

Tests to discuss

Avoid these mistakes

Medicine safety and first-aid guide

Safe first steps

OTC medicine safety

Avoid these mistakes

Get urgent help if

Patient health record and symptom diary

Care roadmap for: How to Manage MySQL Databases and Users in cPanel

Check danger signs first

Record the symptom story

Visit a qualified clinician

Do only useful tests

Follow up and return early if worse

Ask a health question safely

Frequently Asked Questions

References

Related Articles