How to setup Apache, MySql, and PHP on Ubuntu Linux 

+geeky_will awesome! Check my new series Working with Linux for an updated version and easier approach to local development

Awesome, I'm glad I was helpful. Cheers

Thank you very much for this explaination. Automation work very well and easely! Emmanuel

Cheers

Same here 👊

You're very welcome :D

Thank you so much for watching, I'm glad it helped :D

Awesome, I'm glad I was helpful. I just started a mini-series about Linux where I'm showing my full setup, from the terminal to the local environment, code editor, extensions, etc. I hope it'll be useful for you. Cheers

Thank you so much for watching :D

Well, now I know :D Thank you so much for watching

@@alecaddd You are most welcome. Thank you so much for taking the time to reply.

Thank you so much :D

`test.dev` does not work anymore, but testdev, localhost_2 do.

You're welcome

Thanks for watching :D

You're very welcome :D

Cheers

Happy to help

Cheers

Cheers

You're welcome

Thank you so much :D

Thank you so much

Hi George, thank you so much for watching. Yes, I'm aware of the ServerAlias, in fact, you can find it in the script I use for automating the process. I decided to keep the Vhost file really simple for the tutorial, just to avoid confusion and too much information for an already long video. Thanks for flagging that out!

I supposed you already know about it, and when I've wrote the comment was before seeing the script part oft the video :) But that should change in www. because if you use wordpress and you set it up on domain.com and then you will need to put it on www.domain.com... then you will discover that you will have more changes to do than to modify only the .htaccess file. (from my experience...) I will recommend using the www. as Alias. It is also a good practice. I am speaking as a guy which is more into servers than programming :) Keep up with the tutorials because I like them and I enjoy them. You are speaking clear about the thing to do and everything is so clear to understand, so in the name of me and others I say thank You! If I will reach America sometime... We will have a beer! :) Thumb up!

You're very very welcome :D

You can try using Valet Linux, it's more compact and easier solution. I have a video in my playlist Working with Linux, check that out :D

Check my playlist Switching to Linux where I showed my entire setup and how to install WordPress locally.

For this video on 32:27, I have a huge problem... IT doesnt allow me to get to package configuration to change new password for the MSQL "root" user.. Please help.

You're welcome 😁

I'm using OpenBroadCaster

Thank you :D

You could try using Valet Linux. I did a tutorial about it in the playlist Switching to Linux.

Thank you, I will check It.

Mhhh...I wouldn't recommend it. I mean, it works and I never had issues with it, but always be careful when using automated scripts on your production server. If you want to try it, do a backup first, and be sure your folders match where the virtualhost script will try to interact. And before all of that, test it on a staging server, or local server. I don't want to be responsible of the destruction of your production server :D

Thanks for watching :D

[RISOLTO] Ho cambiato il plugin del user 'root' da "auth_socket" a "mysql_native_password" mettendone una a mia scelta. Per fare ciò ho utilizzato il terminal (scrivo per quelli che si trovano nella mia situazione): 1) sudo mysql -u root -p 2) ho inserito 2 volte la password del account per accedere ad Ubuntu 3) alter user 'root'@'localhost' identified with mysql_native_password by 'password_a_scelta' Comunque ottimo tutorial !

Wow, I'm glad I got you at the right time :D I will do more and more videos about Linux to help users like you (and me) to get a professional workflow for both development and design. Cheers

this will be very appreciated. thank you

I already did :D Here's a tutorial using Valet Linux: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-l1ZX0ZLxRps.html&list=PLriKzYyLb28nRMNbet5iXM_UlE2ddok7k&index=9 Check also the rest of the playlist as I go through the steps of setting up all the most common tools for a developer. Cheers

It's google's fault :P Google made the .dev domain a TLD, or Top Level Domain, so now, without an SSL certificate (HTTPS connection) you can't access your local environment. You should be able to solve it by changing the extension, using something like .app, or .devel Cheers

You guessed right that I tried it by using the Chrome web browser. Mille grazie dalla Grecia, mio amico!

I tried to change the extension but nothing happened. I tried with Firefox but it does not work either. Am I right to assume that one would have to alter the "sites-enabled" folder to get around this problem? The website at jmcoimbra.github.io/LAMP-env/ seems to say that!

Same for me ! I've followed every steps of the video and I even changed the extension after having read the comment. But I have the same result :(

Did the jmcoimbra site work for anyone?

I'm actually running Nginx on my production servers, and I agree with you. I will definitely make a video on how to set it up and the differences with Apache.Thanks for the suggestion!

Yes. If it doesn't, you can also type "sudo systemctl enable apache2" to enable it on start of bootup.

Oh yes, that's a good point. DBeaver, like SeuquelPro, has the ability to connect to a remote database in SSH, that's why I decided to go that route instead of a web based MySql access. I've always wanted to play with a RaspberryPi but never got the chance. How is it? How do you use it, and why did you pick it? Cheers

I bought the RaspberryPi because I'll try to improve my Linux knowledge (primary for my new work) The Pi is simply connected via Cabel with my Router and I connect me via SSH with the pi. I also use samba to create a Windows Networkdrive (only to the /var/www folder). I'm also working with symfony3. :)

Sweet! I recently started using Symfony to build CLI apps on PHP, pretty handy.

I'm looking forward to see your new PRogramming Series :D

Use your default browser. Do not use other browsers like Opera

You're very welcome

+Thomas Sieber mhh, I'm not sure about that. Check one my recent Videos about Linux Valet. It's a new and way faster method to setup localhosts

thx for the quick response. you can disable old sites with a2dissite "sitename"

thats the same happend with me, you find the solution for this problem ?

@@zedolok4508 same with me. Please let me know of the solution

It's because the .dev domain is now automatically redirected in chrome (and now firefox I suppose) ma.ttias.be/chrome-force-dev-domains-https-via-preloaded-hsts/

Is your apache server running properly?

Hai provato il comando `mysql_secure_installation`? Dovrebbe darti la possibilità di inserire una nuova password.

@@alecaddd grazie per la dritta. Lo provo appena posso!

Thanks man!

Google acquired .dev domains and made them top level domains, so now if you don't have an SSL certificate, and consequentially HTTPS, you can't use .dev I'd suggest using Valet Linux or change your domain extension to .app or .local, or something else.

No, that isn't it. I tried .app and even .shit as top-level domain extensions and neither work. Thanks anyway!

Are you sure you can connect to your MySql via terminal, and the password you're using is correct? Is you Database up and running?

Alessandro Castellani yes i can see mysql status as running, but what password we have to put in it? in this we are setting password or putting password for access? and which password

Are you acting as root user? Can you edit it if you open it with sudo?

I think I am root user, I dont have sublime editor I have gedit, and I dont know how to open the file with sudo. I tried only without terminal.

That's a root file that needs to be opened with sudo from the terminal, or you can open a new instance of your file manager as administrator.

Ok, I will do so, what is the command to open the file?

I`ve tried to open the file in terminal (gedit etc/apache2/sites-available/test.dev.conf) ...same thing. i don`t know how can I open with sudo command.

Ahahaha, grazie mille :D

Non puoi mai esserne certo al 100% :P

Yes but i cannot find a way to fix it so i go back to ubunut server...

Yeah. I think .dev extension is the problem here. Try using something else like test.local or test.test or test.random it's working. Do let me know if you figure out how make .dev work.

@@avatsavirs test.local worked. Thanks

@@avatsavirs Thanks man it's also really worck for me.

without dot . works for me. example: testlocal