Vtiger website<\/a>. Let’s login to MySQL shell as root users and create a database for our Vtiger CRM website.<\/p>\n\n\n\n# mysql<\/pre>\n\n\n\nOnce logged in to MySQL shell, we can run the following commands.<\/p>\n\n\n\n
mysql> CREATE DATABASE vtiger;
mysql> GRANT ALL on vtiger.* to vtiger@localhost identified by 'm0d1fyth15';
mysql> FLUSH PRIVILEGES;
mysql> \\q<\/pre>\n\n\n\nMake sure to create a more robust database password substitute m0d1fyth15 <\/strong>in the command above with a more secure one.<\/p>\n\n\n\nAfter this, we also need to modify our SQL_MODE<\/p>\n\n\n\n
# nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/pre>\n\n\n\nAdd this line under section [mysqld]<\/p>\n\n\n\n
sql_mode = NO_ENGINE_SUBSTITUTION<\/pre>\n\n\n\nThen, restart MariaDB server<\/p>\n\n\n\n
# systemctl restart mariadb<\/pre>\n\n\n\nTo secure your MariaDB installation, you can create a password for your MySQL root user.<\/p>\n\n\n\n
# mysql_secure_installation<\/pre>\n\n\n\nNext time, you will be asked for MySQL root password when logging in to MySQL shell using the root user.<\/p>\n\n\n\n