Results 1 to 3 of 3

Thread: MariaDB 10.0.0.38 - Can't Create Database

  1. #1
    Join Date
    Jun 2017
    Posts
    5

    MariaDB 10.0.0.38 - Can't Create Database

    Hello,

    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:

    ERROR CREATING THE DATABASE
    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.

    mysql_use_new_user_methods=1


    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.

    Regards,

    Matthew

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

  3. #3
    Join Date
    Jun 2017
    Posts
    5

    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:

    https://www.ryadel.com/en/mariadb-10...g-data-how-to/

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

    https://help.directadmin.com/item.php?id=240

    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,

    Matthew

Posting Permissions

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