[Live-demo] [OSGeo] #969: mySQL and Ushahidi: db permission problems

[OSGeo]

#969: mySQL and Ushahidi: db permission problems
----------------------------------+-----------------------------------------
 Reporter:  hamish                |        Owner:  live-demo@…              
     Type:  defect                |       Status:  reopened                 
 Priority:  critical              |    Milestone:  OSGeoLive6.0RC1          
Component:  LiveDVD               |   Resolution:                           
 Keywords:  6.0, mysql, ushahidi  |  
----------------------------------+-----------------------------------------

Comment(by hamish):

 funny, does /etc/mysql/debian.cnf get removed? it's not there in the iso,
 but seems to have worked to extract the admin name below:
  MySQL admin name is <debian-sys-maint>. (see /etc/mysql/debian.cnf)

 I only see /etc/mysql/my.conf.
 ?

 anyway, this works:
 {{{
 user at osgeolive:~$ mysql -u root -p
 Enter password:
 }}}

 with the user's paswd. then
 {{{
 CREATE DATABASE ushahidi;
 GRANT ALL PRIVILEGES ON ushahidi.* TO ‘user’@’localhost’ IDENTIFIED BY
 ‘user’;
 }}}

 as described in the ushahidi quickstart.


 hopefully fixed by r9009, but I've put some debugging stuff into the build
 log in case it isn't.


 Hamish

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/969#comment:21>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.