Skip to main content
Topic: The MySQL user you have set in Settings.php does not have proper privileges. (Read 108 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

The MySQL user you have set in Settings.php does not have proper privileges.

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?

Re: What PHP version to use for upgrading Elkarte 1.0.10?

Reply #1
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??

Re: What PHP version to use for upgrading Elkarte 1.0.10?

Reply #2
Upgrade PHP version to 7.1 then update Elkarte

Re: What PHP version to use for upgrading Elkarte 1.0.10?

Reply #3
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

 

Re: The MySQL user you have set in Settings.php does not have proper privileges.

Reply #5
Sorry, I couldn't manage to release 1.1.5 last week, will ship it either tomorrow or Sunday.
Bugs creator.
Features destroyer.
Template killer.