Simple query to get count of all tables in database, as real data:

SET @tableSchema = 'my_schema';
SET SESSION group_concat_max_len = 10000000;
SET @rowCounts = (
  SELECT group_concat(CONCAT('SELECT ''',TABLE_NAME,''', COUNT(*) FROM ', TABLE_NAME) SEPARATOR ' union all ')
  FROM information_schema.tables WHERE table_schema = @tableSchema
);
PREPARE statement FROM @rowCounts;
EXECUTE statement;

-- don't run dealloc until you've exported your results ;)
DEALLOCATE PREPARE statement;

It is also possible to use:

SELECT 
    TABLE_NAME, 
    TABLE_ROWS 
FROM 
    `information_schema`.`tables` 
WHERE 
    `table_schema` = 'YOUR_DB_NAME';

but it gives only estimates

https://www.linuxbabe.com/linux-server/install-apache-mariadb-and-php7-lamp-stack-on-ubuntu-16-04-lts

https://www.howtoforge.com/tutorial/install-apache-with-php-and-mysql-on-ubuntu-16-04-lamp/

https://httpd.apache.org/docs/current/vhosts/examples.html

apt-get install php-redis

apt-get install php-xdebug

php7.0-curl

sudo apt install php7.0-sqlite3

sudo apt-get install php7.0-soap

sudo apt install nautilus-admin

sudo apt-get install openssl

sudo apt-get install oracle-java8-installer

sudo apt install percona-toolkit

sudo apt-get install percona-server-server-5.7

sudo pear install PHP_CodeSniffer

sudo pear install PHP_CodeSniffer

sudo apt install phpcs

https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html

https://ubuntuforums.org/showthread.php?t=2275033

http://unix.stackexchange.com/questions/85973/how-to-edit-var-www-files-using-phpstorm

https://ubuntuforums.org/showthread.php?t=2275033

http://tomaszdziurko.pl/2015/11/1-and-the-only-one-to-customize-intellij-idea-memory-settings/

http://symfony.com/doc/current/setup.html

https://getcomposer.org/doc/00-intro.md#globally

phpmyadmin configuration to quicky login to phpmyadmin as mysql root user, use this only for development server which is not publicly available

copy config.sample.inc.php to config.inc.php

change configuration options at the beginning to:

/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

// do not group tables
$cfg['NavigationTreeEnableGrouping'] = false;