I have a new WAMP install, and to install ProjectPier, I am trying to update the MySQL my.ini with the needed innoDB parameters.
innodb_data_home_dir = "C:/wamp/bin/mysql/mysql5.1.33"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/wamp/bin/mysql/mysql5.1.33"
innodb_log_arch_dir = "C:/wamp/bin/mysql/mysql5.1.33"
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
However, after adding these parameters, I can no longer access phpMyAdmin panel. When I comment out all the above parameters again, phpMyAdmin works fine. I have a feeling that the default installation folder path which shows the mysql version (mysql5.1.33) with the periods in the folder name could cause the error (XAMPP does not use such a messy path and works fine). Any suggestions on what to do with my WAMP install to enable projectpier installation?
I forgot to mention that the error message I get in phpMyAdmin is error #2003 access denied with the innoDB settings turned on.
Why WAMP? Why just not to install Linux server with all required components? LAMP solution(Linux+Apache+Mysql+PHP) is more widely used and easier to manager.
Seems that your problem is not directly ProjectPier related. Maybe you shall search WAMP forums?
_______________________
Pro ProjectPier Support: support@projectpier.tk
Download: ProjectPier GoalPanel SF Edition.
Try placing the word data. See sample below:
innodb_data_home_dir = "C:/wamp/bin/mysql/mysql5.1.33/data/"innodb_log_group_home_dir = "C:/wamp/bin/mysql/mysql5.1.33/data/"
innodb_log_arch_dir = "C:/wamp/bin/mysql/mysql5.1.33/data/"
If it still didn't work, try removing the quotes:
innodb_data_home_dir = C:/wamp/bin/mysql/mysql5.1.33/data/innodb_log_group_home_dir = C:/wamp/bin/mysql/mysql5.1.33/data/
innodb_log_arch_dir = C:/wamp/bin/mysql/mysql5.1.33/data/
Regards.
---
KonsolScript Developer
htttp://konsolscript.sourceforge.net