|
(→Installation w/MySQL)
|
(→Installation w/MySQL)
|
| Line 19: | |||
| This will grant all permissions for the specified user to connect to the specified database name. | This will grant all permissions for the specified user to connect to the specified database name. | ||
| + | == Known Issue w/MySQL 5.5x Versions == | ||
| + | Newer versions of MySQL[https://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html 1] are known to have some issues with the default grants listed above. In that case, you have to manually specify the user for the grant (along with machine name): | ||
| + | <pre>mysql> create database [database-name]; | ||
| + | Query OK, 1 row affected (0.00 sec) | ||
| + | . | ||
| + | . | ||
| + | . | ||
| + | mysql> grant all on [database-name].* to '[dbuser]'@'[machine-name]' identified by '[dbpass]' | ||
| + | with grant option; | ||
| + | Query OK, 0 rows affected (0.03 sec) | ||
| + | </pre> | ||
| = Installation w/Oracle XE = | = Installation w/Oracle XE = | ||
