Skip to main content
Topic: The MySQL user you have set in Settings.php does not have proper privileges. (Read 1615 times) previous topic - next topic
0 Members and 2 Guests 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.

QuoteUpgrading 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?
Last Edit: August 10, 2018, 12:28:37 pm by kucing
192.MY.ID: Forum ISP Indonesia.

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??
192.MY.ID: Forum ISP Indonesia.

 

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
Last Edit: August 10, 2018, 12:29:52 pm by kucing
192.MY.ID: Forum ISP Indonesia.


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.