MariaDB 10.0.0.38 - Can't Create Database

[mjflint]

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:

https://forum.directadmin.com/showthread.php?t=57533​

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

 

[wattie]

Did you try more recent version - 10.3?

 

[mjflint]

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-upgrade-10-3-without-losing-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