Category Archives:
MySQL Archives - OWS KB

This article will explain you the steps to delete multiple tables in the database using phpMyAdmin. For these follow the steps as below: Step 1: Login to cPanel account. Step 2: Under Databases select Mysql Databases. Step 3: The phpMyAdmin page will get appear infornt of you. Step 4: Select the databases from the list […]

The cPanel account that is hosted under shared server, try using the below URL to directly access phpMyadmin. http://www.yourdomainname.com:2083/3rdparty/phpMyAdmin/index.php Make sure you substitute yourdomainname.com together with your actual name. To enter your login credentials, you will be get prompted . you’ll login to phpMyAdmin with constant credentials you employ for cPanel. Once entered it ought […]

In this tutorial you will understand how to check MySQL Database for errors. Let’s see the steps as follow: Step 1: Log in to cPanel. Step 2: Click the “MySQL Databases” icon. Step 3: Under “Modify Databases”, and in the “Check Database” drop down box, select the database you want to check. b After that, […]

In this tutorial will demonastrate on how you can run SQL Queries in phpMyAdmin. Step 1: Go to cPanel > Software >phpMyAdmin. Step 2: Navigate to the area your SQL query will apply to. Select the database or the tables you want run the queries against. Step 3: Click on the SQL tab. Step 4: Type in […]

Using the MySQLTuner helps you review a MySQL installation quickly and being considered is a script it has more effective way to improve its performance and achieve stability. Note : Before you run the MySQLTuner script you’d need to be logged in as root user. Let’s see the steps to use MySQLTuner ? Step 1 […]

Problem Statement MySQL server keeps on shutting down. Error Message C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Forcing close of thread 310 user: ‘root’ Solution You can resolve this issue by increasing maximum connection to MySQL server. Firstly you have Login to MySQL server and navigate to /etc/my.cnf file. Find & increase max_connections value and save the my.conf file. Restart MySQL […]

There are some attributes hooked up to the search feature of phpMyAdmin. Let’s see how you can search through a database in phpMyAdmin. Following ate the steps: Login to cPanel and go to phpMyAdmin. Click on the database that you simply wish to look here. Click on the ‘Search’ tab. You can enter the words […]

From their Java applications, as more and more clients want to use advanced SQL features, we are running MySQL version 5.1.x or higher where user can run CREATE PROCEDURE and CREATE TRIGGER statements. Just ensure when assigning database user to a database, you should check ROUTINE and TRIGGER related privileges or ALL privileges . for […]

The command line option from SSH is given as below: mysql -d -p database_name > file.sql. Where ‘database_name’ is the name of your database, and ‘file.sql’ is the name of the file you would like to write the table structure to. You will be prompted you for a password (-p). Normally mysqldump gives you the entire […]