Creating a MySQL Database from the Command Line

A short one just to remind me, more than anything else. Log into MySQL with the command mysql -uroot -p To see all existing databases, use show databases; To create a new database, where xxxx is the name of the database you want to create create database xxxx; To add...
Resetting the MySQL Root Password

Resetting the MySQL Root Password

One of a short series of posts listing useful MySQL commands that I use frequently when managing servers and databases. These come in useful when I don’t have access to Navicat, my favored tool for working with client databases. The assumption I make is that you...