Hello,
I tried to create a database when installing my suitecrm and MySQL responded with an error message :
#1064 - Erreur de syntaxe près de ‘‘suitecrm’
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci’ à la ligne 1
This is the code I copied from somewhere (I’m not a programmer, just a user) :
CREATE DATABASE ‘suitecrm’
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER ‘suitecrm-owner’@‘localhost’;
CREATE USER ‘suitecrm-owner’@‘127.0.0.1’;
CREATE USER ‘suitecrm-owner’@’::1’;
SET PASSWORD
FOR CREATE USER ‘suitecrm-owner’@‘localhost’= PASSWORD(‘suitecrm123$%’);
SET PASSWORD
FOR CREATE USER ‘suitecrm-owner’@‘127.0.0.1’= PASSWORD(‘suitecrm123$%’);
SET PASSWORD
FOR CREATE USER ‘suitecrm-owner’@’::1’= PASSWORD(‘suitecrm123$%’);
GRANT ALL PRIVILEGES ON
‘suitecrm’.* TO ‘suitecrm-owner’@‘localhost’ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON
‘suitecrm’.* TO ‘suitecrm-owner’@‘127.0.0.1’ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON
‘suitecrm’.* TO ‘suitecrm-owner’@’::1’ WITH GRANT OPTION;
How can I solve the problem please ?