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: https://devanswers.co/installing-phpmyadmin-nginx-ubuntu-18-04/
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: abort retry retry (skip questions) ignore <Ok>
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.