MariaDB 10.0.0.38 - Can't Create Database

mjflint

Verified User
Joined
Jun 22, 2017
Messages
5
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
 

mjflint

Verified User
Joined
Jun 22, 2017
Messages
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-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
 
Top