I have installed MySQL 8, which is working 🙂 I can create / delete Databases and Database users.
When going to the Web Application Installer and selecting install Wordpress, if I click "use existing database", select the Database that I created earlier and select the Database Username and enter the password, when clicking install I get the following error message:
 DatabaseUserCannotAccessDatabase:testusername
If I try to install Wordpress and select "Create New Database" I get the following error:
Failure: An error occurred during execution of the database script. The error occurred between the following lines of the script: "5" and "13". The verbose log might have more information about the error. The command started with the following: "CREATE PROCEDURE add_user() BEGIN DECLARE EXIT HAN" 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 'IDENTIFIED BY 'PASSWORD'; FLUSH PRIVILEGES; END' at line 4 http://go.microsoft.com/fwlink/?LinkId=178587 Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SQL_EXECUTION_FAILURE. 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 'IDENTIFIED BY 'PASSWORD'; FLUSH PRIVILEGES; END' at line 4
Anyone else got this issue or know how to resolve ? I am sure I must be missing something stupid 🙂
Thanks, Scott
Hello,
From the error i am half wondering if your SQL user has enough priveledges.
(as i assume mysql 8 still supports flush preveleges and such).
Regards,
Marco
The issue is there are some code that is depreciated in Mysql 8 you cannot use the same code as the version 5 script, I have managed to work this out so far as to get it working on mysql 8 directly and it works as it should, the issue seems to be the way the data is returned to solidcp when its run from the web app gallery now and because it is not getting the required response it gives a different error. Maybe Trevor can look into this further. I am still working on this and if I come right I will post the results back here. There is the new 5.9.3 version files available for 5. Just search for the Anyone else having issues with Web Gallery?
The version 5 sql script is as follows:
USE PlaceholderForDbName;
DROP PROCEDURE IF EXISTS add_user ;
CREATE PROCEDURE add_user()
BEGIN
DECLARE EXIT HANDLER FOR 1044 BEGIN END;
CREATE USER 'PlaceholderForDbUsername'@'localhost' IDENTIFIED BY 'PlaceholderForDbPassword';
GRANT ALL ON test.* TO 'PlaceholderForDbUsername'@'localhost';
FLUSH PRIVILEGES;
END
;
CALL add_user() ;
DROP PROCEDURE IF EXISTS add_user ;
The new script for mysql 8 is as follows:
USE PlaceholderForDbName;
DROP PROCEDURE IF EXISTS add_user ;
DELIMITER $$
USE PlaceholderForDbName
CREATE PROCEDURE `add_user` ()
BEGIN
DECLARE EXIT HANDLER FOR 1044 BEGIN END;
CREATE USER 'PlaceholderForDbUsername'@'localhost' IDENTIFIED BY 'PlaceholderForDbPassword';
GRANT ALL ON PlaceholderForDbName.* TO 'PlaceholderForDbUsername'@'localhost';
FLUSH PRIVILEGES;
END$$
DELIMITER ;
CALL `add_user` ;
DROP PROCEDURE IF EXISTS `add_user` ;
