From kde-commits  Thu Jun 30 20:02:23 2016
From: Swati Lodha <swatilodha27 () gmail ! com>
Date: Thu, 30 Jun 2016 20:02:23 +0000
To: kde-commits
Subject: [digikam] libs/database/utils: Change MySQL initialization commands for remote server
Message-Id: <E1bIiAJ-000279-Um () code ! kde ! org>
X-MARC-Message: https://marc.info/?l=kde-commits&m=146731695808762

Git commit 7cf00536e50cacb55310659344ddaf5b6ff5e1fe by Swati Lodha.
Committed on 30/06/2016 at 20:00.
Pushed by swatil into branch 'master'.

Change MySQL initialization commands for remote server

M  +7    -4    libs/database/utils/dbsettingswidget.cpp

http://commits.kde.org/digikam/7cf00536e50cacb55310659344ddaf5b6ff5e1fe

diff --git a/libs/database/utils/dbsettingswidget.cpp b/libs/database/utils=
/dbsettingswidget.cpp
index 7d3ed27..e10e382 100644
--- a/libs/database/utils/dbsettingswidget.cpp
+++ b/libs/database/utils/dbsettingswidget.cpp
@@ -557,11 +557,14 @@ void DatabaseSettingsWidget::handleInternalServer(int=
 index)
 =

 void DatabaseSettingsWidget::slotUpdateSqlInit()
 {
-    QString sql =3D QString::fromLatin1("GRANT USAGE ON *.* TO \'%1\'@\'lo=
calhost\' IDENTIFIED BY \'<b>password</b>\';<br>")
+    QString sql =3D QString::fromLatin1("CREATE USER \'%1\'@\'%\' IDENTIFI=
ED BY \'<b>password</b>\';<br>")
+                                      .arg(d->userName->text());
+                                      =

+    sql +=3D QString::fromLatin1("GRANT ALL ON *.* TO \'%1\'@\'%\' IDENTIF=
IED BY \'<b>password</b>\';<br>")
                                       .arg(d->userName->text());
 =

     sql +=3D QString::fromLatin1("CREATE DATABASE %1;<br>"
-                               "GRANT ALL PRIVILEGES ON %2.* TO \'%3\'@\'l=
ocalhost\';<br>")
+                               "GRANT ALL PRIVILEGES ON %2.* TO \'%3\'@\'%=
\';<br>")
                                       .arg(d->dbNameCore->text())
                                       .arg(d->dbNameCore->text())
                                       .arg(d->userName->text());
@@ -569,7 +572,7 @@ void DatabaseSettingsWidget::slotUpdateSqlInit()
     if (d->dbNameThumbs->text() !=3D d->dbNameCore->text())
     {
         sql +=3D QString::fromLatin1("CREATE DATABASE %1;<br>"
-                                   "GRANT ALL PRIVILEGES ON %2.* TO \'%3\'=
@\'localhost\';<br>")
+                                   "GRANT ALL PRIVILEGES ON %2.* TO \'%3\'=
@\'%\';<br>")
                                    .arg(d->dbNameThumbs->text())
                                    .arg(d->dbNameThumbs->text())
                                    .arg(d->userName->text());
@@ -579,7 +582,7 @@ void DatabaseSettingsWidget::slotUpdateSqlInit()
         (d->dbNameFace->text() !=3D d->dbNameThumbs->text()))
     {
         sql +=3D QString::fromLatin1("CREATE DATABASE %1;<br>"
-                                   "GRANT ALL PRIVILEGES ON %2.* TO \'%3\'=
@\'localhost\';<br>")
+                                   "GRANT ALL PRIVILEGES ON %2.* TO \'%3\'=
@\'%\';<br>")
                                    .arg(d->dbNameFace->text())
                                    .arg(d->dbNameFace->text())
                                    .arg(d->userName->text());