As I was following this tutorial https://devanswers.co/install-secure-phpmyadmin-nginx-ubuntu-20-04/, in lack of a DO tutorial existing about installing phpmyadmin on Ubuntu 20.04 with a LEMP stack, I couldn’t get phpmyadmin to work. See:

https://www.donutnetwerk.nl/phpmyadmin

Anyone know where to start troubleshooting?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
2 answers

Hey @katovonkatz,

It seems you have set-up the phpmyadmin in different directory other than the one specified in your Apache root /your/path/to/application .

Could you post the Apache configuration and tell me where your phpmyadmin is setup?

You can also check /var/log/nginx/error.log and post the output.

Best,
Dennis

  • Ha @denislavgavrilov , thank you for thinking along.

    You mention Apache, but I haven’t installed Apache, only Nginx.

    The phpmyadmin file is located at /usr/share/phpmyadmin. The location from which the symbolic link is made is /var/www/html/phpmyadmin.

    The error log is huge. I will post only the last part:

    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "\"import\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_pos>
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "abilities\";a:57:{s:13:\"switch_themes\";b:1;s:11:\"edit_themes\";b:1;s:16:\"activate_plugins\";b:1;s:12:\"edit_plugins\";b:1;s:10:\"edit_users\";b:1;s>
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "";b:1;s:14:\"manage_options\";b:1;s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:6>
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "14:\"manage_options\";b:1;s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:6:\"impor>
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query SHOW FULL COLUMNS FROM `wp_options` gemaakt door wp_install, update_o>
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "ormal', 'yes') ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value` = VALUES(`option_value`), `autoload` = VALUES(`autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_users' doesn't exist bij query SELECT ID FROM wp_users WHERE user_nicename = 'shw' AND user_login != '>
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "p_install, wp_install_defaults, update_option, add_optionPHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: " wp_install, wp_install_defaults, update_option, add_optionPHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query SHOW FULL >
                    SELECT ID, post_name, post_parent, post_type
                    FROM wp_posts
                    WHERE post_name IN ('hallo-wereld')
                    AND post_type IN ('post','attachment')
             gemaakt door wp_install, wp_install_maybe_enable_pretty_permalinks, get_page_by_pathPHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query SHOW FULL COLUMNS FROM `wp_options` gemaakt doo>
    2020/09/29 06:59:32 [error] 82019#82019: *962 FastCGI sent in stderr: "PHP message: WordPress databasefout Table 'dn.wp_options' doesn't exist bij query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) >
    2020/09/29 07:19:37 [notice] 83094#83094: signal process started
    2020/09/29 09:44:56 [notice] 85973#85973: signal process started
    2020/09/29 12:03:29 [notice] 88045#88045: signal process started
    
    
    edited by bobbyiliev
    • Hi There,

      This is a mistake on my part. It doesn’t matter if you use NGINX or Apache - they are both WebServers. But please don’t install Apache as well! =)

      Okay, so what I can instantly notice is the following message:
      PHP message: WordPress databasefout Table ‘dn.wpoptions

      Just thinking out loud here. The problems seems to be that the query is wrong. It should be db.wpoptions or similar… the idea is, there isn’t a dn. in mysql. Unfortunately, I haven’t got this message. I will try googling around and get back to you in a while.

      Best,
      Dennis

Hi @katovonkatz,

You only need to follow step 2 & 3, not the entire tutorial, to set up your phpmyadmin. Could you try steps 2 & 3 and let me know how it went?

Best,
Dennis

  • I did this several times, without succes. At this point, I feel things have become very messy. I have decided for a total reboot op my VPS and start again. I will get back to you when I have reached this point and let you know what I think is the solution.

Submit an Answer