I get the following error any ideas on why?
Error
SQL query:
CREATE DATABASE ‘suitecrm’
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
MySQL said: Documentation
#1064 - 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 ‘‘suitecrm’
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 1
Here is the code:
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 ‘suitecrm-owner’@‘localhost’ = PASSWORD(‘suitecrm123$%’);
set PASSWORD
FOR ‘suitecrm-owner’@‘127.0.0.1’ = PASSWORD(‘suitecrm123$%’);
SET PASSWORD
FOR ‘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;