First we need to add Percona yum repo. This can be done by installing rpm provided by Percona. To see all available Percona Server versions, use yum search To install Percona Server 5.6 (latest version), run After installing, run This
After trying to install one of the classified script, i tried to login to admin area with default login details. But it showing ‘Invalid username/password. Login failed’ So I went into cPanel and opened phpmyadmin to reset the password and
Following tutorial describes how to install Apache MySQL and PHP on a Cent OS based server. First we need to identify the version of OS using on the server. For that, login to the server as root user and run
In my last post, i shared my experience with installing MYSQL in windows 7. During the installation I set ‘root’ as MYSQL password. Now I want to change the same to ‘hostonnet’ I followed the instructions at MYSQL Documentation http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Well today I tried to install MySQL on my computer (Windows 7 Ultimate,32 bit operating system.) by using the below instructions. 1. Download the MSI Installer from http://dev.mysql.com/downloads/windows/installer/5.6.html 2 . Run the MySQL installer executable file that you had downloaded.
We can deactivate a plugin through WP Admin Dashboard. What we can do if we can’t accessing the admin area ? Yes, The following situations may block you out from accessing the dashboard 1). Will show a blank page after
To speed up query, enable the MySQL query cache, before that you need to set few variables in mysql configuration file ( my.cnf or my.ini) The first you make sure that your installation of MySQL actually has query caching support
InnoDB is a MySQL engine which stores all of the data for it’s tables within the ibdata files located at /var/lib/mysql on the server. Unfortunately, data can be corrupted within these files and recovery methods must be taken to restore
How to check your tables 1, Log into your cPanel Control panel 2, Click the phpMyAdmin icon 3, Choose the database you are working with by clicking on it in the left menu 4, On the right side of the
1, Open phpMyAdmin. 2, Select your database by clicking the database name in the list on the left of the screen. 3, Click the “Export” link. This should bring up a new screen that says View dump of database 4,