The following error occurs when using RDS MySQL when you attempt to kill a user session. MySQL> KILL 46552; > ERROR 1095 (HY000): You are
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
1227 – Access denied; you need SUPER or SYSTEM_VARIABLES_ADMIN
The following error occurs frequently when using RDS MySQL, especially when you attempt to modify global parameter settings. > 1227 – Access denied; you need
CREATE TABLE IF EXISTS in MySQL
In MySQL, it’s always advantageous to use the keyword IF NOT EXISTS when creating database objects like databases, tables, views, functions, and procedures. In this
You have new mail in /var/spool/mail/root
The notification “You have a new mail in /var/spool/mail/root” may occasionally appear in your EC2/Linux system after you execute a command. OR you could be
Is Flush Hosts deprecated?
Yes, as per MySQL documentation, using the command FLUSH HOSTS is deprecated. When FLUSH HOSTS is used, MySQL will clear the host cache, which effectively
Flush hosts using MySQL and MySQLAdmin
When you use FLUSH HOSTS, MySQL will effectively imply that its record of which hosts are currently or recently connected is reset, allowing you to
Big Data and SQL 