Current Databases<\/strong>\u00a0table.<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-current-database-list-view.png\")
<\/p>\n
How to Create Database User<\/h3>\n
After creating the database, a MySQL user account must be created. The database user you create is separate from mail and web administrator accounts. Once created, the user account will need to be granted privileges to access the newly created database.<\/p>\n
Navigate to the\u00a0Database<\/strong>\u00a0section and select\u00a0MySQL databases<\/strong>.<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-control-panel-cpanel.png\")
<\/p>\n
Locate the\u00a0MySQL Users<\/strong>\u00a0section of the\u00a0MySQL Databases<\/strong>\u00a0tool. To quickly find this section, click “Jump to MySQL Users<\/strong>“.<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/cpanel-database-mysqldatabases-mysqlusers-click-jumpto-mysql-users.png\")
<\/p>\n
Enter a username in the\u00a0Add New User<\/strong>\u00a0field.<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/manualinstall-wp-mysqldatabase-add-new-mysql-user.png\")
<\/p>\n
\n- \n
Note:<\/strong>\u00a0The username must be 7 letters or shorter.<\/div>\n<\/li>\n- Input a password into the designated\u00a0Password<\/strong>\u00a0field.\n
Tip:<\/strong>\u00a0If you need assistance creating a strong password, click the\u00a0Generate Password<\/strong>\u00a0button.<\/div>\n<\/li>\n- Enter your password again in the\u00a0Password (Again)<\/strong>\u00a0field to confirm it.<\/li>\n
- Click on the\u00a0Create User<\/strong>\u00a0button.<\/li>\n
- Click on the option\u00a0Go Back<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/manualinstall-wp-mysqldatabase-successfully-create-mysql-user.png\")
<\/p>\n
Add User to the Database and Define a User\u2019s Privileges<\/h3>\n
The user can be attached to the database, and you can also set the privileges. This means you set the type of access a user will have, for example, whether or not the user can add and delete information.<\/p>\n
Assign a Database User<\/h3>\n\n- Go to the\u00a0Database<\/strong>\u00a0section and\u00a0MySQL databases<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-control-panel-cpanel-1.png\")
<\/p>\n
Add a user to the database and choose the desired user from the\u00a0User<\/strong>\u00a0drop-down menu.<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-add-user-to-database.png\")
<\/p>\n
\n- Choose the database from the drop-down menu you want to grant user access to.<\/li>\n
- Click\u00a0Add<\/strong>.<\/li>\n
- On the MySQL Account Maintenance screen, you can choose the privileges to grant the user or select\u00a0ALL PRIVILEGES<\/strong>.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-assign-privileges-user-database.png\")
<\/p>\n
\n- Click\u00a0Make Changes<\/strong>.<\/li>\n
- Your new database is now ready for WordPress. Next, configure your wp-config.php file.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-success-privileges-onthe-database-1.png\")
<\/p>\n
The\u00a0wp-config.php<\/strong>\u00a0file contains the database information and tells WordPress which database to pull data from. This step is important to ensure the correct database relating to the corresponding WordPress installation is properly connected.<\/p>\nManual WordPress installations typically require you to locate the file\u00a0wp-config-sample.php<\/strong>\u00a0and rename the file to wp-config.php.<\/p>\nAccess the File Manager and locate the\u00a0wp-config-sample.php file<\/strong>.<\/p>\nThe\u00a0
wp-config.php<\/strong>\u00a0file is located in the File Manager folder, where your newly manual WordPress is installed. It is typically located in the File Manager primary folder, which is your\u00a0public_html<\/strong>\u00a0by default.<\/div>\nNote:<\/strong>\u00a0If this is not the primary domain, identify which folder the website is being placed in.<\/div>\n\n- Once you locate the file\u00a0wp-config-sample.php<\/strong>, it is time to rename the file. Simply right-click on the file name, and a pop-up will appear. Select Rename. Modify the name of the file. Ensure the name of the file is\u00a0wp-config.php<\/strong>.<\/li>\n
- Right-click the file again, and options will pop-up. Select the\u00a0Edit<\/strong>\u00a0option. Enter the new database information, including the database name, database user, and database password.<\/li>\n
- After making the necessary updates, save the changes by clicking the Save Changes button.<\/li>\n<\/ul>\n
\n- Locate the\u00a0wp-config-sample.php<\/strong>\u00a0file.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-filemanager-wp-config-sample-php-database.png\")
<\/p>\n
Right-click this file, then choose the\u00a0Rename<\/strong>\u00a0option<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-filemanager-rename-wp-config-sample-php-database.png\")
<\/p>\n
\n- Rename the file to\u00a0wp-config.php<\/strong>.<\/li>\n
- Right-click the new\u00a0wp-config.php<\/strong>\u00a0file.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-wp-config-php-database.png\")
<\/p>\n
Right-click this file, then choose the\u00a0Edit<\/strong>\u00a0option.<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-filemanager-edit-wp-config-php-database.png\")
<\/p>\n
\n- New windows appear. Click the\u00a0Edit<\/strong>\u00a0button again.<\/li>\n
- A new pop-up window will appear. Select the\u00a0Edit<\/strong>\u00a0option.<\/li>\n
- Look for the following information when the file opens.\n
\n
\/** The name of the database for WordPress *\/ \r\n\tdefine( 'DB_NAME', 'database_name_here' ); \r\n\t \r\n\t\/** MySQL database username *\/ \r\n\tdefine( 'DB_USER', 'username_here' ); \r\n\r\n\t\/** MySQL database password *\/ \r\n\tdefine( 'DB_PASSWORD', 'password_here'' ); \r\n\r\n\t\/** MySQL hostname *\/ \r\n\tdefine( 'DB_HOST', 'localhost' );<\/code><\/pre>\n<\/div>\n\n- \n
\n- Replace\u00a0database_name_here<\/strong>\u00a0with the name of the database and user you created in the steps above.<\/li>\n<\/ul>\n
\n- Replace\u00a0username_here<\/strong>\u00a0with the username of the database you created.<\/li>\n<\/ul>\n
\n- Replace\u00a0password_here<\/strong>\u00a0with the password of the database that you created.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n
Note:<\/strong>\u00a0Make sure there are no spaces before or after your database name, username, and password.<\/div>\n<\/li>\n- Once finished, click the\u00a0Save Changes<\/strong>\u00a0button in the upper right corner, followed by\u00a0Close<\/strong>\u00a0to exit and return to the File Manager.<\/li>\n<\/ol>\n
Step 5: Run the Installation<\/h2>\n
To run the installation script, open a new browser tab or browser window and enter your domain. You will be automatically redirected to one of the following URLs, depending on where you installed the script.<\/p>\n
If you uploaded WordPress to your main domain\u2019s (root directory) folder, you should automatically be redirected to the following URL:<\/p>\n
https:\/\/example.com\/wp-admin\/install.php<\/code><\/pre>\nIf you uploaded WordPress in a subfolder of your main domain\u2019s directory, the following URL will appear:<\/p>\n
https:\/\/example.com\/yoursubfolder\/wp-admin\/install.php<\/code><\/pre>\nImportant:<\/strong>\u00a0Substitute ‘example.com<\/em>‘ for your actual domain name.<\/div>\n\n- When you navigate your correct WordPress URL in a browser, you will be prompted to select your preferred language. Choose your preferred language and then press the Continue button.<\/li>\n
- You should now see a welcome page that says, “Welcome to WordPress. Before getting started, you will need to know the following items.” Click Let’s Go!<\/li>\n
- Enter the database name and user you previously created, and then click Submit.<\/li>\n<\/ul>\n
Important:<\/strong>\u00a0If you see a message that says, “The file wp-config.php already exists. If you need to reset any of the configuration items in this file, please delete it first. You may try installing now.” Continue by clicking the Installing Now link.<\/div>\nStep 6: Complete the Installation<\/h2>\n\n- When you navigate your correct WordPress URL in a browser, you will be prompted to select your preferred language. Choose your preferred language and then press the Continue button.<\/li>\n<\/ol>\n
![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/wordpress-wp-complete-manual-wordpress-install-preferred-language.png\")
<\/p>\n
\n- Once you are on the\u00a0Welcome<\/strong>\u00a0page, fill out the following fields under the Information needed section:\n
\n- Site Title:<\/strong>\u00a0This can be changed at any time.<\/li>\n
- Username:<\/strong>\u00a0This is the site’s admin username. We strongly advise against using ‘admin’ because it can pose a security risk.<\/li>\n
- Password:<\/strong>\u00a0A strong password will be generated for you automatically, but you can create your own. The password strength indicator will tell you how secure your password is.<\/li>\n
- Your Email:<\/strong>\u00a0Login information will be sent to this email address, so make sure it is one that you have access to.<\/li>\n
- Search Engine Visibility:<\/strong>\u00a0Leave this unchecked if you want your website to appear in search engine results. Check this box if you do not want your site to be indexed.<\/li>\n<\/ul>\n<\/li>\n
- Click the\u00a0Install WordPress<\/strong>\u00a0button, and you should be taken to a final screen that says, “WordPress has been installed; thank you, and enjoy!” It will show the username you selected on the previous page and a placeholder for your password.<\/li>\n
- That’s it; you can now\u00a0log in to your WordPress site.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
How To Install WordPress – WordPress Manual Installation Guide WordPress is one of the most popular tools for creating a…<\/p>\n","protected":false},"author":1,"featured_media":11415,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,2],"tags":[],"class_list":["post-957","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","category-cpanel"],"_links":{"self":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/comments?post=957"}],"version-history":[{"count":3,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/957\/revisions"}],"predecessor-version":[{"id":11417,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/posts\/957\/revisions\/11417"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media\/11415"}],"wp:attachment":[{"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/media?parent=957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/categories?post=957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webystrata.com\/blog\/wp-json\/wp\/v2\/tags?post=957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"How](\"https:\/\/www.webystrata.com\/blog\/wp-content\/uploads\/2024\/11\/ChatGPT-Image-Apr-13-2026-02_36_29-PM.png\" "\\"How")
<\/h1>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/cpanel-control-panel-databases-mysqldatabases.png\")
<\/li>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-create-new-database-name.png\")
<\/p>\n![\"\"](\"https:\/\/blog.trustedhosting.in\/wp-content\/uploads\/2024\/11\/mysqldatabases-created-click-go-back-button.png\")
<\/p>\n