[Digikam-users] 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>  Digikam-users at kde.org
> JH>  https://mail.kde.org/mailman/listinfo/digikam-users
>
>
>