[phpMyAdmin Developers] phpmyadmin database update

[Raghuram Vadapalli]

Hi Manish,

When you are dealing with configuration storage, you need to use
controluser link for database interface. Otherwise, it will use current
user to execute queries. Current user may not have permissions to even
access phpmyadmin database. You can do this by passing
$GLOBALS['controluser'] as parameter to any function operating with DBI. I
am assuming that you have set up controluser and similar parameters in
config.inc.php file. If it still doesn't work, please share the error you
are getting.

Regards,
Raghuram

On 17-Jul-2017 3:16 PM, "Manish Bisht" <manish.bisht490 at gmail.com> wrote:

How to use the phpmyadmin configuration database properly.

I am using the following code.

$GLOBALS['dbi']->selectDb('phpmyadmin');
$GLOBALS['dbi']->tryQuery('INSERT INTO `pma__progress` VALUES ("sas",
"sas", 50, 100)');

Let me know if I am correct or wrong. I think I am missing something.


Manish Bisht
Email : hi at manishbisht.me
Website : https://manishbisht.me


On Sat, Jul 15, 2017 at 5:07 PM, Manish Bisht <manish.bisht490 at gmail.com>
wrote:

> Thanks
>
> Just created the table by running import.
>
> How to save data in the tables by running queries from any file.
>
> Manish Bisht
> Email : hi at manishbisht.me
> Website : https://manishbisht.me
>
>
> On Sat, Jul 15, 2017 at 5:02 PM, Raghuram Vadapalli <
> raghuram.vadapalli at research.iiit.ac.in> wrote:
>
>> Hi,
>>
>> You have to run that sql file. Running it is part of installation process
>> as far as I know.
>>
>> Regards,
>> Raghuram
>>
>>
>> On 15-Jul-2017 4:38 PM, "Manish Bisht" <manish.bisht490 at gmail.com> wrote:
>>
>>> Hi,
>>>
>>> To store the import/export progress I have added one new table in
>>> sql/create_tables.sql file but I can't see my new table in the phpmyadmin
>>> database. How to update phpmyadmin database from that file. I guess there
>>> is something that do it automatically instead of manually executing the
>>> statement.
>>>
>>> Thanks,
>>>
>>> Manish Bisht
>>> Email : hi at manishbisht.me
>>> Website : https://manishbisht.me
>>>
>>>
>>> _______________________________________________
>>> Developers mailing list
>>> Developers at phpmyadmin.net
>>> https://lists.phpmyadmin.net/mailman/listinfo/developers
>>>
>>>
>> _______________________________________________
>> Developers mailing list
>> Developers at phpmyadmin.net
>> https://lists.phpmyadmin.net/mailman/listinfo/developers
>>
>>
>

_______________________________________________
Developers mailing list
Developers at phpmyadmin.net
https://lists.phpmyadmin.net/mailman/listinfo/developers
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.phpmyadmin.net/pipermail/developers/attachments/20170717/246d5fce/attachment.html>