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". We will now add our Blowfish Secret! nano and copy the secure secret from.For the first issue all you have to do is grab your editor of choice and edit /usr/share/phpmyadmin/ but there's a problem, we removed it! That's ok, all you have to do is: cd /usr/share/phpmyadmin & cp. However, these issues are relatively easy to fix. phpMyAdmin is not able to cache templates and will be slow because of this. the configuration file now needs a secret passphrase (blowfish_secret). You might now notice two errors after you log into PMA. Now it's time to clean up: rm -rf phpMyAdmin-4.8.2-english.cp -r phpMyAdmin-4.8.2-english phpmyadmin. Lets use the cp (copy) command to move our files! Note that we have to add the -r argument since this is a folder.We just unzipped PMA, now we will move it to it's final home. For this next step you need unzip ( apt-get install unzip): unzip phpMyAdmin-4.8.2-english.zip.Let me explain the arguments of this command, -P defines the path and "the link.zip" is currently (7/17/18) the latest version of PMA. Now we need to download the latest PMA version onto our system (Note that you need wget: apt-get install wget): wget -P /usr/share/ "".Third, remove the phpmyadmin directory: rm -rf phpmyadmin.Next, cd into usr/share directory: cd /usr/share. ![]() Your first step is to install PMA (phpMyAdmin) from the official Ubuntu repo: apt-get install phpmyadmin.Larry pretty much hit the nail on the head! I am going to give an answer based on his that will be easy to understand and follow.
0 Comments
Leave a Reply. |