I am trying to install phpmyadmin on my Ubuntu 18.04/Nginx Server.

Because digital ocean does not yet have a guide for 18.04/Nginx/PHPMyAdmin yet I was using this one:

But after I follow all the steps I get the error below.

How can I fix this?

An error occurred while installing the database: 

mysql said: ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '********'' at line 1 . Your options are:
    * abort - Causes the operation to fail; you will need to downgrade,
      reinstall, reconfigure this package, or otherwise manually intervene
      to continue using it. This will usually also impact your ability to
      install other packages until the installation failure is resolved.
    * retry - Prompts once more with all the configuration questions
      (including ones you may have missed due to the debconf priority
      setting) and makes another attempt at performing the operation.
    * retry (skip questions) - Immediately attempts the operation again,
      skipping all questions. This is normally useful only if you have
      solved the underlying problem since the time the error occurred.
    * ignore - Continues the operation ignoring dbconfig-common errors.
      This will usually leave this package without a functional database.

   Next step for database installation:

                                                        retry (skip questions) 


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.

1 answer

If you already install mysql on your server, there is a simple way to install phpmyadmin on your server folder.
Steps to follow,

  1. Go to https://www.phpmyadmin.net/downloads/
  2. Copy the link of file you want to install
  3. Go to terminal and type “wget link ”. eg: “wget https://files.phpmyadmin.net/phpMyAdmin/4.8.3/phpMyAdmin-4.8.3-english.zip
  4. Unzip the archieve
  5. Rename the folder
  6. Access the folder via web browser and you are ready to go
Submit an Answer