Mysql learning in terminal (WP Site was intended)

This is some basic, Here’s a practical MySQL cheat sheet tailored for setting up a WordPress database from scratch via terminal, covering login → database → user → privileges → DDL → DML → common operations.

🐬 MySQL Cheat Sheet (WordPress Setup + Core Commands)

🔐 1. After Logging Into MySQL


mysql -u root -p

Check current user:


SELECT USER();

Show databases:


SHOW DATABASES;

🏗️ 2. Create WordPress Database


CREATE DATABASE wordpress_db

CHARACTER SET utf8mb4

COLLATE utf8mb4_unicode_ci;

Use it:


USE wordpress_db;

👤 3. Create MySQL User for WordPress


CREATE USER 'wp_user'@'localhost' IDENTIFIED BY 'strong_password';

Grant privileges:


GRANT ALL PRIVILEGES ON wordpress_db.* TO 'wp_user'@'localhost';

Apply changes:


FLUSH PRIVILEGES;

Check grants:


SHOW GRANTS FOR 'wp_user'@'localhost';

🗑️ 4. Delete Database / User (if needed)


DROP DATABASE wordpress_db;

DROP USER 'wp_user'@'localhost';

📐 DDL (Data Definition Language)

Create Table


CREATE TABLE users (

    id INT AUTO_INCREMENT PRIMARY KEY,

    username VARCHAR(50) NOT NULL,

    email VARCHAR(100),

    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

Show Tables


SHOW TABLES;

Describe Table


DESCRIBE users;

Alter Table

Add column:


ALTER TABLE users ADD password VARCHAR(255);

Modify column:


ALTER TABLE users MODIFY username VARCHAR(100);

Rename column:


ALTER TABLE users CHANGE username user_name VARCHAR(100);

Drop column:


ALTER TABLE users DROP email;

Rename table:


RENAME TABLE users TO wp_users;

Drop Table


DROP TABLE wp_users;

✍️ DML (Data Manipulation Language)

Insert Data


INSERT INTO users (username, email)

VALUES ('john', 'john@example.com');

Insert multiple:


INSERT INTO users (username, email)

VALUES 

('alice', 'alice@example.com'),

('bob', 'bob@example.com');

Read Data (SELECT)

Basic:


SELECT * FROM users;

Specific columns:


SELECT username, email FROM users;

With condition:


SELECT * FROM users WHERE id = 1;

With AND / OR:


SELECT * FROM users WHERE username='john' AND id=1;

Sort:


SELECT * FROM users ORDER BY id DESC;

Limit:


SELECT * FROM users LIMIT 5;

Update Data


UPDATE users

SET email = 'new@email.com'

WHERE id = 1;

⚠️ Always use WHERE unless updating all rows.

Delete Data


DELETE FROM users WHERE id = 1;

Delete all rows:


DELETE FROM users;

🔎 Useful Query Features

LIKE (pattern search)


SELECT * FROM users WHERE username LIKE 'j%';

COUNT


SELECT COUNT(*) FROM users;

DISTINCT


SELECT DISTINCT username FROM users;

🔗 Indexes

Create index:


CREATE INDEX idx_username ON users(username);

Drop index:


DROP INDEX idx_username ON users;

🔒 Transactions


START TRANSACTION;



UPDATE users SET username='test' WHERE id=1;



COMMIT;

-- OR

ROLLBACK;

⚙️ WordPress-Specific Notes

  • WordPress will auto-create tables like:

  • wp_users

  • wp_posts

  • wp_options

  • You only need:

  • DB name

  • DB user

  • Password

Used in wp-config.php:


define('DB_NAME', 'wordpress_db');

define('DB_USER', 'wp_user');

define('DB_PASSWORD', 'strong_password');

define('DB_HOST', 'localhost');

🚀 Quick Setup Summary (Minimal Commands)


CREATE DATABASE wordpress_db

CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;



CREATE USER 'wp_user'@'localhost' IDENTIFIED BY 'password';



GRANT ALL PRIVILEGES ON wordpress_db.* TO 'wp_user'@'localhost';



FLUSH PRIVILEGES;

🧠 Pro Tips

  • Always use utf8mb4 → supports emojis & full Unicode

  • Use strong passwords for DB users

  • Backup before destructive commands:


mysqldump -u root -p wordpress_db > backup.sql

If you want, I can also give you:

  • a WordPress-specific table cheat sheet

  • or common debugging commands (connection errors, permissions issues, etc.)

sample markdown.

Second Heading

  • Unordered lists, and:
    1. One
    2. Two
    3. Three
  • More

Blockquote

And bold, italics, and even italics and later bold. Even strikethrough. A link to somewhere.

And code highlighting:

var foo = 'bar';

function baz(s) {
   return foo + ':' + s;
}

Or inline code like var foo = 'bar';.

Or an image of bears

bears

The end ...

Comments

Post a Comment

Popular posts from this blog

Terminal-Based Writing

Terminal-Based Writing: From Termux to Professional Docs (A Beginner’s Guide to WordGrinder + Pandoc) Do you love writing in the terminal but need professional-looking PDFs or Word files? This guide will show you how to: Write in Termux using wordgrinder (a simple terminal word processor). Convert to Markdown for flexibility. Generate beautiful PDFs/DOCX files using pandoc . No complex setups—just clear, step-by-step instructions. Let’s begin! Step 1: Install Termux & Tools (Skip if you already have Termux!) Install Termux (Android terminal emulator). Update packages: pkg update && pkg upgrade Install WordGrinder (terminal word processor) and Pandoc (document converter): pkg install wordgrinder pandoc Step 2: Write in WordGrinder WordGrinder is a lightweight word processor with bold, italics, and underlines . Basic Commands Open a new file: wordgrinder my_note.zws Shortcuts: Ctrl+S → Save Ctrl+B → Bold Ctrl+I → Italics...
Read more

Markdown Quick Tutorial

Markdown Quick Tutorial: The Essentials in 5 Minutes Markdown is a lightweight markup language for formatting plain text. It’s perfect for notes, docs, and even websites (like GitHub READMEs). Here’s all you need to know: 1. Basic Formatting Style Markdown Output Bold **bold** bold Italic *italic* italic Strikethrough ~~strike~~ strike Code `code` code Link [text](URL) Google Image ![alt](image.png) (Shows image) 2. Headings # Heading 1 (Biggest) ## Heading 2 ### Heading 3 #### Heading 4 3. Lists Bullet Points - Item 1 - Item 2 - Sub-item (indent with 2 spaces) Numbered Lists 1. First 2. Second 3. Third 4. Code Blocks Inline Code Use `print("Hello")` in Python. Multi-line Code Use triple backticks + language name: ```python def hello(): print("World") ``` (Shows with syntax highlighting!) 5. Tables | Name | Age | Job | |---------|-----|----------| | Alice | 25 | Engineer | | Bob | 30...
Read more

To install Jupyter Notebook on Ubuntu (Linux)

To install Jupyter Notebook on Ubuntu 24, follow these steps: Update the system : sudo apt update && sudo apt upgrade -y Install Python and pip (Ubuntu 24 typically comes with Python pre-installed): sudo apt install python3 python3-pip -y Install Jupyter Notebook : pip3 install jupyter Verify the installation : jupyter notebook --version Launch Jupyter Notebook : jupyter notebook This will start the Jupyter server and open a browser window. If it doesn’t, navigate to http://localhost:8888 in your browser. Optional: Install in a virtual environment (recommended to avoid package conflicts): Install virtualenv: sudo apt install python3-venv -y Create and activate a virtual environment: python3 -m venv jupyter_env source jupyter_env/bin/activate Install Jupyter Notebook inside the virtual environment: pip install jupyter Run Jupyter Notebook as above. Notes : Ensure you have an active internet connection. If you encounter permission issues with pi...
Read more