This is actually the base of MySQL command usage. By the help of a control panel we can simply create a database, create DB users, edit variables, set previeages etc. But in some situations it is necessary to manage these…
Database
How to access MySQL without knowing its password in a Plesk server
Here I am explaining how you can access MySQL without knowing its password in a Plesk server. # mysql -uadmin -p`cat /etc/psa/.psa.shadow` The above command is used to access MySQL without prompting for a password. In case, if you need…
Repository details for PerconaDB – CentOS 5, 6 & Redhat 5, 6
To download and install PerconaDB on your server instead of MySQL the server must have a repo file which has PerconaDB details. Do follow the steps below to create a repo for PerconaDB. Step 1 : Login to server via…
Repository details for MariaDB – CentOS 5, 6 & Redhat 5, 6
To install the MariyaDB on your server which has CentOS you must have a repository for MariyaDB. Do follow the steps below to create a repo for MariyaDB. CentOS Step 1 : Login to server via SSH as root. Step…
How to replace MySQL with PerconaDB on a cPanel server
Percona Server is an enhanced drop-in replacement for MySQL. Features of PerconaDB >> Your queries will run faster and more consistently. >> You will consolidate servers on powerful hardware. >> You will delay sharding, or avoid it entirely. >> You will…
How to replace MySQL with MariaDB on a cPanel server
MariaDB is an enhanced drop-in replacement for MySQL. MySQL 5.1 is compatible with MariaDB 5.1, 5.2 and 5.3. MySQL 5.5 is compatible with MariaDB 5.5. Features of MariaDB >> Data and table definition files (.frm) are binary compatible. >> All…
How to upgrade MySQL from 5.1 to 5.5 in a cPanel server – command line option
MySQL is an open source RDBMS (Relational Database Management System) and its using the SQL Language(Structured Query Language). A database is a structured collection of data. SQL is the most commonly using language for database operations. By using SQL the…