Fishpig Wordpress Integration
Wordpress Running in Separate DB¶
It's a good idea to run Wordpress in a separate DB to Magento. This has security benefits as well as making it simple to backup and update the Wordpress database in isolation.
This can be done at:
Wordpress > Settings > Database.
Change "Do Magento and WordPress share a database?" to
No and enter the required DB credentials.
Handle Access to Magento DB¶
The Fishpig module joins its own Magento tables with some Wordpress tables. In order to allow this and still maintain the security benefits of having a seperate DB you will need to provide the Wordpress database user with access to the required Magento database tables (and only those tables).
To do this you can run:
GRANT ALL PRIVILEGES ON [magento db name].wordpress_association TO '[wordpress user name]'@'localhost'; GRANT ALL PRIVILEGES ON [magento db name].wordpress_association_type TO '[wordpress user name]'@'localhost';