How to Create a MySQL Database and User in Webuzo

Almost every modern web application — WordPress, Joomla, a custom PHP site — needs a MySQL database to store its content. In Webuzo you create the database and its user in a couple of minutes, then link them together.

Step 1: Create the database

1. Log in to your Webuzo Enduser Panel.
2. Open the Databases section and click MySQL Databases.
3. Enter a name for your database and click Create Database.

Step 2: Create a database user

1. On the same page, find Add New User.
2. Enter a username and a strong password (use the generator), then create the user.

Step 3: Link the user to the database

1. Under Add User to Database, choose your new user and database.
2. Grant All Privileges so the application can read and write.
3. Click Add.

Write down four things — the database name, username, password and host (usually localhost). Your application will ask for these during setup.

What next?

With the database ready, you can install WordPress (which can create its own database anyway) or manage tables directly in phpMyAdmin.

Frequently asked questions

What should I use as the database host?

In almost every case it is localhost, because the database runs on the same server as your site. Remote connections are the exception and must be enabled separately.

I get “Error establishing a database connection”.

That means the name, user, password or host in your app’s config does not match the database. Our guide on fixing this error walks through it.

How do I back up a database?

Export it from phpMyAdmin — see how to import and export a database in Webuzo.