[PMA] error when I try to view sql table content

Quote from jonci

Theres is a client with ID 8. It has a database: 8_www and sql-user: 8_sqluser
IP address of SQL database: v.x.y.z (not localhost, an IP-address was set during the i-MSCP installation)

When I log into the PMA from the i-MSCP and I click an sql table inside the 8_www database to view the content of the table I get the following error:

Code

1. SQL-query:SELECT `prefs`FROM `{PMA_DATABASE}`.`pma__table_uiprefs`WHERE `username` = '8_sqlduser'AND `db_name` = '8_www'AND `table_name` = 'wp_options'Errror:#1142 - SELECT command denied to user 'pma'@'v.x.y.z' for table 'pma__table_uiprefs'

Code

1. /var/www/imscp/gui/public/tools/pma/config.inc.php:
2. $cfg['Servers'][$i]['pmadb'] = '{PMA_DATABASE}';

Is it correnct?

I think so, database of pma won't be set and created during the installation.

How can I fix it?

Display More

It's is possible to have a teamviewer session?

Quote from jonci

No, there is only command-line.

You cannot install teamviewer on your desktop computer? Anyway please open a ticket.

I have exactly the same issue.
Available for a teamviewer (but my adsl is not really performant)

Quote from VirtualCed

I have exactly the same issue.
Available for a teamviewer (but my adsl is not really performant)

Ok In that case, please, open a ticket. I'll try to reproduce and fix.

http://trac.i-mscp.net/ticket/905#ticket has been created.

Quote from VirtualCed

http://trac.i-mscp.net/ticket/905#ticket has been created.

Thanks.

jonci
VirtualCed

Please, can you give me the result of the following command:

I bet you are using the 1.1.0-rc3 version.

Should be fixed. See https://github.com/i-MSCP/phpm…5f347c7ecb71452fffd9db7f4

If you want get full feature, you must update to last master instead of simply updating PMA.