WARNING: Install JQ on your Mac before running the commands suggested on this section. Brew update brew install jq To check the required memory of your VM, open a terminal and run the command below. PostgreSQL (with PostGIS), MySQL (mostly with MyISAM engine), Oracle, and SQLite (with SpatiaLite) are the spatial databases currently supported. Note PostGIS is recommended, because it is the most mature and feature-rich open source spatial database.
- To do this, run brew services start mysql. By default, brew installs the MySQL database without a root password. To secure it run: mysqlsecureinstallation. To connect run: mysql -uroot. Root is the username name here.
- Automate MySQL backups: autopano-sift-c: 2.5.1: Find control points in overlapping image pairs: autopep8: 1.5.6: Automatically formats Python code to conform to the PEP 8 style guide: autopsy: 2.24: Graphical interface to Sleuth Kit investigation tools: autorest: 3.1.3: Swagger (OpenAPI) Specification code generator: autossh: 1.4g.
- Once '2' has been done, restart the MySQL service by entering service mysql restart or /etc/init.d/mysql restart. After going through the above steps, my issue was solved. I rarely have this issue, and there is probably a better way, so by all means provide constructive feedback if need be:).
In the default installation, XAMPP-VM has no passwords set and it is not recommended to run XAMPP-VM with this configuration accessible by others.To make the installation more secure:
Restart Mysql Mac Brew Manual
Restart Mysql Mac Brew Pub
- Launch the stack manager by double-clicking the XAMPP icon in the mounted disk image.
- Ensure that all services are running in the 'Services' tab of the stack manager (or start them as needed).
- Open a new terminal from the 'General' tab of the stack manager and run the following command in it:
tail -2 /opt/lampp/logs/error_log - You should see the following dialog on your screen. Enter responses to each prompt.
XAMPP: Quick security check...
XAMPP: MySQL is accessable via network.
XAMPP: Normaly that's not recommended. Do you want me to turn it off? [yes] yes
XAMPP: Turned off.
XAMPP: Stopping MySQL...
XAMPP: Starting MySQL...
XAMPP: The MySQL/phpMyAdmin user pma has no password set!!!
XAMPP: Do you want to set a password? [yes] yes
XAMPP: Password: ******
XAMPP: Password (again): ******
XAMPP: Setting new MySQL pma password.
XAMPP: Setting phpMyAdmin's pma password to the new one.
XAMPP: MySQL has no root passwort set!!!
XAMPP: Do you want to set a password? [yes] yes
XAMPP: Write the passworde somewhere down to make sure you won't forget it!!!
XAMPP: Password: ******
XAMPP: Password (again): ******
XAMPP: Setting new MySQL root password.
XAMPP: Setting phpMyAdmin's root password to the new one.
XAMPP: The FTP password for user 'nobody' is still set to 'lampp'.
XAMPP: Do you want to change the password? [yes] yes
XAMPP: Password: ******
XAMPP: Password (again): ******
XAMPP: Reload ProFTPD...
XAMPP: Done.
Restart Mysql Mac Brew Command
After calling this command, your XAMPP-VM installation should be more secure.