Sat. Dec 7th, 2019

Host your Website

Read and learn

FatCow Web Hosting $1.00/mo* Trust your web hosting to the #1 web host provider, GoDaddy!

Install Full Webserver (Apache, PHP, MySQL, phpMyAdmin) | macOS

1 min read



[Updated Tutorial] https://youtu.be/hVHFPzjp064

Let’s see how to install a Full Webserver with Apache, PHP, MySQL and phpMyAdmin on macOS!

— Steps:
– sudo apachectl start
– sudo nano /etc/apache2/httpd.conf
– remove # before #LoadModule php5…
– sudo apachectl restart
– sudo nano /etc/apache2/httpd.conf
– Add index.php in DirectoryIndex line
– sudo apachectl restart
– sudo nano /Library/WebServer/Documents/index.php
– add the code seen on the screen
– download Mysql: https://dev.mysql.com/downloads/
– SAVE YOUR PASSWORD!
– sudo mkdir /var/mysql
– sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
– Start mysql Server
– cd /usr/local/mysql/bin
– sudo ./mysql -u root -p
– Alter user ’root’@‘localhost’ identified by ‘newpassword’;
– Download phpmyadmin: https://www.phpmyadmin.net
– Copy paste it into Documents folder and rename to phpMyAdmin
– cd /Library/Webserver/Documents/
– cd phpMyAdmin
– sudo mkdir config
– sudo chmod o+x config
– open localhost/phpmyadmin
– Under Authentication, enter mysql password
– Download Config
– Copy/Paste config into config folder
– Enjoy

— More Tutorials At —
https://www.sts-tutorial.com

25 thoughts on “Install Full Webserver (Apache, PHP, MySQL, phpMyAdmin) | macOS

  1. thanks man, helpful video, but for the future if anybody will have [caching_sha2_password] issue,
    follow these steps (for mac):
    1.Sign into mysql using a terminal program:
    2. sudo ./mysql -u root -p
    3. my_password(macpass)
    4. type mysql password
    5.alter user 'username'@'localhost' identified with mysql_native_password by 'password';
    6.exit

  2. my CPU is going crazy and my battery is draining quickly after having done this. In activity monitor it says that myphp is at 80% at least. Thoughts as to why its taking up so much of my CPU, should it be? Great video though.

  3. Thanks for the tutorial. FYI The command "Alter user ’root’@‘localhost' identified by ‘newpassword’;" is incorrect in the description. It is missing a quotation at the end of localhost

  4. while log in it shows following error

     mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

     mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

  5. I have follow the step all work. but when I try to log in to mySQL, the password not working. what should I do ?
    mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

  6. Thanks for taking the time to make this very helpful tutorial, however, there is an inconsistency with this video… You're using Mysql Version 5.7.17 and this video was published on Dec 4th, 2018 which is pretty recent… the current Mysql version is 8.0.17, and the current PHP version is 7.1.23. I'm not sure how long ago this video was made before you publish it. Could you please upload a new tutorial that's adapted to newer version of both PHP and Mysql? I tried exactly as you showed in the video but now, even the "It works" page doesn't work when I launch "localhost"… I tried using different browsers and deleted the browsers histories and caches several time but no luck.

Comments are closed.

Copyright © All rights reserved. | Newsphere by AF themes.