Setup and create my first Firebird database on Windows?

Question:

Answer:

1. Download and Install the Firebird application (as superserver and service) into %systemdrive%\fbsql I installed into d:\fbsql, and I will use this as my example, you may have another. I believe the default is c:\Program Files\Firebird SQL. When I installed I basically selected all the defaults except for my install path.
2. after install start service
   
   
3. Go to Start, Run, and open cmd promt:
   cd d:\fbsql
   bin\gsec -user sysdba -password masterkey -database
   localhost:d:\fbsql\security.fdb
   
4. Once in GSEC... you have a prompt: GSEC>
   GSEC> Add dbuser -pw yourpassword -fname fullname
   GSEC> display
   GSEC> quit
   
5. Next open the sample database:
   bin\isql localhost:d:\fbsql\examples\employee.fdb -u dbuser -p
   yourpassword
   
6. Now lets create mydb, you now have a prompt: SQL>
   SQL>create database 'localhost:d:\fbsql\mydb.fdb';
   SQL>exit;
   
7. You now have a new database created and you should be able to log in like so:
   d:\fbsql\bin\isql localhost:d:\fbsql\mydb.fdb -u dbuser -p yourpassword
   
   - OR - from a remote host (if you installed the client)
   
   pathto\isql servername:d:\fbsql\mydb.fdb -u dbuser -p yourpassword