Database and Login Setup

only for RuBoard - do not distribute or recompile

As did the Worldwide Commissions Application (WCA) presented in Chapters 8, 9, and 10, this application will maintain its own security tables. The login and password the user enters will be compared against application tables to set the user interface correctly for the given user . The application login and password will be

Login: kbi_user

Password: dengissa

Also like WCA, the MySQL server on the server machine needs to know which machines on the network will be logging in via the application login (kbi_user). In the following, einstein is the server machine, and for an example, delfin will be one of the desktop machines. Launch mysql as administrator, and from the mysql> prompt, send the following command:

 mysql> Grant All on kbi.* to kbi_user@delfin Identified by "dengissa";

kbi is the name of the database (see the next section, Creating the Database ). Also, to test the application and develop it on the server, the same command needs to be sent regarding the server, as was explained in more detail in Chapter 8. Remember that you will need to issue this command for every client machine that intends to run this application.

only for RuBoard - do not distribute or recompile