suiteCRM install

📦 Install & Upgrade Help
1

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;

2

Solved?

3

No…
Still face the same error. Kinldy give the suggestion.
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;

4

Can you please give me some more context on this? Normally the installer will take care of creating the database for you. You shouldn’t need to run any SQL commands manually to install SuiteCRM. Why are using these commands?