This tutorial provides step-by-step examples of creating a database and database user using the cPanel MySQL Database Wizard tool.
Login to your hosting control panel (cPanel) with information provided by your host company.
Under the Database section, click on the MySQL Database Wizard icon.
Step 1 in the wizard is creating the database. Simply give your database a name. The actual database name will be prepended by your hosting account name. In this example, after clicking Next Step, the database michaelh_demowp will be created.
The next step in the wizard requires creating a database user and assigning that user a password. When entering the password, make sure the password strength meter registers Very Strong for your selected password. Also remember the password you enter as you will need that information later. In this example, dbuser is entered in the Username field, but when the Create User button is clicked, the database user ultimately will be named michaelh_dbuser.
In Step 3, you assign the user to the database and you assign the necessary database privileges. In this case, click the All Privileges checkbox and click the Next Step button to assign all privileges to the database user.
In this step, you are notified that the user was added to the database. You have successfully created the database, created the user, and assigned privileges to that user.
Open the file wp-config-sample.php using a text editor. There are the four pieces of information you need to complete in the file. The following is an example; yours may look slightly different:
// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'michaelh_demowp');
/** MySQL database username */
define('DB_USER', 'michaelh_dbuser');
/** MySQL database password */
define('DB_PASSWORD', 'here_the_password_you_set_before_');
/** MySQL hostname */
define('DB_HOST', 'localhost');
Note that the prefix michaelh_ assigned by that cPanel is part of the database and database user. Also note, the DB_HOST value for almost all cPanel hosts is localhost.
Important! Save the completed file as wp-config.php.
The database is created, and user is created and assigned to the database with the proper privileges. And the wp-config.php is updated with the database information. At this point it is okay to move to Step 4 of the Installation process.
This tutorial provides step-by-step examples of installing Plesk WP Toolkit using the Plesk Web Installer.
Install Plesk using Web Installer please open your browser and go to get.plesk.com. For Plesk installation, it is required a fresh Linux server with access to the Internet. You can install Plesk on any supported Linux-based OS.
Provide your server's IP address or hostname, enter your root password, or just add a private key.
- Accept the terms of End-User License Agreement and click Install button.
- Relax and wait for some time to let the installation be finalized.
- Click on the Login link. No worries about "secure connection warnings", just make an exception.
WordPress Toolkit is a single management interface that enables you to easily install, configure, and manage WordPress. It is available if the WordPress Toolkit extension is installed in Plesk. WP Toolkit can install, configure, and manage WordPress version 3.7 or later.
The WP Toolkit extension is free with the Web Pro and the Web Host Plesk editions and is available for a fee for the Web Admin edition.
- For an express installation, click Install (Quick). The latest version of WordPress will be installed, and the default settings will be used. The new instance will be available via HTTPS if SSL/TLS support is enabled for the domain.
- If you want to change the default installation settings, click Install (Custom). This enables you to set up the administrator user, select the desired WordPress version, specify the database name, select auto-update settings, and more.
Note: To install WordPress, WordPress Toolkit retrieves data from wordpress.org. By default, if WordPress Toolkit cannot establish connection in 15 seconds, wordpress.org is considered to be unavailable.
Go to WordPress to see all your WordPress instances. WordPress Toolkit groups information about each instance in blocks we call cards.
A card shows a screenshot of your website and features several controls that give you easy access to frequently used tools. The screenshot changes in real time to reflect the changes you make to your website. For example, if you switch the maintenance mode on or change the WordPress theme, the screenshot of the website will change immediately.
In the "Tools" section, click to access the following WordPress Toolkit features:
- "Sync" to synchronize the content of your website with another one.
- "Clone" to make a full copy of your website.
- "Manage Files" to manage the website's files in File Manager.
- "Back Up/Restore" to create a backup of your website and restore it if necessary.
The controls below give you easy access to the following settings and tools:
- "Search engine indexing" shows your website in search results of search engines.
- "Caching (nginx)" speeds up the website load time and reduces server load.
- "Debugging" helps you debug a website that is not ready for viewing and being tested or developed.
- "Maintenance mode" hides your website's content from visitors.
- "Password Protection" specifies the password you will use to log in to WordPress from Plesk.
- 2023-01-26: Original copied from Using cPanel.
- 2022-09-11: Original copied for Plesk.