Web Hosting

[How-To Guide] Create New User In MySQL Database

MySQL, most popular database which allows you to run content-driven websites. MySQL database managed by using third-party programs such as PHPMyAdmin because it offers you a quick and easy database administration process. Already I had provided you lots of guides on MYSQL Database from installation to some advanced level. Here is a quick round-up of all the posts.

Install MySQL Offline On Your PC

Configure MySQL Offline On Your PC

Checking MySQL Installation Works On PC or Not?

Repair And Optimize WordPress Database Using WordPress Hidden Feature

Optimize WordPress Database Using PHPMyAdmin

Repair WordPress Database Using PHPMyAdmin

Top WordPress Plugin To Optimize WordPress Database

All these posts help you out in getting friendlier with MYSQL database. This post focus on creating a new user in MySQL. Follow the step-by-step guide to create user.

Step1: Open your cPanel, under it click on MySQL Database option as shown below:

Step2: After clicking on MySQL database, it will open a new page. Now scroll down and you see the “MySQL Users” as shown below in screen-shot:

Step3: After clicking on “Create User” button a new user-created and it looks like this:

Step4: The new database user will be “cpanelusernmae_admin” (admin is the username of that database you’ve created).

Step5: Now click on “Add” button to “Add User to Database” as shown below:

Step6: Now select the privileges you assign to this user and after assigning privileges click on “Make Changes” button.

Step7: Congratulations, you have successfully added new user to database.

This tutorial guides you in creating more users to your database.

If you face any problems then let us know in the comments section. To get all the latest information you can follow us on Twitter

[How-To Guide] Repair WordPress Database Using PHPMyAdmin

Already, in earlier articles I had provided you a step-by-step guide on Repairing and Optimizing your WordPress driven website without using any plugin and Optimizing WordPress Database using PHPMyAdmin. Continuing on same series of posts, this post focus on Repairing WordPress Database using PHPMyAdmin.

Step1: Login to your WordPress Database using PHPMyAdmin.

Step2: Now select the database which you want to repair. Click on “Check tables having overhead” option to select the right tables.

Step3: From drop down menu, select the menu item which says “Repair table”, this will repair the table.

Step4: After selecting “Repair table” option, this will repair the database and will be look like this:

PHPMyAdmin is the easiest way to repair the database tables without adding plugin load to your WordPress site.

Note: Before applying this tutorial back-up your database and never click on options like Drop, Empty because they will ruin your database and create problem so be careful.

Finally in the end do let us know in the comments section, if you faced any problem?

[How-To Guide] Optimize WordPress Database Using PHPMyAdmin

Already I had provided you a step-by-step guide on repairing and optimizing your WordPress driven website without using any plugin. This article focus on optimizing WordPress Database by using PHPMyAdmin.

PHPMyAdmin, free software tool written in PHP and made to handle administration MYSQL over world-wide web.

Step1: Login to your WordPress Database using PHPMyAdmin

Step2: Select the right database, if there is only one database then it would be chosen by default.

Step3: Now click on “check tables having overhead” option and select the proper table as shown below:

Step4: From drop down menu (as indicated above in screen-shot), select the menu item which says “Optimize table”. This will optimize the tables which is shown below:

PHPMyAdmin is the easiest way to optimize the overheads of your database without adding plugin load to your WordPress site.

Note: Before applying this tutorial back-up your database and never click on options like Drop, Empty because they will ruin your database and creates a problem so be careful.

Finally in the end do let us know in the comments section, if you faced any problem?

[How-TO Guide] Checking MySQL Installation Works On PC Or Not?

Already in earlier articles I have provided you a step-by-step guide on installing and configuring MySQL offline on your PC. Now in this article I provide you a step-by-step guide on checking MySQL Installation whether it works correctly on your PC or not. The easiest way to check out MySQL Installation and confirm that it’s working properly is to use the MySQL Command Line Client.

Step1: Click on “Start Menu” and select “All Programs”.

Step2: Now click on “MySQL” and select “MySQL Server 5.1”

Step2: Now enter the MySQL password

Step3: The MySQL client displays the mysql> prompt on successful login.

Step4: Now run simple SQL command for example: Run “show databases;” and hit enter key on your keyboard. This simple command instructs MySQL to display the names of installed databases and they are 3.

Congratulations, you have successfully install MySQL and it is working correctly on your PC.

Do let us know in the comments section if you face any error while checking out your MySQL installation works correctly or not on your PC?

[How-to Guide] Configuring MySQL Offline On Your PC

Already in earlier article I had provided you a step-by-step guide on installing MySQL Offline on your PC. Now in this article I guide on configuring MySQL on your PC because without configuring it you can’t use it on your PC.

Follow the step-by-step guide to configure MySQL on PC.

Step1: Click on “Next” button to get started.

Step2: After clicking on “Next” button, you’ve to select “Detailed configuration” and click on “Next” button.

Step3: Now select “Developer Machine” and click on “Next” button

Step4: After clicking on “Next” button you’ve to choose Database, select “Multifunctional Database” as u don’t know what you’re doing and click on “Next” button.

Step5: Now don’t mess up the things and simply click on “Next” Button

Step6: Now select “Decision Support” and click on “Next” Button

Step7: Now select “Enable Strict Mode” for networking options and click on “Next” button.

Step8: Click on “Include Bin Directory In Windows Path” option and “Next” button to go ahead.

Step9: Now set the “Password” and click on “Next” button.

Step10: Now click on “Execute” button to execute the things.

Step11: Hit down the “Finish” button. Congratulations, you have successfully configured MySQL Offline on your PC.

You have successfully configured MySQL on your PC. Wait for next article which guides you to check out the MySQL installation works properly or not on your PC.

Do let us know in the comments section if you face any problem in configuring MySQL on your PC?