by Peter Connolly | Aug 10, 2011 | MySQL
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...
by Peter Connolly | Jun 14, 2011 | featured, MySQL
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...