Results 1 to 3 of 3

Thread: MariaDB - Can't Create Database

  1. #1
    Join Date
    Jun 2017

    MariaDB - Can't Create Database


    I recently switched from using MySQL 5.6 to MariaDB 10.0.38 by running the following commands:

    cd /usr/local/directadmin/custombuild
    ./build update
    ./build set mariadb 10.0
    ./build set mysql_inst mariadb
    ./build mysql

    Everything is working properly except when trying to create a new database as a user within DirectAdmin I am given the following error:

    Unable to add user user_userexample. 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 'IF NOT EXISTS 'user_userexample'@'localhost' IDENTIFIED BY 'Password'' at line 1

    I have referenced the following support forum link:

    I checked my directadmin.conf file and the settings are correct as mentioned in the link above.


    I also restarted DirectAdmin and rebooted the server.

    Please know that I am using the following versions:

    CentOS 7 (64-bit)
    DirectAdmin 1.57.1

    Any help and support in remedying this situation would be greatly appreciated as my clients need to have the ability to create databases.



  2. #2
    Join Date
    May 2008
    Did you try more recent version - 10.3?

  3. #3
    Join Date
    Jun 2017

    Recent version upgrade to 10.3

    Hello wattie,

    Thank you for steering me down the right direction. I followed an update process based on one tutorial:

    I also used the following help script within DirectAdmin support area:

    I am so grateful that now everything seems to be working properly. I can now create databases as a regular user. I hope this thread might help others that run into a similar situation.

    Again thanks a lot,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts