DEV Community

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

6
Comments 2
13 min read
What is a Database Index? How It Works and When You Need It

What is a Database Index? How It Works and When You Need It

1
Comments
4 min read
MySQL Locks Explained: Preventing Deadlocks and Improving Performance

MySQL Locks Explained: Preventing Deadlocks and Improving Performance

Comments
6 min read
Encountered 'Permission denied' Error When Starting MySQL Container on Ubuntu 20.04.2 LTS

Encountered 'Permission denied' Error When Starting MySQL Container on Ubuntu 20.04.2 LTS

Comments
2 min read
Full-Text Search with MySQL

Full-Text Search with MySQL

1
Comments
2 min read
SQL for Generating Test Data in MySQL

SQL for Generating Test Data in MySQL

Comments
1 min read
No MySQL Driver After Installing PHP7

No MySQL Driver After Installing PHP7

Comments
1 min read
Creating a mysqldump Tool with Go

Creating a mysqldump Tool with Go

Comments
2 min read
MySQL 'MySQL Daemon failed to start' on Vagrant

MySQL 'MySQL Daemon failed to start' on Vagrant

Comments
1 min read
Fix: MySQL "Shutdown Unexpectedly" Error in XAMPP (Restore Your Databases)

Fix: MySQL "Shutdown Unexpectedly" Error in XAMPP (Restore Your Databases)

1
Comments
3 min read
Cannot Start MySQL 8.0.17 Container on M1 Mac

Cannot Start MySQL 8.0.17 Container on M1 Mac

Comments
1 min read
MySQL Too many connections: How I Debugged It and Scaled the Connection Pool

MySQL Too many connections: How I Debugged It and Scaled the Connection Pool

2
Comments
9 min read
MySQL JOIN vs UNION: Differences, Use Cases, and Examples

MySQL JOIN vs UNION: Differences, Use Cases, and Examples

1
Comments
3 min read
MySQL Transaction Isolation Levels: Preventing Dirty Reads, Phantom Reads, and More

MySQL Transaction Isolation Levels: Preventing Dirty Reads, Phantom Reads, and More

1
Comments
5 min read
Troubleshooting WordPress: "Error Establishing a Database Connection" on MySQL 8.4+ (macOS/MacPorts)

Troubleshooting WordPress: "Error Establishing a Database Connection" on MySQL 8.4+ (macOS/MacPorts)

1
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.