Category: MySQL
Steps to delete multiple tables in the database using phpMyAdmin
This article will explain you the steps to delete multiple tables in the database using phpMyAdmin. For these follow the steps as…
Direct link/URL to access phpMyAdmin without installing software
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…
How To Check a MySQL Database for Errors in cPanel
In this tutorial you will understand how to check MySQL Database for errors. Let’s see the steps as follow: Step 1: Log…
How to Run SQL Queries in phpMyAdmin
In this tutorial will demonastrate on how you can run SQL Queries in phpMyAdmin. Step 1: Go to cPanel > Software >phpMyAdmin.…
How to use MySQLTuner ?
Using the MySQLTuner helps you review a MySQL installation quickly and being considered is a script it has more effective way to…
Why & How to Optimise & Repair MySQL Database using phpMyAdmin in cPanel
In this article will understand the way to optimize and repair MySQL Database using phpMyAdmin in cPanel. Why Optimise and Repair MySQL…
How to Fix Error Forcing close of thread 310 user: ‘root’ in MySQL?
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…
How To Search Through A Database In phpMyAdmin?
There are some attributes hooked up to the search feature of phpMyAdmin. Let’s see how you can search through a database in…
How can I add procedures and triggers to my MySQL database?
From their Java applications, as more and more clients want to use advanced SQL features, we are running MySQL version 5.1.x or…
I would like to dump the Table Structure for my MySQL Database, but none of the data.
The command line option from SSH is given as below: mysql -d -p database_name > file.sql. Where ‘database_name’ is the name of…