Lesson #1: Installations
This tutorial shows you how to install databases on various operating systems. It is organized by the database product. You can unfold content about the database and see the related articles. Within each database product, there’s a section for installations, configurations, and troubleshooting techniques. As concepts evolve and technology changes, some of these may direct you to my active blog site.
The databases are organized alphabetically, lest I offend somebody. My bias is toward Oracle, which was my second relational database after IBM DB2.
MySQL Database Server ↓
A list of entries that support installing, configuring, and troubleshooting the MySQL Database.
Reset MySQL User Password ↓
A demonstration of how to reset your password without root permissions.
You reset your own password when you’re not the root user with this syntax:
mysql> SET PASSWORD = PASSWORD('new_password');
This is simple syntax but carries a risk if you walk away from your terminal because somebody can run it without needing to know the original user password.
Oracle Database Server ↓
A list of entries that support installing, configuring, and troubleshooting the Oracle Database.
Install Oracle 10g XE on Windows
Reset Oracle User Password ↓
A demonstration of how to reset your password without SYSTEM permissions.
Oracle requires that you know the original password if you use this syntax:
SQL> PASSWORD Changing password FOR PLSQL OLD password: NEW password: Retype NEW password: Password changed
If you think that you’re safe walking away from an Oracle SQL*Plus console, check this because it doesn’t require knowing the current password either.
SQL> SHOW USER USER IS "PLSQL" SQL> ALTER USER plsql IDENTIFIED BY plsql; USER altered.
Microsoft SQL Server ↓
A list of entries that support installing, configuring, and troubleshooting the Microsoft SQL Server Database.
If you have comments to improve the contents, please make them.
