02-05-2021

Brew Phpmyadmin



Preface

Brew updateでも当然updateが行われるのだが、パッケージををインストールするときにも毎回実行されるらしい。 $ brew install phpmyadmin Updating Homebrew. Auto-updated Homebrew! Updated 4 taps (homebrew/core, homebrew/php, homebrew/services, caskroom/cask). New Formulae #以下略. Nov 03, 2014 brew install phpmyadmin Configurations. Now, lets configure the installed components and make sure they work as expected. To make the services run at startup, provide. Also, initially we wanted to put PhpMyAdmin release.zip file (with same checksum, to ensure the checksums are same) to unpack that.zip directly upon plugin’s installation, but unfortunately WordPress.Org plugin team didn’t allow to put.zip file in the package (saying that SVN doesn’t like.zip files). Thus, we had to submit original. Mar 10, 2021 Even after removing 5.7 from brew, and doing all those steps from the article you linked, somehow mysql command was refusing to connect to mysql 5.6 service. What worked for me was removing both versions from brew (uninstalling them), like totally wiping mysql (both mysql and mysql56) from my system and then installing mysql 5.6 with brew.

This procedure explains how to install MySQL and MySQL Workbench using Homebrew on macOS. This is a fork of these instructions, to make them more concise and solve the issues reported here.

MySQL

To install MySQL enter :

  • brew install mysql
  • brew services start mysql
  • then run mysql_secure_installation and follow the instructions

MySQL Workbench

install via HomeBrew Cask: brew cask install mysqlworkbench

phpMyAdmin

  • install brew install phpmyadmin
  • edit /private/etc/apache2/httpd.conf file as sudo
  • add below code block at the end:

and make sure you have the line:

  • then sudo apachectl restart

Visual Studio Code connection:

  • Install MySQL plugin
  • run mysql - u <user> -p to enter mysql
  • run ALTER USER '<user>'@'<server>' IDENTIFIED WITH mysql_native_password BY '<password>';
  • if your password is not accepted:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

  • run SHOW VARIABLES LIKE 'validate_password%'; to see the password policies
  • run SET GLOBAL <Variable_name> = <New_Value>; to change

Python:

  • install pip3 install mysql-connector
  • run the blow code to test your Python connection:
Brew install phpmyadmin on mac

and using Pandas to run and fetch the results of MySQL queries:

Jupyter:

  • Install pip3 install ipython-sql
  • pip3 install mysqlclient
  • now you should be able to run these cells and get pretty-printed HTML output:
Brew Phpmyadmin

Description

Brew Phpmyadmin

[ ✅ 𝐒𝐄𝐂𝐔𝐑𝐄 𝐏𝐋𝐔𝐆𝐈𝐍𝐒 b𝓎 𝒫𝓊𝓋𝑜𝓍 ] :

• Revised for security to be reliable and free of vulnerability holes.
• Efficient, not to add any extra load/slowness to site.
• Don’t collect private data.

Plugin Description

The famous database browser & manager (for MySQL & MariaDB) – use it inside WordPress Dashboard without an extra hassle.

NOTES

  • PHP >= 7.1.3 is required to for phpMyAdmin latest version (otherwise you will have option to use older version of PMA, which is not encouraged for usage).
  • This plugin has been started from 2018 year, and we have no relations to the old age’s (from 3rd party scammers) vulnerable wp-phpMyAdmin plugin. This plugin is just a wrapper for official phpMyAdmin release and depends itself on the realiability & security of the phpMyAdmin itself. Also, initially we wanted to put PhpMyAdmin release .zip file (with same checksum, to ensure the checksums are same) to unpack that .zip directly upon plugin’s installation, but unfortunately WordPress.Org plugin team didn’t allow to put .zip file in the package (saying that SVN doesn’t like .zip files). Thus, we had to submit original PMA (extracted, untouched) to the repository.
  • For the reason to make it compact, some extra or unnecessary files (language files,GIS map, etc) are removed.

Liability

We are not official developers of PhpMyAdmin, neither affiliated with them. We just made this plugin as a container of PhpMyAdmin, so, people could use it in WP. This plugin uses official, unmodified (only whatever mentioned above) PhpMyAdmin package. However, we don’t control, check or revise the PhpMyAdmin package’s source code ot behavior itself, and thus, in overall, we take no responsibility about this plugin. Use it at your own responsibility. Only around 1% of users complained about this not to be working in any environment or causing any problems.

Brew Phpmyadmin Command

Available Options

See all available options and their description on plugin’s settings page.

Installation

Brew Uninstall Phpmyadmin

A) Enter your website “Admin Dashboard > Plugins > Add New” and enter the plugin name
or
B) Download plugin from WordPress.org , Extract the zip file and upload the container folder to “wp-content/plugins/”

Brew Phpmyadmin Nginx

Reviews