![]() The second prerequisite that must be fulfilled in order to start on this guide is to install a LAMP (Linux, Apache, MariaDB, and PHP) stack on your CentOS 7 server. Among other things, this will walk you through setting up a non-root user with sudo access for administrative commands. To ensure that you have a solid base to build this system upon, you should run through our initial server setup guide for CentOS 7. In this tutorial, we will walk through the steps necessary for installing and securing phpMyAdmin with Apache on CentOS 7 Prerequisitesīefore we begin, there are a few requirements that need to be settled. Privileges, execute SQL-statements, import and export data in a variety It is always better to install int outside document root and point using a separate virtual host.īelow virtual host could be a ref.PhpMyAdmin is an open source PHP based tool for managing MySQL and MariaDB servers over a web-based interface.Īllows you to interact with MySQL databases, manage user accounts and Please make sure to install epel using amazon linux extras sudo amazon-linux-extras install epel -yĪnd then install using yum install phpmyadminĪlternatively you could choose to install using composer composer create-project phpmyadmin/phpmyadmin Alias /phpMyAdmin /usr/share/phpMyAdminĮxample: Alias /pma /usr/share/phpMyAdmin In your browser you can now access at /phpmyadminĪs a side point, in the config file you edit if you wanted to change the address you can access phpmyadmin at, at the top you will see Alias lines, set them as you desire. If you want a quick copy and paste to get it working in 2017: sudo yum -enablerepo=epel install phpmyadminĮdit the httpd config file which was created by the phpmyadmin yum installation: sudo nano /etc/httpd/conf.d/nfĬomment out this section near the top of the file, it is restricting access to localhost (and you're connecting over the internet not locally): You don't need to do any of the sym linkage mentioned in other answers, the install makes an apache config file for the phpmyadmin installation automatically, you just need to remove the localhost security restriction, then restart httpd. ON mysql.tables_priv TO know this is an old question but it came up in Google and the above answer didn't do it for my freshly installed EC2 Linux (June 2017). ) ON er TO SELECT ON mysql.db TO SELECT ON mysql.host TO SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,Įxecute_priv, Repl_slave_priv, Repl_client_priv Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,Ĭreate_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,įile_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Ln -s /usr/share/phpmyadmin/ /var/www/html/phpmyadminĥ) Create permissions to MySQL if necessary (replace pmapass with your own password!) GRANT USAGE ON mysql.* TO IDENTIFIED BY 'pmapass' Sudo rpm -Uvh rpmforge-release-0.3.i386.rpmĤ) Install the application sudo yum install phpmyadmin I don't have permissions to comment, so as a separate answer.ġ) Check what LINUX you have rpm -q centos-releaseĢ) Check the correct rpm distribution release for you Here you can see a package list for the EPEL repo, too. There are two ways to use EPEL, one is above, the other is to activate it permanently, editing the file /etc//epel.repo and where it says enabled=0 we change it to enabled=1, now you can sudo yum install phpmyadmin. To make it available in your web root, you would have to symlink it thus: sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin Note, that this would install phpmyadmin in /usr/share/phpmyadmin. sudo yum -enablerepo=epel install phpmyadminĮDIT (comment by also should be noted that this comes with the advantage of uninstalling via The easy way is to activate it just to install the packages you want, like phpMyAdmin or MongoDB. ![]() Knowing that you have yum, the best way to act is to install it by yum. ![]() ![]() I know the question has more than one year, but was the first thing that popped up on google with "phpmyadmin ec2".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |