Getting Error please help how to fix

[Viren Gajjar]

SQL query: Copy

CREATE DATABASE 'espocrm' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

MySQL said:
#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 ''espocrm'
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

[Maximus]

Hello,
Could you provide more info? Does this error occur upon new EspoCRM installation process?
Please provide an EspoCRM log file with this error description https://docs.espocrm.com/administrat...ng/#check-logs.
What is your MySQL/MariaDB version? Here is the required DB versions https://docs.espocrm.com/administrat...on-for-espocrm.

[Viren Gajjar]

i dont know about mysql and mariadb but i provide you this info, if you guide me how will i know the Mysql or MariaDB i will get it,m still providing info

using this in windows 10
ampp-windows-x64-7.4.19-0-VC15-installer,
EspoCRM-6.1.7

code I used in localhost/PHPMyAdmin

CREATE DATABASE 'espocrm'
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'espocrm-owner'@'localhost';
CREATE USER 'espocrm-owner'@'127.0.0.1';
CREATE USER 'espocrm-owner'@'::1';

SET PASSWORD
FOR 'espocrm-owner'@'localhost'; = PASSWORD('espocrm123$%');
SET PASSWORD
FOR 'espocrm-owner'@'127.0.0.1'; = PASSWORD('espocrm123$%');
SET PASSWORD
FOR 'espocrm-owner'@'::1'; = PASSWORD('espocrm123$%');


GRANT ALL PRIVILEGES ON
'espocrm'.* TO 'espocrm-owner'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON
'espocrm'.* TO 'espocrm-owner'@'127.0.0.1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON
'espocrm'.* TO 'espocrm-owner'@'::1' WITH GRANT OPTION;

[Viren Gajjar]

i think i found something is this correct ?

Database server

• Server: 127.0.0.1 via TCP/IP
• Server type: MariaDB
• Server connection: SSL is not being used
• Server version: 10.4.19-MariaDB - mariadb.org binary distribution
• Protocol version: 10
• User: root@localhost
• Server charset: UTF-8 Unicode (utf8mb4)

Web server

• Apache/2.4.47 (Win64) OpenSSL/1.1.1k PHP/7.4.19
• Database client version: libmysql - mysqlnd 7.4.19
• PHP extension: mysqli curl mbstring
• PHP version: 7.4.19