I installed Omeka 2.3 on my Mac OS X 10.10 Yosemite. I would like to add a plugin directly from the admin dashboard site that comes up when you access Omeka from the localhost. I clicked on the plugin for "Exhibit Builder" and received the following error message:
Zend_Db_Statement_Mysqli_Exception
Mysqli prepare error: CREATE command denied to user 'omeka'@'localhost' for table 'omeka_exhibits'
Omeka also gave me the following code (I assume this is where I have to look for something?):
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: CREATE command denied to user 'omeka'@'localhost' for table 'omeka_exhibits'' in /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('CREATE TABLE IF...')
#1 /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'CREATE TABLE IF...')
#2 /Library/WebServer/Documents/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('CREATE TABLE IF...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...')
#4 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /Library/WebServer/Documents/omeka/plugins/ExhibitBuilder/functions.php(45): Omeka_Db->__call('query', Array)
#6 /Library/WebServer/Documents/omeka/plugins/ExhibitBuilder/functions.php(45): Omeka_Db->query('CREATE TABLE IF...')
#7 [internal function]: exhibit_builder_install(Array)
#8 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Plugin/Broker.php(145): call_user_func('exhibit_builder...', Array)
#9 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Plugin/Installer.php(130): Omeka_Plugin_Broker->callHook('install', Array, Object(Plugin))
#10 /Library/WebServer/Documents/omeka/application/controllers/PluginsController.php(97): Omeka_Plugin_Installer->install(Object(Plugin))
#11 /Library/WebServer/Documents/omeka/application/libraries/Zend/Controller/Action.php(516): PluginsController->installAction()
#12 /Library/WebServer/Documents/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('installAction')
#13 /Library/WebServer/Documents/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#14 /Library/WebServer/Documents/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#15 /Library/WebServer/Documents/omeka/application/libraries/Zend/Application.php(382): Zend_Application_Bootstrap_Bootstrap->run()
#16 /Library/WebServer/Documents/omeka/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#17 /Library/WebServer/Documents/omeka/admin/index.php(28): Omeka_Application->run()
#18 {main}
I am using MySQL Workbench and checked my permissions--I should have permissions to create databases and tables in Omeka, but apparently not.
So my questions are:
1. How do I fix this error message?
1. Will one fix apply to all of the rest of the plugins that I want to add?
Thank you!
Rachel