Tags » Mysql


Databases are usually the lifeblood of applications and of dynamic web sites.
They manage the information that applications depend on, and a large portion of… 1,631 more words

Ruby On Rails

Password Validation Plugin

The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords.

Enable password validation plugin

The validate_password.so plugin should be available in the MySQL plugin directory. 251 more words


Dockerize Microservice (SpringBoot RESTful Application with Mysql)

Statement : With the help of Docker, one can easily create, deploy and run their applications. So in this article, we’ll learn how one can deploy their Microserives (Spring Boot Application connected with Mysql Backend) to Docker Container. 519 more words


Hidden Gems: Event-Driven Change Notifications in Relational Databases


Wouldn’t it be great if we could receive event-driven change notifications (EDCN) when data changes directly from the database without having to poll for updates? 3,189 more words

Software Engineering

Configuring MySQL 8 instance on CentOS 7 in OCI

As root, execute the below commands to have a MySQL 8 instance running

rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
sed -i 's/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo
yum --enablerepo=mysql80-community install -y mysql-community-server
systemctl start mysqld
grep "A temporary password" /var/log/mysqld.log
… 91 more words

ERROR 2002 (HY000): Can't connect to local MySQL server

Yeah. Very cryptic. I got it when mysql -u root -p. Of course I’m expecting mysql server to be running when I run the command. 287 more words


The curious case of dead-end-lock(Deadlock) | Mysql

Usually, deadlocks are hard to debug and often the main reason for the occurrence of deadlock is when a set of processes are in a wait state because each process is waiting for a resource that is held by some other waiting process. 897 more words