MySQL details needed

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

MySQL details needed

Jim Householder
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
Reply | Threaded
Open this post in threaded view
|

Re: MySQL details needed

buedi
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
Reply | Threaded
Open this post in threaded view
|

Re: MySQL details needed

Jim Householder
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
Reply | Threaded
Open this post in threaded view
|

Re: MySQL details needed

buedi
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