BeansBooks is an Open Code cloud accounting web application that is flexible and scales easily. It simplifies accounting while providing insightful reports. Ideal for small to medium sized businesses, read on to find out how to install BeansBooks on an Ubuntu 14.04 computer.
Change the permissions of the BeansBooks folder to be accessible by the web server
cd ..
sudo chown www-data:www-data -R html
Configure MySQL
Access MySQL from terminal
mysql -h localhost -u root -p
Enter the password for the root user.
Create a new MySQL user and password
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT USAGE ON * . * TO 'username'@'localhost' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
NOTE: don’t forget to change the username and password. NOTE: after pressing enter after each command, MySQL should output ‘Query OK’
Create a new MySQL database, grant the new user permissions and exit MySQL shell.
CREATE DATABASE IF NOT EXISTS `beans` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON `beans`.* TO 'beans'@'localhost';
exit
Note: “beans” is the name of database. Feel free to change it as necessary.
Configure Apache Web Server
Enable the rewrite mod for Apache and mcrypt setting of php
sudo a2enmod rewrite
sudo php5enmod mcrypt
Open a text editor for Apache’s configuration file
Thank you for reading this article. If you found it useful, please consider buying us a coffee, subscribing to the YouTube Channel, and/or changing
your Amazon bookmark to our affiliate link (CAN, USA, UK). We do
this out of general interests and to help others. Thanks!