ElkArte Community

Project Support => Support => Topic started by: kucing on August 09, 2018, 04:08:43 pm

Title: The MySQL user you have set in Settings.php does not have proper privileges.
Post by: kucing on August 09, 2018, 04:08:43 pm
Hi, I just tried to upgrade from 1.0.10 to 1.1.4 but it failed.

Quote
Upgrading Your ElkArte Install!
The MySQL user you have set in Settings.php does not have proper privileges.

Please ask your host to give this user the ALTER, CREATE, and DROP privileges.
Click here to try again.
I double checked and the user mentioned is already having ALL PRIVILEGES granted. even when I'm changing the user to root it still failing with the same error.

Code: [Select]
mysql -V
mysql  Ver 15.1 Distrib 10.2.16-MariaDB, for Linux (x86_64) using readline 5.1

Code: [Select]
php -v
PHP 5.6.37 (cli) (built: Jul 19 2018 19:57:52)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies

Any opinion on what should I do to troubleshoot this?
Title: Re: What PHP version to use for upgrading Elkarte 1.0.10?
Post by: kucing on August 09, 2018, 04:12:00 pm
On related note on my failing to upgrade Elk 1.0.10 to 1.1.4.

I use php 5.6 currently. should i upgrade first to 7.1 before attempting to upgrade elk, or can i just do it using 5.6 and after that upgrading PHP??
Title: Re: What PHP version to use for upgrading Elkarte 1.0.10?
Post by: vbgamer45 on August 10, 2018, 05:30:20 am
Upgrade PHP version to 7.1 then update Elkarte
Title: Re: What PHP version to use for upgrading Elkarte 1.0.10?
Post by: kucing on August 10, 2018, 06:09:22 pm
thanks. i will try it again later.

-

still failing with the mysql mentioned above. :(

currently using php 7.1 for elk 1.0.10:
Code: [Select]
PHP 7.1.20 (cli) (built: Jul 19 2018 10:10:15) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.1.20, Copyright (c) 1999-2018, by Zend Technologies
Title: Re: The MySQL user you have set in Settings.php does not have proper privileges.
Post by: tino on August 10, 2018, 07:57:39 pm
There is a error in the upgrader for 1.1.4 this was fixed in https://github.com/emanuele45/Dialogo/commit/6bc0556850091acc3ad174904ef20705bfdf7239 due to be released with 1.1.5
Title: Re: The MySQL user you have set in Settings.php does not have proper privileges.
Post by: emanuele on August 10, 2018, 08:43:11 pm
Sorry, I couldn't manage to release 1.1.5 last week, will ship it either tomorrow or Sunday.
Title: Re: The MySQL user you have set in Settings.php does not have proper privileges.
Post by: kucing on August 11, 2018, 03:38:20 am
ah sorry, my google fu failed me. didn't there is another topic discussing this: https://www.elkarte.net/community/index.php?topic=5333.msg38132#msg38132

thanks i will wait the next release.