DEV Community

loading...

# mysql

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

👋 Sign in for the ability sort posts by top and latest.
HOW TO SLOW "(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

HOW TO SLOW "(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)"

Reactions 2 Comments
1 min read
Setting up your own High Availability managed WordPress hosting using Amazon RDS

Setting up your own High Availability managed WordPress hosting using Amazon RDS

Reactions 2 Comments
8 min read
SQL Or NOSQL: That is the question!

SQL Or NOSQL: That is the question!

Reactions 4 Comments
5 min read
How to add single quote in SQL query string

How to add single quote in SQL query string

Reactions 2 Comments
2 min read
Connect to MySQL

Connect to MySQL

Reactions 5 Comments
1 min read
Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Build Relational Databases Like A Pro (MySQL, PostgreSQL, etc.)

Reactions 66 Comments 9
3 min read
Big Data + MySQL = Mission InnoPossible?

Big Data + MySQL = Mission InnoPossible?

Reactions 3 Comments
9 min read
Use MySQL Window Functions to Get More out of Your Data

Use MySQL Window Functions to Get More out of Your Data

Reactions 5 Comments
11 min read
How to parse JSON data from server to Android

How to parse JSON data from server to Android

Reactions 2 Comments
4 min read
Search UTF8mb4 text of MySQL in PHP

Search UTF8mb4 text of MySQL in PHP

Reactions 2 Comments
1 min read
How To Check mysqldump character-set

How To Check mysqldump character-set

Reactions 2 Comments
1 min read
Cascade deleting in Prisma (v2)

Cascade deleting in Prisma (v2)

Reactions 2 Comments
2 min read
How i prevent SQL Injection in my PHP code

How i prevent SQL Injection in my PHP code

Reactions 7 Comments 2
3 min read
How To connect Laravel Application to MySQL Database.

How To connect Laravel Application to MySQL Database.

Reactions 15 Comments 3
2 min read
How to properly retrieve Laravel models between two dates

How to properly retrieve Laravel models between two dates

Reactions 20 Comments 1
4 min read
Migrating My Heroku-Based SaaS to Heroku Postgres

Migrating My Heroku-Based SaaS to Heroku Postgres

Reactions 2 Comments
6 min read
Can I use MySQL with Node.js?

Can I use MySQL with Node.js?

Reactions 2 Comments 1
4 min read
Figuring out a verification system via email link

Figuring out a verification system via email link

Reactions 7 Comments 1
4 min read
Blog with Go, Gin, MySQL and Docker - Part 2

Blog with Go, Gin, MySQL and Docker - Part 2

Reactions 11 Comments 1
9 min read
6 Easy steps for sharing AWS Encrypted RDS snapshot between two accounts.

6 Easy steps for sharing AWS Encrypted RDS snapshot between two accounts.

Reactions 2 Comments
3 min read
Multi-Tier Architecture on AWS EKS using Terraform

Multi-Tier Architecture on AWS EKS using Terraform

Reactions 2 Comments 2
2 min read
Laravel 8.x withExists Method to Eloquent Queries Example

Laravel 8.x withExists Method to Eloquent Queries Example

Reactions 6 Comments 4
1 min read
Popular string functions in MySQL - CONCAT and SUBSTRING

Popular string functions in MySQL - CONCAT and SUBSTRING

Reactions 3 Comments
2 min read
How Install WordPress with Docker

How Install WordPress with Docker

Reactions 21 Comments 3
1 min read
Sequelize and MySQL debugging quick tips

Sequelize and MySQL debugging quick tips

Reactions 6 Comments 3
4 min read
Blog Project with Go, Gin, MySQL and Docker - Part 1

Blog Project with Go, Gin, MySQL and Docker - Part 1

Reactions 19 Comments
8 min read
Add multiple columns after a column in Laravel Migrations

Add multiple columns after a column in Laravel Migrations

Reactions 2 Comments
1 min read
Collaborative Filtering in MySQL: A Tutorial

Collaborative Filtering in MySQL: A Tutorial

Reactions 6 Comments
5 min read
PlanetScale CLI Basics

PlanetScale CLI Basics

Reactions 9 Comments
5 min read
MySQL - Transaction Isolation Levels

MySQL - Transaction Isolation Levels

