search

ajrockefeller / openfpc

Automatically exported from code.google.com/p/openfpc
0 stars 0 forks source link

openfpc-dbmaint SESSION_DB_USER permissions #9

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
line 166 shows...

mysql -u$DBUSER -p$DBPASS -e "use $SESSION_DB_NAME; GRANT ALL PRIVILEGES ON *.* 
TO '$SESSION_DB_USER'@'localhost';"

Is it really necessary to grant ALL to *.*? 

Switching to SESSION_DB_NAME doesn't limit that GRANT to just SESSION_DB_NAME. 
I think this should be...

mysql -u$DBUSER -p$DBPASS -e "use $SESSION_DB_NAME; GRANT ALL PRIVILEGES ON 
$SESSION_DB_NAME.* TO '$SESSION_DB_USER'@'localhost';"

Original issue reported on code.google.com by Jason.R....@gmail.com on 25 Mar 2011 at 6:51

GoogleCodeExporter commented 8 years ago

Original comment by leon.j.w...@gmail.com on 27 Mar 2011 at 6:12

GoogleCodeExporter commented 8 years ago 
Sending        openfpc-dbmaint
Transmitting file data .
Committed revision 285.

Original comment by leon.j.w...@gmail.com on 27 Mar 2011 at 6:15

GoogleCodeExporter commented 8 years ago 
Sending        openfpc-dbmaint
Transmitting file data .
Committed revision 285.

Original comment by leon.j.w...@gmail.com on 27 Mar 2011 at 6:15