Access denied for user about suma HOT 7 CLOSED

This really looks like a MySQL permissions issue. Are you able to connect to the suma database using the suma_application username and the password you've specified in the suma server config file using a MySQL client (either on the command line, or a GUI application)? Is it possible that you've created the account, but not granted the privileges for access from localhost?

from suma.

I have done all of this in phpmyadmin. The suma_application user exists in the user table, and I see that it has privileges for the suma database specifically. Also, the host is set to %, which I understand to be any host, including localhost. Is there anything I might still be missing?

from suma.

Let me think about this, but for now let's try the following two ideas:

1. Please double-check the username and password in the Suma config.ini file.
2. Change the host for the suma_application user to localhost (assuming that the MySQL server and the Suma server are on the same server). There is no need to open access to this account to the world, and there are some cases where wildcard hosts can cause issues in MySQL:

It is necessary to have both accounts for monty to be able to connect from anywhere as monty. Without the localhost account, the anonymous-user account for localhost that is created by mysql_install_db would take precedence when monty connects from the local host. As a result, monty would be treated as an anonymous user. The reason for this is that the anonymous-user account has a more specific Host column value than the 'monty'@'%' account and thus comes earlier in the user table sort order.

http://dev.mysql.com/doc/refman/5.6/en/adding-users.html

from suma.

Changing the host to localhost brought up some different errors:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1049] Unknown database 'sumadev'' in C:\wamp\www\app\sumaserver\lib\zend\library\Zend\Db\Adapter\Pdo\Abstract.php on line 144
PDOException: SQLSTATE[HY000] [1049] Unknown database 'sumadev' in C:\wamp\www\app\sumaserver\lib\zend\library\Zend\Db\Adapter\Pdo\Abstract.php on line 129
Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1049] Unknown database 'sumadev' in C:\wamp\www\app\sumaserver\lib\zend\library\Zend\Db\Adapter\Pdo\Abstract.php on line 144

from suma.

Are you sure the sumadev database has been created and the suma_application user has access to it?

from suma.

Ah, that might be it. I named it just suma, not sumadev.

from suma.

Yes, that was it. I renamed it and am able to access Edit Locations. Thanks again, cazzerson! I appreciate it.

from suma.