Creating a MySQL database

Most dynamic websites need a database. On Nakroteck hosting you can create one in under a minute.

In cPanel

1. Log in to cPanel from the client area.
2. Under Databases, click MySQL Databases.
3. Under Create New Database, type a name. cPanel adds your account prefix automatically.
4. Scroll to MySQL Users. Create a user with a strong password.
5. Scroll to Add User To Database. Pick the user and the database, then grant ALL PRIVILEGES.

In Plesk

1. Log in to Plesk from the client area.
2. Click Databases in the left sidebar.
3. Click Add Database.
4. Give the database a name, choose a related site, and create a new database user in the same form. Save.

Connection details for your app

• Host: localhost in almost every case.
• Database: the name you just created.
• User: the user you created.
• Password: the password you set.
• Port: 3306 (you rarely need to set this).

phpMyAdmin

Both cPanel and Plesk include phpMyAdmin. Open it from the control panel to run SQL queries, export the database as a backup, or import an existing database file.