REAP WHAT YOU SOW
To import SQL file in XAMPP MySQL, first has to go to XAMPP MySQL bin then do the command standard Mysql import command line.
|
1 |
/Applications/XAMPP/bin |
|
1 |
./mysql -u <username> -p <database_name> < <sql_file> |
Example:
|
1 |
./mysql -u wanrazali -p property_price_trends < /Users/wanrazalimatsah/Downloads/Original/hd_postmeta.sql |
You can access XAMPP 8.2.4 MySQL via command line in MacOS by following these steps.
|
1 |
/Applications/XAMPP/xamppfiles/bin/ |
|
1 |
./mysql -u username -p |
If successful, XAMPP will connect to MariabDB instead of MySQL
You can double check by getting all databases in the MariaDB.
|
1 |
show databases; |
I installed XAMPP then after installation the XAMPP control manager appeared after that. If you restart your computer, I wonder where I can launch it because XAMPP is not appeared in LaunchPad.
Applications folder of XAMPP also has so many files.
Go to Applications -> XAMPP -> xamppfiles .
Then click on manager-osx.
Key in your password and then the XAMPP control manager will appear.
In my previous post, I was unable to install PHP & MySQL. This time after 2 years, I tried again but still fail, so I decided to use XAMPP to install PHP & MySQL and Apache on MacOS Ventura and it works!
But I had to disable default installed apache2 and change MySQL default port at XAMPP before MySQL and Apache2 can run on XAMPP.
Mount the xampp dmg and run it. If you face unknown publish then do Control + Click on the XAMPP installer then run it again.
Just follow the instructions.
If you unable to run the MySQL & Apache web server than follow below solution.
If you can run MySQL change it default ports. I use 3316 instead of default 3306.
I tried to stop mysql service but MacOS informed no MySQL service was running. Only by changing MySQL default port it works.
If you can’t run the apache2 server, stop default apache2 server by typing at the terminal.
|
1 |
sudo apachectl stop |
Then run again Apache Web Server at XAMPP.
If you can access phpMyAdmin and create table or user from phpMyAdmin then your XAMPP installation works!
