Line 6: |
Line 6: |
| === Create a MySQL database for Piwigo === | | === Create a MySQL database for Piwigo === |
| :$ mysqladmin create 'piwigo' –default-character-set=utf8 | | :$ mysqladmin create 'piwigo' –default-character-set=utf8 |
− | === And create a MySQL user for the new database === | + | === Create a MySQL user for the new database === |
| :$ mysql | | :$ mysql |
− | : > grant insert,update,delete,create,alter,drop on piwigo.* to piwigo@localhost idenfied by 'my_secret_password'; | + | : > grant select,insert,update,delete,create,alter,drop on piwigo.* to piwigo@localhost identified by 'my_secret_password'; |
| : > flush privileges; | | : > flush privileges; |
| : > quit; | | : > quit; |
Line 30: |
Line 30: |
| | Password || my_secret_password (the database user's password) | | | Password || my_secret_password (the database user's password) |
| |- | | |- |
− | | Database name || Piwigo | + | | Database name || piwigo |
| |- | | |- |
| | Database table prefix || piwigo_ | | | Database table prefix || piwigo_ |
Line 48: |
Line 48: |
| === Importing from Gallery === | | === Importing from Gallery === |
| If you have previously used Gallery, Piwigo can import the images, comments etc. from your albums there. Checkout the Menalto2Piwigo-plugin | | If you have previously used Gallery, Piwigo can import the images, comments etc. from your albums there. Checkout the Menalto2Piwigo-plugin |
| + | |
| + | [[Category:Howto]] |