Tweaking the PhpMyAdmin (PMA)

And so, we just compiled a new server, installed the utility.

Now configure PhpMyAdmin for comfortable work with databases.

phpMyAdmin

1. Go to the root directory of our PMA and create the config folder with write permissions (chmod 777).

2. go to the configure script of our PMA https://192.168.1.50/pma/setup/. Click on the button to the new server. On the first tab, put a check use SSL. On the identity tab, select the type of http. On the Options tab of the server put the box Counting table.

Storage configuration. Here everywhere click on karandashik.

In a new tab without closing the configuration settings, go to our PMA for root https://192.168.1.50/pma/. Go to the database. Create database phpmyadmin. It appears in the list. Click Check privileges > = add new user.
Name — pma.
The host is local.
The Password Is Generated.
Copy this name and password in the configuration settings tab. Again we return to the user settings tab, click OK. Later on this page in the left column, choose the database phpmyadmin AB top menu on the SQL tab. Insert text from file scripts/create_tables.sql there, which is located in the folder with the PMA, click OK.

Phpmyadmin database table are created:
pma_bookmark
pma_column_info
pma_designer_coords
pma_history
pma_pdf_pages
pma_relation
pma_table_coords
pma_table_info
pma_tracking
pma_userconfig

After that, you can close this tab. Back to tab with configuration settings. Click Save.

Find ourselves again on the main settings page, where has our server. Select the default language, our server (localhost [1]). Next, click the Save button and Download. Save our configuration file to kompbter, and then upload it to the folder with PhpMyAdmin.

3. remove the created us, the folder config.

4. then go into phpmyadmin with a new authorization scheme. We have set our configuration file and go into the advanced settings. There is already a set view display. These settings will be stored in tables in phpmyadmin, we created.