How to Reset MySQL Root Password

Setting, Changing And Resetting MySQL Root Passwords   mysql admin Command To Change Root Password Method 1 – Set up root password for the first time If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To set up a root password

What is the RAW-Protocol ?

Any IP protocol other than TCP or UDP is known as a RAW protocol. Raw protocol are used to generate/receive packets of a type that the kernel doesn’t explicitly support. An easy example that you’re probably familiar with is PING. Ping works by sending out an ICMP (internet control message protocol – another IP protocol

What is an API Gateway?

In a simple way a gateway is a filter somewhere in your web stack (hosted by you or a third party) which filter,manage,secure,translate,transform,monitor and log your API traffic in someway. Some of the possible filtration could happen are:   Access Control (filtering traffic so only authenticated/authorized traffic gets through) Rate Limiting (restricting how much traffic

MySQL ibdata File Size Limit

Usually MySQL database size is limited by underlying operating system, not by MySQL internal limit. (In Linux 2.4+, ext3 file system can support up to 4TB) In the beginning, MySQL sets the initial size of InnoDB data file. After the data reaches the limit, there are two options: 1. Stop to write data 2. Write

RedHat Root Account History

The best Practice to check login history with most detail is checking secure file under this directory #cd /var/log/ with the help of command # cat /var/log/secure #last is another command for the system admin tool box, it displays the login history of all or any specific user. Yo do not need to be root

Why is the ibdata1 file continuously growing in MySQL?

What is stored in ibdata1? The file ibdata1 is the system tablespace for the InnoDB infrastructure. It contains several classes for information vital for InnoDB Table Data Pages Table Index Pages Data Dictionary MVCC Control Data Undo Space Rollback Segments Double Write Buffer (Pages Written in the Background to avoid OS caching) Insert Buffer (Changes

How TCP backlog works in Linux

When an application puts a socket into LISTEN state using the listen syscall, it needs to specify a backlog for that socket. The backlog is usually described as the limit for the queue of incoming connections.     Because of the 3-way handshake used by TCP, an incoming connection goes through an intermediate state SYN

Linux ss command to monitor network connections

The ss command is capable of showing more information than the netstat and is faster. The netstat command reads various /proc files to gather information. However this approach falls weak when there are lots of connections to display. This makes it slower. The ss command gets its information directly from kernel space. The options used

How to disable SNMP v1 and v2c leaving SNMPv3 enabled?

What is SNMP? Simple Network Management Protocol (SNMP) is a popular protocol for network management. It is used for collecting information from, and configuring, network devices, such as servers, printers, hubs, switches, and routers on an Internet Protocol (IP) network. Microsoft Windows Server 2003 provides SNMP agent software that works with third-party SNMP management software to monitor