Submitted by jecal22 on Sat, 10/06/2018 - 14:49
When adding a new domain with MySQL enabled, I get the following error message:
Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL insert into user (host, user, ssl_type, ssl_cipher, x509_issuer, x509_subject, plugin, authentication_string) values ('localhost', 'EXAMPLE', '', '', '', '', 'mysql_native_password', password('REMOVED')) failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('REMOVED'))' at line 1 at /usr/libexec/webmin/web-lib-funcs.pl line 1493.
After digging a bit, it seems that the PASSWORD() function has been deprecated as of MySQL 8.0.11. I am running MySQL 8.0.12.
Status:
Closed (fixed)
Comments
Submitted by jecal22 on Sat, 10/06/2018 - 14:51 Comment #1
Submitted by andreychek on Sat, 10/06/2018 - 14:55 Comment #2
Howdy -- thanks for letting us know! That does indeed sound like an issue with Virtualmin's support for MySQL 8.
Note though that we really only do testing with the MySQL/MariaDB versions that are included with the distributions we support.
We'll certainly get that fixed! But we unfortunately don't have an ETA for that.
I'm passing this along to Jamie for further review.
Submitted by JamieCameron on Sat, 10/06/2018 - 18:23 Comment #3
MySQL's method for setting user passwords has unfortunately varied significantly since release, so supporting them all in Virtualmin is painful.
Where did you see that the "password" function has been removed?
Submitted by pokmot on Sun, 01/13/2019 - 05:29 Comment #4
The statement that the password function has been removed is here: https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html#functi...
I am happy to do this manually until the new version is supported. How may I enable a database without creating it, which fails every time? Ideally would like to do this for existing domains - somewhere else it mentioned about changing the default template, but that does not seem to work.
Submitted by JamieCameron on Sun, 01/13/2019 - 12:33 Comment #5
I think I'm going to have to re-do the way password setting is done in Virtualmin ... stay tuned.
Submitted by JamieCameron on Sun, 02/03/2019 - 20:57 Comment #6
Ok, support for the password hashing method used in MySQL 8 has been implemented and will be included in the next release.
Submitted by Ned on Mon, 02/18/2019 - 06:09 Comment #7
Error Enabling MySQL Database!
I get this error:
Creating MySQL login .. .. MySQL database failed! : mysql::execute_sql_logged failed : SQL alter user 'apazadito'@'localhost' identified by 'xxxxxxxxxxxxx' failed : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'user 'apazadito'@'localhost' identified by 'xxxxxxxxxxxxx'' at line 1 at /usr/share/webmin/web-lib-funcs.pl line 1478.
Updating Webmin user .. .. done
Updating Webmin user .. .. done
Saving server details .. .. done
Re-loading Webmin .. .. done
There are more people affected by this problem! See this link!
https://www.virtualmin.com/node/64694#comment-808676
Submitted by JamieCameron on Mon, 02/18/2019 - 12:27 Comment #8
Ned - this bug is being tracked here : https://www.virtualmin.com/node/64702
Submitted by IssueBot on Mon, 03/04/2019 - 12:30 Comment #9
Automatically closed - issue fixed for 2 weeks with no activity.