Activities

September 2020
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
282930  

MySQL 5.5 : How do I enable slow query log

Prior to optimize the performance of a busy MySQL Database server, I need to enable all the queries those consume more than 10 second to complete the execution. This server load is high most of the time and being hit on performance issue due to this load.

I’m using the server which have 32 CPU’s […]

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol

While I’m accessing MySQL server 5.5 remotely from a windows server which was MySQL 5.6 libraries installed, I got the following errors.

C:\Documents and Settings\Administrator>mysql -h 192.168.10.24 -ureadusr -p Enter password: ************ ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option ‘secure_auth’ enabled)

How do I skip this error and able […]

PHP 5.5 : MySQL error – The server requested authentication method unknown to the client

Recently I had to upgrade the php version to 5.5 on one of the servers for the enhancement. All the php hosted sites showing database errors after the switching to new PHP version. The error is shown below,

Could not connect: The server requested authentication method unknown to the client. So I had to revert […]

Mysql dump warning : Using unique option prefix pass instead of password is deprecated

While you taking backup of Mysql version 5.5 , you would have get the following error

 [root@host1-merriman scripts]# /bin/sh  /home/installation/scripts/db_backup.sh Warning: Using unique option prefix pass instead of password is deprecated and will be removed in a future release. Please use the full name instead.

Solution:

Open my.cnf file from the user profile folder ( […]

Amazon RDS : Trigger Error – You might want to use the less safe log_bin_trust_function_creators variable

While I’m trying to execute triggers to a RDS Mysql database I got the following errors

ERROR 1419 (HY000) at line #: You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable).

I’m using the SUPER root account which will create at […]

Warning: Skipping the data of table mysql.event.

You may get this warning when you take full MySQL server backup on above MySQL 5.2 GA version.This warnings cab be ignored since it is related to MySQL new feature “Event Scheduler”.

Solution : You may simply add parameter “–ignore-table=mysql.event” along with MySQL Dump command.

Eg:

 mysqldump –all-databases -r alldb.sql –ignore-table=mysql.event

Or you may add […]