# automatically generated from /etc/dbconfig-common/nf Then edit the dbpass parameter with the password you’ve just defined. Next, edit database configuration : nano /etc/phpmyadmin/config-db.php GRANT ALL ON phpmyadmin.* TO IDENTIFIED BY 'changethispassword' ĭo not forget to replace changethispassword with your own password. Next, issue following command : CREATE DATABASE phpmyadmin Then login to mysql as root using the password you’ve defined when you install MariaDB. If that what happens, follow these additional steps : However, in rare cases you may also end up with error message saying :ĮRROR 1045 (28000) : Access denied for user (using password : NO). Step 5 – Once finished, the phpMyAdmin should now been installed. ![]() You’ll then be asked once more to confirm the password. Step 4 – Now you have to define a password for phpmyadmin database. Step 3 – The installer will then ask you an option to use dbconfig-common to configure phpMyAdmin. Step 2 – Now install phpMyAdmin using this command : apt-get install phpmyadmin Step 1 – First thing and the most important part, you have to install complete LAMP stack on Ubuntu 16.04 including PHP7, MariaDB server and Apache2 webserver. In this guide I am using a 512MB RAM Cloud VPS from Atlantic running Ubuntu 16.04 圆4.ĭo not forget to always replace domain.tld with your own domain name and replace x.x.x.x with your server IP address. Quick recommendation: Digital Ocean, or Ramnode. A server or VPS with at least 256MB of RAM (OpenVZ) but 512MB is recommended if you are using KVM or Xen.Ĭonfused on choosing which VPS provider to setup an Apache based hosting server? Read my recommended VPS providers or this list of top low end cloud server providers.Basic knowledge about common Unix command to SSH to your server.A SSH client like Bitvise or Putty and basic knowledge about how to use it.In this article, you’ll see a proper method on how to install / setup world’s most popular MySQL management software, phpMyAdmin, on Ubuntu 16.04 server running Apache2, MariaDB and PHP7. ![]() However, some users may still be faced with common problem because the installation procedure has been done improperly. It means users can simply install those apps by simply using apt-get install command. This new Ubuntu server build has included PHP7, MariaDB, and phpMyAdmin in its repository. Bringing more awesomeness within its new version release, the Ubuntu 16.04 has been also available as ready-to-use template on many of Cloud Server providers including and Digital Ocean.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |