#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@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.
_______________________________________________
Live-demo mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/live-demo
http://live.osgeo.org
http://wiki.osgeo.org/wiki/Live_GIS_Disc
