Table 'mysql.host' doesn't exist

moskit's picture
Submitted by moskit on Tue, 04/25/2017 - 01:08 Pro Licensee

After clean installation I cannot login to MySQL via PHPmyAdmin.

Going to Webmin > MySQL Database Server > Host Permissions

Error is reported SQL select * from host order by host failed : Table 'mysql.host' doesn't exist

Webmin version 1.831 Virtualmin version 5.07 MySQL version 5.7.17

Status: 
Closed (fixed)

Comments

Submitted by andreychek on Tue, 04/25/2017 - 08:05

Howdy -- that's an odd problem you're seeing there! That table should be created by MySQL automatically whenever it is installed.

We can take some steps to look into that though.

What is the output of these commands:

ls -l /var/lib/mysql
dpkg -l 'mysql*'
mysql -V

moskit's picture
Submitted by moskit on Tue, 04/25/2017 - 15:48 Pro Licensee

Thank you for your support!

ls -l /var/lib/mysql

-rw-r----- 1 mysql mysql                      56 Apr 21 18:38 auto.cnf
-rw-r--r-- 1 root  root                        0 Apr 21 18:38 debian-5.7.flag
-rw-r----- 1 mysql mysql                     282 Apr 23 15:52 ib_buffer_pool
-rw-r----- 1 mysql mysql                12582912 Apr 23 15:53 ibdata1
-rw-r----- 1 mysql mysql                50331648 Apr 23 15:53 ib_logfile0
-rw-r----- 1 mysql mysql                50331648 Apr 21 18:38 ib_logfile1
-rw-r----- 1 mysql mysql                12582912 Apr 25 22:38 ibtmp1
drwxr-x--- 2 mysql mysql                    4096 Apr 21 18:38 mysql
drwxr-x--- 2 mysql mysql                    4096 Apr 21 18:38 performance_schema
drwxr-x--- 2 mysql mysql                   12288 Apr 21 18:38 sys

dpkg -l 'mysql*'

Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name                             Version               Architecture          Description
+++-================================-=====================-=====================-======================================================================
ii  mysql-client                     5.7.17-0ubuntu0.16.04 all                   MySQL database client (metapackage depending on the latest version)
un  mysql-client-5.5                 <none>                <none>                (no description available)
un  mysql-client-5.6                 <none>                <none>                (no description available)
ii  mysql-client-5.7                 5.7.17-0ubuntu0.16.04 amd64                 MySQL database client binaries
un  mysql-client-core-5.5            <none>                <none>                (no description available)
un  mysql-client-core-5.6            <none>                <none>                (no description available)
ii  mysql-client-core-5.7            5.7.17-0ubuntu0.16.04 amd64                 MySQL database core client binaries
ii  mysql-common                     5.7.17-0ubuntu0.16.04 all                   MySQL database common files, e.g. /etc/mysql/my.cnf
un  mysql-common-5.6                 <none>                <none>                (no description available)
ii  mysql-server                     5.7.17-0ubuntu0.16.04 all                   MySQL database server (metapackage depending on the latest version)
un  mysql-server-5.5                 <none>                <none>                (no description available)
un  mysql-server-5.6                 <none>                <none>                (no description available)
ii  mysql-server-5.7                 5.7.17-0ubuntu0.16.04 amd64                 MySQL database server binaries and system database setup
un  mysql-server-core-5.5            <none>                <none>                (no description available)
un  mysql-server-core-5.6            <none>                <none>                (no description available)
ii  mysql-server-core-5.7            5.7.17-0ubuntu0.16.04 amd64                 MySQL database server binaries

mysql -V mysql  Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using  EditLine wrapper

Submitted by JamieCameron on Tue, 04/25/2017 - 18:45

This is a known bug in Webmin, which will be fixed in the 1.840 release - basically, the mysql.host table no longer exists in MySQL 5.7.17+, and Webmin shouldn't be displaying a link to it anymore.

Submitted by JamieCameron on Tue, 04/25/2017 - 18:45

Status: Active » Fixed

Submitted by IssueBot on Tue, 05/09/2017 - 18:56

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.