Database Administration
Reset the MySQL root Password From the Terminal
Reset the MySQL root password from the terminal when you are locked out, using skip-grant-tables recovery mode and ALTER USER to set a new…
//
Category: Database Administration
Database Administration
Create an Index and Read EXPLAIN in MySQL
Create an index in MySQL and use EXPLAIN to prove it worked, turning a 5,000-row full table scan into a targeted lookup of just…
Database Administration
Add a Foreign Key in MySQL
Add a foreign key in MySQL to link two tables and have the database enforce it, rejecting orphan rows while an ON DELETE CASCADE…
Database Administration
Create a MySQL Table From the Terminal
Create a MySQL table from the terminal with a single CREATE TABLE statement: typed columns, an AUTO_INCREMENT primary key, and sensible defaults, confirmed with…
Database Administration
Join Tables in MySQL
Join tables in MySQL to combine related rows in a single query. Learn INNER JOIN for matches, LEFT JOIN to keep unmatched rows, table…
Database Administration
Restore MySQL backup from the terminal
Efficiently import MySql backup database records from an .sql file using the mysql command from the terminal. A quick and direct approach to restore…