Category: MySql

MySQL change root password

You can change the MySQL root password either with the mysqladmin command or through an SQL query.

Recover MySQL root password

You probably tried to login with your root password and got this error: Access denied for user 'root'@'localhost'

MySQL reset auto increment value

Consider the following table schema:

MySQL remote access

Let's say you want to connect to a remote MySQL server from your home computer. Consider the following configuration: