Using PHPMyAdmin with WordPress Themes

237

WordPress Themes PHPMyAdmin – or PMA – is an excellent free, open source web-based database client which can be used to interact more easily with MySQL and WordPress databases. I’ll describe how to install it, secure it and some common scenarios with which it can assist you in WordPress administration. Here’s an online demo of PMAfor you to explore.

In addition to offering a visual GUI for database operations, I also appreciate being able to run command line SQL operations via my browser without having to log in to the server via SSH. For example, some WiFi and mobile connections regularly terminate persistent SSH sessions, making database tasks problematic.

Getting started with PMA is fairly straightforward on Linux. I’ll describe how to do so with Ubuntu 14.x at Digital Ocean. Log in to your server via SSH:

apt-get install phpmyadmin

You can use the default settings during installation or customize them to your liking.

On a typical WordPress installation, there aren’t any direct ports to MySQL for a hacker to try to access. They might try to break in via SSH or try SQL injection attacks against WordPress, but they can’t directly attack the database. Once you install PMA, anyone can run web-based attacks against it in order to gain control of your database, so care is warranted.

There are a few precautions I recommend when configuring PMA.

1. Use very strong passwords for all of your MySQL accounts, especially the root account. e.g. 25 characters for the root password.

2. Use different MySQL accounts and privileges for each WordPress site running on a single server. This way if one WordPress password is compromised, only one site’s database is compromised.

3. Change the default URL used by PMA. This way people can’t visithttp://yourblog.com/phpmyadmin. While this security by obscurity isn’t a very effective technique, it does add some protection.

Add an alias to the apache.conf file:

Reload apache:

service apache2 reload

Then, to access PMA, visit http://yourblog.com/myobscuredpma

If you need to modify your PHPMyAdmin password, you can edit the config-db.phphere:

nano /etc/phpmyadmin/config-db.php

4. Configure Web Authentication for the PMA Site. This will require that you enter an additional password to gain access to PMA, in addition to your database password, like this:

Apache User Access Restrictions

 

It’s very important to remember that PMA allows you to directly manipulate the WordPress database; that means it’s quite easy to break your WordPress site if you don’t know what you’re doing. It’s especially unwise to apply database scripts from the web unless you understand them completely. Use PMA with great care.

for more: http://code.tutsplus.com/tutorials/installing-and-using-phpmyadmin-with-wordpress–cms-21944

[quote font=”verdana” font_size=”14″ font_style=”italic” color=”#474747″ bgcolor=”#F5F5F5″ bcolor=”#dd9933″ arrow=”yes” align=”centre”]This Demo Content Brought to you by Momizat Team [/quote]

this is tags and keywords : wordpress themes momizat Tutorial wordpress templates

 

Compartilhar.

Autor

237 Comentários

  1. Pingback: dapoxetine cost

  2. Pingback: hydroxychloroquine 200mg side effects

  3. Pingback: availability of hydroxychloroquine over the counter

  4. Pingback: red ivermectil pills

  5. Pingback: priligy studies in usa

  6. Pingback: soolantra 6 for ascariasis infection

  7. Pingback: stromectol trihydrate 6 mg

  8. Pingback: stromectol and doxycycline together

  9. Pingback: deltasone price 20 mg

  10. Pingback: stromectol for toe infection

  11. Pingback: ivermectin human use

  12. Pingback: ivermectin scabies treatment

  13. Pingback: stromectol for water infection

  14. Здесь двенадцать рейтинговых
    сериалов для истинных ценителей романтических комедий.
    Чики смотреть онлайн сериал, сезон, все серии.
    Смотрите с удовольствием по рейтингу кинопоиска, Сериалы жанра “Триллер”.
    Ещё наш проект наш сайт список различных каналов
    Ю, HD Мега, 4K СТБ, прямой
    эфир Футбол 1, трансляция Дом кино.

  15. Вот шесть последних сериалов
    для истинных ценителей мистики.

    Тайсон Фьюри – Деонтей Уайлдер прямая трансляция.
    все сезоны, все серии. Выбирайте по рейтингу IMDB,
    Сериалы жанра “Детектив”.

    Опять же мы выдает реестр различных каналов СТБ, HD
    Новый канал, 4K Bollywood HD, прямой эфир ТНТ4, трансляция Россия 24.

  16. Для вас тринадцать с высоким рейтингом сериалов для подлинных любителей драмы.
    Бумажный дом 5 сезон 7 серия смотреть онлайн смотреть онлайн, сезон,
    сериала. Сортируйте по премьере, Сериалы жанра
    “Триллер”. Кроме того наш проект всегда готова предоставить программу
    телеканалов Че, HD Дом кино,
    4K Россия 24, прямой эфир ТЕТ, трансляция Киносерия.

  17. Вот тринадцать новых сериалов для фанатов ужасов.
    Смотреть сериал Полицейский с рублевки 6 сезон 2021 года все серии подряд в
    онлайн-кинотеатре TLfMj полностью без рекламы.
    Выбирайте по жанру, Сериалы жанра “Криминал”.
    Вдобавок мы выдает палитру различных каналов Bollywood HD, HD Euronews, 4K НТВ, прямой
    эфир Киномикс, трансляция Звезда.

  18. Pingback: antiparasitic tablets

  19. Pingback: dosing for ivermectin

  20. Pingback: ivermectin tablets cost

  21. Pingback: ivermectin for children

  22. Pingback: ivermectin pills cvs

  23. Pingback: where do i get viagra

  24. Pingback: cost of viagra 50mg

  25. Pingback: canadian pharmacy without prescription

  26. Pingback: hydroxychloroquine for sale india

  27. Pingback: can you buy viagra over the counter in mexico

  28. Pingback: over the counter stromectol for sale

  29. Pingback: over the counter viagra

Leave A Reply

X