Web & Software Developer

Archive for “MySQL Code”

MySQL commands and SQL queries to help you manage your MySQL databases and tables.

MySQL Command Line Cheat Sheet

These are my most often-used MySQL commands and queries. MySQL Databases List all databases on the command line: Create a database on the command line: Replace database_name, above, with your name of choice. Delete a database: Replace database_name, above, with the actual name of your database. Use (or select) a database: Check which database is […]

Reset MySQL root password in Ubuntu/Linux Command Line

These are the terminal commands to reset your MySQL password for your “root” user. This is useful if you forgot your MySQL password on your local LAMP server. This is a fix for errors like these: ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: NO) ERROR 1045: Access denied for user: ‘root@localhost’ (Using password: […]

Subscribe Existing Commentators Into Comment Notifier Plugin

This is for you if you are using the WordPress Comment Notifier Plugin by Satollo. The purpose of this is to automatically subscribe your existing commentators (which are people who have already made comments to your blog). You want to add these people as subscribers to this Comment Notifier Plugin, or they get left out […]

Add a Field to Existing MySQL Table

Insert a field or column right after some existing field in an existing table in a MySQL database. Replace ‘feildname’ with the new field name which you want to add. Replace ‘existingfield’ with your existing field name (the new field will be inserted after this existing field).