I’m using windows 10 and PhpMyAdmin on XAMPP server. Once while working, mysql server and phpmyadmin stop working with this error: [crayon-64810f34b572d882632688/] following errors I... Read more
Let’s take a look at how to optimize MySQL queries for speed and performance. He we will go through the steps of optimizing SQL queries and databases. This will guarantee stability, sc... Read more
Today we are going to see how to install apache, mysql, php, phpmyadmin and other necessary things required to run a web server perfectly. Apache Apache is the most popular web server in the... Read more
Apache First you should update ubuntu repositories using below command. [crayon-64810f34ba1a1836250125/] Now install apache and other packages [crayon-64810f34ba1aa702811892/] [crayon-64810f... Read more
Today I see an mysql error in my apache log that I never faced before. [crayon-64810f34ba7a0351587921/] After lot of research I found solution. We can set variable innodb_lock_wait_timeout=1... Read more
A stored function is a special kind stored program that returns a single value. You use stored functions to encapsulate common formulas or business rules that are reusable among SQL statemen... Read more
A database table contains multiple columns with specific data types such as numeric or string. MySQL provides more data types other than just numeric or string. Each data type in MySQL can b... Read more
A stored procedure is a subroutine available to connected relational database system applications. A stored procedure is a set of Structured Query Language (SQL) statements with an assigned... Read more