Thursday, 26 October 2017

Solved ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

›
A error occured when run `mysql` from the terminal to connect to a server. Add `--skip-secure-auth` to the end of the statement mysql -u...
Friday, 20 October 2017

mysql flush commands

›
List of all mysqladmin flush commands. flush-hosts: Flush all information in the host cache. flush-privileges: Reload the grant tables ...
Thursday, 11 May 2017

Mysql dba tips and tricks: ERROR 1044 (42000): Access denied for user Restor...

›
Mysql dba tips and tricks: ERROR 1044 (42000): Access denied for user Restor... : Access denied for user 'root'@'%' I am ...

ERROR 1044 (42000): Access denied for user Restore the MySQL root user’s full privileges?

›
Access denied for user 'root'@'%' I am able to login fine :  mysql -u root -p mysql>  GRANT SELECT, LOCK TABLES,EXE...
Sunday, 9 April 2017

How to understand the MySQL Slow Query Log

›
How to understand the MySQL Slow Query Log root@server#tail -f /var/log/mysql_slow_query.log # Time: 2017-04-09T20:10:09.472872Z # User...
Monday, 16 January 2017

Counting the number of sleeping connections

›
INFORMATION_SCHEMA, For instance, counting the number of sleeping connections can be done with: mysql> SELECT COMMAND,COUNT(*) TOTAL F...
Wednesday, 11 January 2017

Set up and verify automated MySQL backup in 15 minutes

›
The Solution: Zmanda Recovery Manager for MySQL Zmanda Recovery Manager for MySQL (ZRM for MySQL) simplifies this essential part of datab...
Monday, 2 January 2017

Important Commandline Tools to Monitor MySQL Performance in Linux

›
Tools to monitor MySQL performance and troubleshoot a server Mytop Mytop is open source and free console-based (non-gui) monitoring t...
Tuesday, 20 December 2016

Back Up and Restore a MySQL Database

›
You can backup your MySQL data by using the mysqldump command. This command connects to the MySQL server and creates an SQL dump file $ m...
Tuesday, 13 December 2016

Grant on mysql 5.7

›
 Administrative privileges enable users to manage operation of the MySQL server.Privileges for database objects such as tables, indexes, vi...