Skip to main content

MySQL DBA Support

Search This Blog

Password Reset in MySQL DB

Get link
Facebook
X
Pinterest
Email
Other Apps

Password Reset in MySQL DB

SET PASSWORD FOR 'username'@'%' = PASSWORD('Password');

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

MySQL DBA Interview Questions

MySQL DBA Interview Questions 1. MySQL Architecture & Internals (Advanced) Explain the internal architecture of InnoDB buffer pool, change buffer, double-write buffer, redo logs, undo logs, and adaptive hash index. What happens internally when you run this query? UPDATE users SET balance = balance + 100 WHERE id = 10 ; Explain the full journey of a transaction from BEGIN → COMMIT inside MySQL. How does the MySQL optimizer choose an execution plan? Why does MySQL sometimes prefer a full table scan even when an index exists? Explain InnoDB crash recovery phases in detail. Why is InnoDB redo logging physical and binlogging logical? Explain MVCC implementation in InnoDB (hidden transaction IDs, rollback pointers). What is the difference between persistent statistics and histograms ? What happens in memory and on disk when a page split occurs? 🟦 2. Advanced Storage Engine Concepts (Senior Level) Why does...

MySQL Lab Practice 1

MySQL Lab Practice 1 SECTION 1 — Server Startup, Crash, & OS‑Level Issues (20 Scenarios) MySQL fails to start with error: "InnoDB: Missing MLOG_CHECKPOINT" . Recover the instance. MySQL service crashes immediately after startup — identify the cause using error logs. MySQL refuses connections randomly every 5–7 minutes — find the root cause. Sudden spike in CPU due to mysqld — track down which thread/query is responsible. MySQL restarts repeatedly — identify infinite restart loop reason. Disk is full and MySQL stops writing — recover without losing transactions. MySQL fails with: “InnoDB: space id is mismatched” — fix tablespace mismatch. MySQL crash creates orphaned ibtmp1 — recover without deleting data. MySQL stuck at “Starting InnoDB instance” — resolve initialization hang. MySQL refuses to start after OS patching. MySQL server running but not accepting network connections — diagnose port binding issues. MySQL shows "Too many open files" — fix without downt...

Restore Single Mysql Database from full dump Backup

Restore Single Mysql Database from full dump Backup sed -n '/^-- Current Database: `rmisdb`/,/^-- Current Database: `/p' dbbackup_full_20260401.220001.sql > rmisdb_db.sql head dbbackup_full_20260401.220001.sql vi header.sql -- MariaDB dump 10.19 Distrib 10.6.8-MariaDB, for linux-systemd (x86_64) -- -- Host: localhost Database: -- ------------------------------------------------------ -- Server version 10.6.8-MariaDB-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VA...

Powered by Blogger