Hi
Where can I find details for setting up digiKam's database using a remote MySQL server? Do I need to create the database manually? What connection options are needed for digiKam to connect? Thanks Jim _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Hi Jim,
I created the digiKam Database(s) manually on my MySQL Server. I created one named "digiKam" and another one named "digiKam-Thumbnails". But as far as I know it does not matter how you name them. Also you need a MySQL User + Password for digiKam. Giving this User full permissions on the Databases does not seem enough for now, so I had to give him full permissions on the MySQL Installation (I think there´s also a Bug / Wishlist entry already about this). Within digiKam the Configuration is easy. In the Database Config, just switch from SQLite to digiKam and the GUI will change. Here you can enter the name / IP of your MySQL Installation, the Port numbers, the names of the 2 databases and the username / password combination. If you already use digiKam and want to migrate to MySQL Server, then you can use the Migrate Menu item in digiKam (the one above the Configure digiKam Menu) to migrate your existing Database to your new MySQL Database. Kind regards! JH> Hi JH> Where can I find details for setting up digiKam's database using a JH> remote MySQL server? JH> Do I need to create the database manually? JH> What connection options are needed for digiKam to connect? JH> Thanks JH> Jim JH> _______________________________________________ JH> Digikam-users mailing list JH> [hidden email] JH> https://mail.kde.org/mailman/listinfo/digikam-users -- Mit freundlichen Grüssen buedi mailto:[hidden email] _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Thanks. I think I'm making progress, but I'm still getting 'Connection
failed'. . bash-3.2# nmap -p3306 localhost . Starting Nmap 5.35DC1 ( http://nmap.org ) at 2012-02-12 15:46 GMT . Nmap scan report for localhost (127.0.0.1) . Host is up (0.00033s latency). . rDNS record for 127.0.0.1: localhost.localdomain . PORT STATE SERVICE . 3306/tcp closed mysql . Nmap done: 1 IP address (1 host up) scanned in 0.54 seconds It looks like port 3306 is closed. How do I open it? Jim On 12/02/12 16:00, buedi wrote: > Hi Jim, > > I created the digiKam Database(s) manually on my MySQL Server. I > created one named "digiKam" and another one named > "digiKam-Thumbnails". But as far as I know it does not matter how you > name them. > Also you need a MySQL User + Password for digiKam. Giving this User > full permissions on the Databases does not seem enough for now, so I > had to give him full permissions on the MySQL Installation (I think > there´s also a Bug / Wishlist entry already about this). > > Within digiKam the Configuration is easy. In the Database Config, just > switch from SQLite to digiKam and the GUI will change. > Here you can enter the name / IP of your MySQL Installation, the Port > numbers, the names of the 2 databases and the username / password > combination. > > If you already use digiKam and want to migrate to MySQL Server, then > you can use the Migrate Menu item in digiKam (the one above the > Configure digiKam Menu) to migrate your existing Database to your new > MySQL Database. > > Kind regards! > > JH> Hi > > JH> Where can I find details for setting up digiKam's database using a > JH> remote MySQL server? > > JH> Do I need to create the database manually? > JH> What connection options are needed for digiKam to connect? > > JH> Thanks > JH> Jim > JH> _______________________________________________ > JH> Digikam-users mailing list > JH> [hidden email] > JH> https://mail.kde.org/mailman/listinfo/digikam-users > > > _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Hi Jim,
JH> Thanks. I think I'm making progress, but I'm still getting 'Connection JH> failed'. I´m not too familiar with MySQL, but if you have PHPMyAdmin installed, can it connect to the MySQL instance? I can only imagine 2 problems right now: 1. Your MySQL Service is not running 2. Your MySQL Service is listening to another Port than the default one Kind regards! _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Free forum by Nabble | Edit this page |