• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar

A cPanel Tech

The Diaries of a Linux Server Administrator

  • Home
  • About
  • Privacy
You are here: Home / Archives for MySQL

MySQL

MySQL vs MariaDB

March 20, 2017 By admin Leave a Comment

MySQL vs MariaDB: MariaDB is a drop-in replacement for MySQL. That means that all data and table definition files are all compatible with MariaDB. All filenames, binaries, paths, ports, sockets – should remain the same, all MySQL connectors are compatible with MariaDB (PHP, Perl, Python, Java…) … [Read more...] about MySQL vs MariaDB

Filed Under: Articles, MySQL Tagged With: mariadb

How to Uninstall MariaDB in a cPanel server

November 26, 2015 By admin 2 Comments

Uninstalling MariaDB is as easy as installing MariaDB. If you ever want to uninstall and roll back to stock MySQL, continue reading for a step-by-step guide to uninstall MariaDB.Here are the steps to Uninstall MariaDB and return to stock MySQL. … [Read more...] about How to Uninstall MariaDB in a cPanel server

Filed Under: Articles, cPanel, MySQL, Tutorials Tagged With: cpanel, mariadb

How to Setup WordPress Hosting server using nginx

September 25, 2015 By admin 3 Comments

This is how I set up a WordPress hosting for my clients. And believe me, I have got a page load time of less than one second, and when set up in a $10 digital ocean server, it could handle ~200 concurrent users. … [Read more...] about How to Setup WordPress Hosting server using nginx

Filed Under: Linux, MySQL, Tutorials, wordpress Tagged With: mariadb, nginx, wordpress

Setting Up A Remote MySQL Server in your cPanel server

August 6, 2013 By admin Leave a Comment

Recent versions of cPanel allow administrators the option of hosting a MySQL server on a separate box, which can help decrease resource usage from high-activity MySQL databases. Setting up the remote database server is easy: … [Read more...] about Setting Up A Remote MySQL Server in your cPanel server

Filed Under: MySQL, Tutorials Tagged With: cpanel, mysql, phpmyadmin, remote database server, remote mysql, whm

How to Upgrade MySQL Manually on a cPanel Server

May 16, 2013 By admin Leave a Comment

Keeping MySQL on the server up to date is essential for the efficiency  of codes . There are times when we just cannot let cPanel handle an upgrade because we may end up having our databases not working properly  after an upgrade. So, therefore we need to do upgrades of MySQL manually. … [Read more...] about How to Upgrade MySQL Manually on a cPanel Server

Filed Under: MySQL, Tutorials Tagged With: cpanel, mysql, mysql upgrade, mysqldump, php

Primary Sidebar

Copyright 2018 CPanelTech