Mysql Index Page 1

MySQL: Error in query (1548): Cannot load from mysql.proc. The table is probably corrupted

When you get the error: Error in query (1548): Cannot load from mysql.proc. The table is probably corrupted. You can try to repair MySQL using "mysqlcheck -r mysql proc -u root -p", if the error persists check our full solution here.

Mysql Index Page 1

Steps to disable root login in phpMyAdmin

To disable root login in phpMyAdmin set AllowRoot to false like this example: $cfg['Servers'][$i]['AllowRoot'] = FALSE;. If you want more details check our tutorial.

Mysql Index Page 1

How to change MySQL root Password

In this tutorial we explain how to reset the password of root user in MySQL. We explain how to change it using mysqladmin and using queries. We also explain how to change root password when you forgot the previous password using mysql_safe command with --skip-grant-tables

Mysql Index Page 1

Ubuntu 18.04: Installing Apache2 + PHP5 + MySQL + phpMyAdmin

In this short tutorial we explain how to install phpmyadmin with apache 2 on ubuntu 18.04.

Mysql Index Page 1

Standard SQL:What is the difference between "INNER JOIN" and "OUTER JOIN"?

For beginners when learning JOIN it's a common error to ignore different types of JOIN. Some junior developers could use a wrong JOIN that looks like correct when it's not the case. Make sure you learn differences between LEFT JOIN and RIGHT JOIN

Mysql Index Page 1

MySQL my.cnf recommended optimization

MySQL configuration by default comes with general configuration that can be optmized for specific configuration. Most of modern server configuration should be changed to improve performance. In this brief tutorial we explain how to improve performance by tunning my.cnf configurations.

Mysql Index Page 1

How to install and configure MySQL on Ubuntu 16.04

Follow this guide to installing MySQL on ubuntu 16.04. We also cover how to create a database user.