Step 1: Go to C:\xampp\mysql. Make sure you are in the correct file location. Step 2:  Backup the data folder by making a copy of the folder Step 3: Extract the "mysql" folder from C:\xampp\mysql\backup. Step 4: Replace the mysql folder inside C:\xampp\mysql\data\ Step 5: Restart MySQL service from XAMPP

Configuration file in phpmyadmin will require a blowfish_secret to be set. Ensure to check if the below line is has the needed value. (more…)

For example, you may have table with varchar, text or longtext fields and you may see garbled data in it. Though the text appears correctly on web pages, inside MySQL junk characters may appear. CREATE TABLE `my_news` ( `nid` bigint(10) NOT NULL DEFAULT '0', `title` text, `short_news` longtext) ENGINE=MyISAM DEFAULT CHARSET=utf8; In order to correct this error, try to alter the table in the following sequence. (more…)

Step 1: Identify the user id for which you want to change the password Step 2: Issue the below MySQL command to update the password for the selected user update wpgi_users set user_pass=MD5('yourpasswordgoeshere') where wpgi_users.id=1

When trying to import large SQL dump, you often get the above message. Remedy for this issue is to increase the packet size of MySQL's daemon by setting a packet size of max_allowed_packet. Sudo to your account and set the following root $ mysql -u admin -p mysql> set global net_buffer_length=1000000; mysql> set global max_allowed_packet=1000000000; In the command line, issue the command $ mysql --max_allowed_packet=128M -uUSER -pPASSWORD database < database.sql.dump

After VPS reboot, you may encounter this issue and the fix is simple. Follow these stops to prevent this error. $ service mysqld stop $ mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak $ service mysqld start