Magento News

 

WordPress and Magento wIll read from MySql, but will not insert or edit from their CMS

Local install of Magento and WordPress on Mac OS X (10.7) running PHP 5.3.6 and MySQL (installed with mysql-5.5.18-osx10.6-x86_64.dmg).

They both read from their respective db tables, but I cannot, for example, edit a blog post and insert into the db from the cms. It will always timeout. Same with the magento install. If I update the blog post directly through MySQL Workbench, it will be read and show up when I refresh the local install/site, but it won’t insert via the cms. It seems my set up will pull from the db, but not push to the db.

My guess is it has something to do with permissions, but I’ve double checked and all users and roles have total access. I’ve uninstalled and re-installed MySQL a handful of times now, reinstalled wordpress and magento a number of times to no avail. I read somewhere with Lion you have to create ‘/private/etc/my.cnf’ file and use: 

[client]
socket = /var/mysql/mysql.sock

[mysqld]
socket = /var/mysql/mysql.sock

And in the ‘php.ini’ file, to use:

mysql.default_socket = /var/mysql/mysql.sock

But that doesn’t seem to fix it. I get the same results.

Additionally, I installed and set-up Magento with my web hosting provider (1and1.com) and it all works as it should. I can update the db through the cms.

Does anyone have any ideas what could be happening?

Thank you so much for any help.

WordPress and Magento wIll read from MySql, but will not insert or edit from their CMS

Possibly Related Posts:


 

Leave a Reply