-
-
- <li>We strongly suggest using a GUI to manage your database(s) and database users. If you don’t have any, download <a href="http://www.phpmyadmin.net/"><strong>phpMyAdmin</strong></a>. </li>
-
-
- <li>Create a database with a name of your choice. The default in config_db.php is ‘<strong><em>frontacc</em></strong>’, but of course you can select whatever name you desire. </li>
-
-
- <li>Populate the database you have created. There are two scripts
-are provided to populate the database (both inside the folder /sql) :
-
-
- <ol>
-
-
- <li><strong><em>en_US-demo.sql</em></strong>. This has a minimal amount of demonstration data set up so that transactions can be tried to see how the system works. </li>
-
-
- <li><strong><em>en_US-new.sql</em></strong>. This script has
-only the basic data necessary to start a new company system off. If you
-wish to set up your company on FrontAccounting then this is the script
-to use. </li>
-
-
-
- </ol>
-
-
- </li>
-
-
- <li>Now that the database is created you will need to set up a
-database user to access this database. DO NOT USE THE USER
-‘ROOT’. Set up a new user and give that user full
-privileges over the database ‘frontacc’.</li>
- <li>After successfully install, remove or rename your install directory <strong><em>your_url/account/install</em></strong> (or
-whatever directory you entered) for safety reasons. You don't need it any more.</li>
-
-
-
- </ol>
-
-
- </li>
-
-
- <li>
-
- <h3>Editing config_db.php</h3>
-
-
-
- <ol>
-
-
- <li><strong><em>config_db.php</em></strong> contains connection
-information for the database. These must be set to your local settings
-or you will not be able to access FrontAccounting. </li>
-
-
- <li>FrontAccounting allows multiple connections, you can enter as
-many connections as you have separate entities (most people will use
-only one). </li>
-
-
- <li><strong>$db_connections</strong> is an array of connections – for each connection : </li>
-
-
- <li>“<strong>name</strong>” is the name of the connection, this is the name that will be displayed to the user </li>
-
-
- <li>“<strong>host</strong>” is the computer IP
-address or name where the database is. The default is localhost
-assuming that the web server is also the sql server. </li>
-
-
- <li>“<strong>dbuse</strong>r” is the user name under
-which the database should be accessed. NB, again, do not use the user
-ROOT. A user with appropriate privileges must be set up. </li>
-
-
- <li>“<strong>dbpassword</strong>” is the password for “dbuser”. You would have entered this when you created “dbuser”. </li>
-
-
- <li>“<strong>dbname</strong>” is the name of the database. The provided scripts use the name OpenAccounting. </li>
-
-
- <li>“<strong>tbpref</strong>” is the table prefix for
-the tables. If you only have access to one database, you must use table
-prefix to separate the companies. Table prefix is set by a table prefix
-counter inside config_db.php, fi. 0_ for the first company.</li>
-
-
-
- </ol>
-
-
- </li>
-
-
-</ol>
-
-
-<h2> Logging In For the First Time</h2>
-
-
-<ol>
-
-
- <li>Pleae ensure that the folder <strong>/company/0</strong> on the server is <strong>writable</strong>. </li>
-
-
- <li>Open a browser and enter the URL for the web server directory where FrontAccounting is installed. </li>
-
-
- <li>Enter the user name: '<strong>admin</strong>' </li>
-
-
- <li>Enter the password: '<strong>password</strong>' </li>
-
-
- <li>(NB : enter without quotation marks). </li>
-
-
- <li>
-
- <div>You can set up additional user accounts from the System Setup