mysql | 100Utils

mysqli_real_connect(): (HY000/1130): Host ‘localhost’ is not allowed to connect to this MariaDB server

Posted By: Krish Johnsonon: April 24, 2020In: TutorialsNo Comments

I’m using windows 10 and PhpMyAdmin on XAMPP server. Once while working, mysql server and phpmyadmin stop working with this error: [crayon-6040daaf70b2a670308004/] following errors I... Read more

Optimize MySQL Queries for Speed and Performance

Posted By: Krish Johnsonon: March 01, 2019In: TutorialsNo Comments

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

Install Linux, Apache, MySQL, PHP on Ubuntu 18.04

Posted By: Krish Johnsonon: June 06, 2018In: TutorialsNo Comments

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

Install Apache, MySQL and PHP on Ubuntu 16.04

Posted By: Krish Johnsonon: May 16, 2018In: TutorialsNo Comments

Apache First you should update ubuntu repositories using below command. [crayon-6040daaf786af493195705/] Now install apache and other packages [crayon-6040daaf786bb413202983/] [crayon-6040da... Read more

mysql Lock wait timeout exceeded; try restarting transaction

Posted By: Krish Johnsonon: April 20, 2018In: TutorialsNo Comments

Today I see an mysql error in my apache log that I never faced before. [crayon-6040daaf78c6e559164255/] After lot of research I found solution. We can set variable innodb_lock_wait_timeout=1... Read more

Stored Function

Posted By: Krish Johnsonon: April 17, 2018In: TutorialsNo Comments

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

MySQL Data Types

Posted By: Krish Johnsonon: April 17, 2018In: TutorialsNo Comments

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

Stored Procedure

Posted By: Krish Johnsonon: April 17, 2018In: TutorialsNo Comments

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