Commits

Zhang Huangbin committed 8708860

Fix incorrect database setup for cluebringer.

Comments (0)

Files changed (1)

iRedMail/functions/cluebringer.sh

 
     elif [ X"${DISTRO}" == X"DEBIAN" -o X"${DISTRO}" == X"UBUNTU" ]; then
         cat > ${tmp_sql} <<EOF
-# Reset root password.
-USE mysql;
-UPDATE user SET Password=password("${CLUEBRINGER_DB_PASSWD}") WHERE User="${CLUEBRINGER_DB_USER}";
-FLUSH PRIVILEGES;
 CREATE DATABASE ${CLUEBRINGER_DB_NAME};
+GRANT SELECT,INSERT,UPDATE,DELETE ON ${CLUEBRINGER_DB_NAME}.* TO "${CLUEBRINGER_DB_USER}"@localhost IDENTIFIED BY "${CLUEBRINGER_DB_PASSWD}";
 USE ${CLUEBRINGER_DB_NAME};
 EOF