I’m using windows 10 and PhpMyAdmin on XAMPP server. Once while working, mysql server and phpmyadmin stop working with this error: mysqli_real_connect(): (HY000/1130): Host 'localhos... 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. sudo apt-get update Now install apache and other packages sudo apt-get install apache2 sudo is used to execute these... Read more
Today I see an mysql error in my apache log that I never faced before. default decode:true ">InternalError: (1205, u'Lock wait timeout exceeded; try restarting transaction') (10 additional f... 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
