147
edits
Changes
Jump to navigation
Jump to search
mLine 22:
Line 22: − + − + − + − + − + − + − + + + + + − 2. Create a PhreeBooks database (either via command line or I use phpMyAdmin)+ − + − + − + − phpMyAdmin - http://stackoverflow.com/questions/3939099/phpmyadmin-showing-myisam-instead-of-innodb+ − phpMyAdmin - http://virtualizesharepoint.com/2011/05/11/convert-myisam-to-innodb-using-phpmyadmin-for-moodle/ − MySQL - http://wiki.contribs.org/MySQL − − − − In phpMyAdmin: − Create database - phreebooks − Collation – utf8_general_ci − Create user: select 'phreebooks' database from list on LHS > Privileges > Add User − set unique User Name and Password (make sure that you have made a note of these) − host - localhost − Database for user - Grant all privileges on database “phreebooks” − Add User + + + + + + + +
→Set-up on SME8: formating
1. Create a Bookkeeping ibay (from which to run PhreeBooks) using Server Manager<br>
1. Create a Bookkeeping ibay
Information bay name - bookkeeping
This will be the directory Phreebook will run from. You must create it from Server Manager<br>
Description – '''Phreebooks Accounting'''
Information bay name - bookkeeping<br>
Group – Admin ... (set user Group)
Description – '''Phreebooks Accounting'''<br>
User access via file sharing or user ftp – '''Write = group, Read = group'''
Group – Admin ... (set user Group)<br>
Public access via web or anonymous ftp – '''Local network, no password required'''
User access via file sharing or user ftp – '''Write = group, Read = group'''<br>
Execution of dynamic content (CGI, PHP, SSI) – '''Enabled'''
Public access via web or anonymous ftp – '''Local network, no password required''' <br>
Execution of dynamic content (CGI, PHP, SSI) – '''Enabled'''<br>
<br>
2. Create a PhreeBooks database
You can do it via via command line or I use [[PHPMyAdmin]].
{{Note box| Please note that it is strongly advised to set MySQL to default to the InnoDB format using [[MySQL#Enable_InnoDB_engine]] <br>
Please note that it is strongly advised to set MySQL to default to the InnoDB format and not
and not MyISAM, as apparently InnoDB is 'more robust'. <br>
MyISAM, as apparently InnoDB is 'more robust'. PhpMyAdmin seems to be set out-of-the-box to default to MyISAM.
BTW: PhpMyAdmin seems to be set out-of-the-box to default to MyISAM. <br>
<br>
This InnoDB / MyISAM issue won't affect getting PhreeBooks going now, however, may cause some data integrity uncertainty down the road. Best to get it right now. }}
This InnoDB / MyISAM issue won't affect getting PhreeBooks going now, however, may cause some data integrity uncertainty down the road. Best to get it right now.
In PHPMyAdmin:<br>
Create database - '''phreebooks'''<br>
Collation – utf8_general_ci<br>
Create user: select ''''phreebooks'''' database from list on LHS > Privileges > Add User<br>
Choose a unique '''User Name''' and '''Password''' and (make sure that you have made a note of these!<br>
host - '''localhost'''<br>
Database for user - '''Grant all privileges''' on database '''phreebooks'''<br>
'''Add User'''<br>