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...
Friday, 7 October 2016

mysql table is marked as crashed repair failed

›
mysql> repair table my_table; +------------------------------+--------+----------+-----------------------------------------------------...
Wednesday, 5 October 2016

Solved (without restart) Mysql slow query log is on but not logging anything

›
1.First cross check /etc/my.cnf to make it permanent slow_query_log = 1 slow_query_log_file = /var/log/mysql_slow_query.log 2.Permiss...