[Digikam-users] Setting up MySQL Digikam database

[upscope]

On Sunday, December 18, 2011 03:26:37 PM bruno.leon at nividic.org wrote:
> If you speak french, I kept a procedure for this as I also had a hard
> time making this work.
> 
> http://blog.pompomgali.com/?p=141
> 
> > Been trying to setup Digikam (Version 2.3.0
> > Using KDE Development Platform 4.7.4 (4.7.4) "release 11") for a
> > week now.  I want to use the MySQl server I have on local host.
> > Everthing appears to be setup correctly.
> > 
> > Database type is MySQL
> > from digikamrc:
> > Code
> > --------------
> > [Database Settings]
> > Database Connectoptions=digikambdb
> > Database Hostname=localhost
> > Database Name=/home/finemanruss/Documents/Pictures/digikam4.db
> > Database
> > NameThumbnails=/home/finemanruss/Documents/Pictures/thumbnails-
> > digikam.db
> > Database Password=xxxxxxxxxxxxx(actual password here)
> > Database Port=3306
> > Database Type=QMYSQL
> > Database Username=digikamuser (my user ID is member of digikamuser
> > group)
> > Internal Database Server=false
> > /Code
> > -------------
> > Check dbconnection : Database connection test successful. (as
> > digikamuser)
> > 
> > On mysql server I created two databases: digikamdb and
> > digikamthumbdb. Also created a digikamuser group which my user
> > name is in.
> > 
> > I can log into the databasefrom a command line as digikamuser, my
> > Id and root with no problem.
> > 
> > Think my problem is the Database name and NameThumbnails lines
> > above. Also what permissions does digikamuser need on the
> > database and does it setup the tables?
> > 
> > Can not find a section in manual on setting up the database. I do
> > have a Kmymoney and 2 Lions Clubs databases on local host and
> > they work fine.
> > 
> > Any help would be greatly appreciated. Link to a how to document
> > would help.
> > 
> > Thanks in advance
Bruno Thanks alot I fine got to it today and everything is working ao 
far. Had one little issue with typing the password correctly into 
digikamrc but the error message was very explicied on what to check.

Your write was great even before I translated it.

Thanks Again! Hope I can help someone in the future. 

Russ
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users