Reactions 2 Comments
1 min read
Launching WordPress With MySQL Database in K8S Cluster On AWS Using Ansible!

Launching WordPress With MySQL Database in K8S Cluster On AWS Using Ansible!

Reactions 3 Comments
2 min read
The database for developers is here

The database for developers is here

Reactions 18 Comments 4
1 min read
Designing a database with MySQL using the Command Line Interface — Part 1

Designing a database with MySQL using the Command Line Interface — Part 1

Reactions 5 Comments
10 min read
How to fetch the data from database

How to fetch the data from database

Reactions 1 Comments
1 min read
Why do database columns have a character length of 191?

Why do database columns have a character length of 191?

Reactions 23 Comments 2
5 min read
What's SQL, MySQL, MySQLi, PDO?

What's SQL, MySQL, MySQLi, PDO?

Reactions 4 Comments
1 min read
Understanding 'Cursor' in SQL

Understanding 'Cursor' in SQL

Reactions 2 Comments
1 min read
Database lock MySQL | MySQL Tutorial For Beginners

Database lock MySQL | MySQL Tutorial For Beginners

Reactions 2 Comments
1 min read
How to get the raw SQL query from the Laravel Query Builder

How to get the raw SQL query from the Laravel Query Builder

Reactions 2 Comments
2 min read
Spring Boot, Hibernate, MySQL example: CRUD app

Spring Boot, Hibernate, MySQL example: CRUD app

Reactions 18 Comments
4 min read
#LaravelWiki

#LaravelWiki

Reactions 3 Comments
1 min read
Laravel Tinker - SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: No address associated with hostname

Laravel Tinker - SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: No address associated with hostname

Reactions 1 Comments
2 min read
Building a GraphQL to SQL Compiler on Postgres, MS SQL and MySQL

Building a GraphQL to SQL Compiler on Postgres, MS SQL and MySQL

Reactions 6 Comments
11 min read
Why did my Java Web App stop working with MySQL!?!

Why did my Java Web App stop working with MySQL!?!

Reactions 6 Comments 3
3 min read
MariaDB: Update database charset / collation

MariaDB: Update database charset / collation

Reactions 6 Comments
1 min read
How to make the most out of #100DaysOfCode

How to make the most out of #100DaysOfCode

Reactions 7 Comments
3 min read
A Note On Relational Databases

A Note On Relational Databases

Reactions 5 Comments 1
5 min read
Popular string functions in MySQL - Replace and Reverse

Popular string functions in MySQL - Replace and Reverse

Reactions 4 Comments
1 min read
Debugging Chronicles: Serverless offline + Sequelize

Debugging Chronicles: Serverless offline + Sequelize

Reactions 1 Comments
5 min read
ການເຮັດ Automated mysql backup ຢ່າງງ່າຍ!

ການເຮັດ Automated mysql backup ຢ່າງງ່າຍ!

Reactions 3 Comments
2 min read
SQL Review - Useful queries for mySQL

SQL Review - Useful queries for mySQL

Reactions 7 Comments
1 min read
Deploying your Laravel + MySQL application on Heroku

Deploying your Laravel + MySQL application on Heroku

Reactions 18 Comments 2
7 min read
Build REST API with Laravel

Build REST API with Laravel

Reactions 2 Comments
1 min read
What is Stored Procedure in SQL

What is Stored Procedure in SQL

Reactions 6 Comments
1 min read
Building Web Applications using Beego + Mysql+ORM

Building Web Applications using Beego + Mysql+ORM

Reactions 5 Comments
3 min read
Installing MySQL on MacOS

Installing MySQL on MacOS

Reactions 3 Comments
2 min read
How to Run Sequelize Migrations in Azure Pipelines

How to Run Sequelize Migrations in Azure Pipelines

Reactions 2 Comments
6 min read
What is ACID? Baby don't hurt me. No more.

What is ACID? Baby don't hurt me. No more.

Reactions 8 Comments 1
4 min read
The untold truth I learned about frameworks

The untold truth I learned about frameworks

Reactions 20 Comments 4
9 min read
FastAPI project template (jWT, MariaDB)

FastAPI project template (jWT, MariaDB)

Reactions 5 Comments
1 min read
loading...
Forem Open with the Forem app