Hi Derek. I know almost all the subjects that you have created tutorial for, but still I like watching them. Your tutorials are excellent, short and straight to the point.
0:41 the way you are doing this is absolutely perfect , I sometimes have trouble with installs and like to see outcomes of what goes on. Thank you so much.
Hi Derek! I made it through the tutorial. Great stuff! I just noticed that you have TONS of tutorials saved as playlists. I'll be going through some of those as well. I'm particularly interested in installing WordPress on top of my new XAMPP installation. If you don't have a XAMPP/WordPress specific tutorial, you might want to consider making one. I'm trying to find some good ones here on RUclips, but none that I have found are nearly as clear, comprehensive and understandable as the way that you product yours. Keep up the great work! It is greatly appreciate by all of us learners.
Thank you for all the nice compliments :) I made a tutorial on how to install Wordpress on your localhost that should still work ruclips.net/video/kWHvdKGLg_c/видео.html
Hey Derek. Your tutorial helped me a lot. I got nothing to say, except THANK YOU ! I'm preparing a project for university and your job helped me very very much. Keep up the good job, smart boy !
It finally worked!! The mysqli_connect.php file must be outside the htdocs for the database to connect. Thanks Derek for all your awesome programming tutorials. I have learned a lot. Keep up the hard work!:)
Just got started with xampp and found you again! You are the guy who taught me Java! I noticed that you made a mistake on line 8 of getstudentinfo.php you added an s so die() became dies(). Other than than this was an awesome video!
8 лет назад+2
I'm not sure if it was mentioned in the video, but is there a reason why you changed the port number (and all the processes afterwards, in the configurations and all)? And also, are we obligated to do such changes (the ones you showed right after installing XAMPP and changing the configs) in order to work with PHP andf MySQL? And thirdly, which PHP platforms do you intend to cover sometime, and which one would you recommend for someone who wants to migrate into Web Development (I'm a Graphic Designer wanting to learn front-end and back-end web design and development)?
+Yahanan Rivière Everything I did in this tutorial was done to minimize issues on every operating system. I have tutorials on PHP, JavaScript, HTML, CSS and pretty much everything else. After you learn them you may be interested in a PHP framework like Laravel, but get very good at everything else first.
Thank you for creating this tutorial. I have a few points of (hopefully) constructive critique: - Your double cursor issue when the screen is zoomed in is still a thing that you should fix ASAP, a lot of your vedeos are affected by that - The error message about port 80 and 443 being used is most likely caused by Skype, and can be fixed by going to Skype's _Tools > Options... > Advanced > Connection_ then un-checking "Use port 80 and 443 for additional incoming connections", then restarting Skype. By doing this you don't have to change the numbers around and using just "localhost" in the browser without a port number will correctly send requests to the web server. - Running without administrator rights has never caused any interference in my workflow personally, I always ignored that message, and to this day I had no issues using XAMPP, no need to set up a whole another user account and mess with registry - The things you used SQL queries for would perhaps be easier to understand if you used phpMyAdmin's GUI to do it, sunce it has forms for both queries you ran - You wrote "OR dies('…" instead of "OR die('…" - Using a relative URL for the form's action (e.g. "/studentadded.php") is a lot easier to type and entering the wrong address is much less likely that way
+DJDavid98 Thank you very much for the input. I meant to set everything up so that I could cause the largest number of errors so that I could cover everything that could go wrong. I guess I didn't emphasize enough in the video that administrator writes where not needed as you said and that everything works without it.
Perfect tutorial as usual Derek! I hope you can do a tutorial about Laravel Framework, and/or the steps of deploying a PHP project using Git and SSH. That would be just amazing because you make things so easy to understand, and that's the key of a successful tutorial.
Anyone with the #2002 error, I may have a fix for you. This is what I did: C: > xampp > mysql > data Cut ib_logfile0 and ib_logfile1 and paste to another location. Then Open up Xampp Control Panel, go to services. Run the service that you setup in the MySQL setup. For example, "MySQL55". After this it should work, let me know if this works for you!
Derek i did what you said copy paste code but at the end i get"Object not found! The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again. If you think this is a server error, please contact the webmaster. Error 404"
I had this problem to what I did to fix was the addstudent, getstudent and student added not in httd.docs. Mysql_connect should only be in xampp outside the docs.
9:08:45 AM [main] Initializing Control Panel 9:08:45 AM [main] Windows Version: Home 64-bit 9:08:45 AM [main] XAMPP Version: 5.6.30 9:08:45 AM [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ] 9:08:45 AM [main] You are not running with administrator rights! This will work for 9:08:45 AM [main] most application stuff but whenever you do something with services 9:08:45 AM [main] there will be a security dialogue or things will break! So think 9:08:45 AM [main] about running this application with administrator rights! 9:08:45 AM [main] XAMPP Installation Directory: "f:\software\installed\xampp\" 9:08:45 AM [main] Checking for prerequisites 9:08:45 AM [main] All prerequisites found 9:08:45 AM [main] Initializing Modules 9:08:45 AM [mysql] XAMPP MySQL Service is already running on port 3306 9:08:45 AM [filezilla] XAMPP FileZilla is already running on port 21 9:08:45 AM [filezilla] XAMPP FileZilla is already running on port 14147 9:08:45 AM [Tomcat] Java is already running on port 8005! 9:08:45 AM [Tomcat] Is Tomcat already running? 9:08:45 AM [Tomcat] Java is already running on port 8080! 9:08:45 AM [Tomcat] Is Tomcat already running? 9:08:45 AM [Tomcat] Java is already running on port 8009! 9:08:45 AM [Tomcat] Is Tomcat already running? 9:08:45 AM [main] Starting Check-Timer 9:08:45 AM [main] Control Panel Ready 9:08:56 AM [Apache] Attempting to start Apache service... 9:09:08 AM [mysql] Attempting to stop MySQL service... 9:09:15 AM [mysql] Status change detected: stopped 9:09:17 AM [mysql] Attempting to start MySQL service... 9:09:21 AM [mysql] Status change detected: running 9:09:23 AM [Apache] Attempting to start Apache service... now the problem is gone but Attempting to start Apache service... and it never starts.. :(
Hello derek....Happy new year Bro...I am still looking forward to the C# tutorial....part 2..Love the Videos..Just when i try to learn something new...your channel always keeps me up hours on end...0_0 thanks again...
+Derek Banas - What i want to know Derek..is how do you know so many programming languages? I am just a padewon learner....dude you are a JEDI....LOL...0_0...when you do the video for c#...it would be nice to linq and windows forms...thanks again
+barnebyboy I have been programming for 30 years. I'm not that smart, I have just been doing this stuff for forever. When I get to C# I'll definitely cover it in detail.
+Derek Banas - Dude that is so cool...me i have been playing around with source code for about 14 years...never released anything...lately i have been hungry....My current project concerns artificial intellignence using the AForge DLL set...now if you ever do a video series on this....man i am all in...after these years derek..put up a patreon link...we got ya...0_0
+barnebyboy I'd love to make some AI tutorials. I have to fulfill my promises first though and cover the MEAN stack and games next. I have thought about Patreon since RUclips recently nuked my earnings, but I'm holding back for now. Thank you for thinking that my videos are worth money :)
Phpmyadmin is asking me to login with my username and password after I changed 'cookie' and my passoword... What's my username? I don't remember setting one up... So what do I do now?
Is there a way to change password. I dont remeber my password. I tried changing in config.inc to username='root' password = ' ' , I also changed the auth_type back to config even then I am getting login screen asking for password. not sure how to solve this please help.
Personally I wouldn’t use localhost and port number on the action attribute of the form otherwise when you come to upload your site these details won’t match the web server. I don’t think it’s good practice changing port numbers either as most web servers will use the default. Better to keep all files in htdocs too and keep your file directory contained in that. That way when you upload your site everything will point to the correct location. This guy is very knowledgeable and a great teacher, I think this particular video is made far more complex than it has to be, 99% of the time Xampp just works and no configuration is needed.
Hello Mr.Derek, how can I fix this: Error: MySQL shutdown unexpectedly. 7:32:13 AM [mysql] This may be due to a blocked port, missing dependencies, 7:32:13 AM [mysql] improper privileges, a crash, or a shutdown by another method. 7:32:13 AM [mysql] Press the Logs button to view error logs and check 7:32:13 AM [mysql] the Windows Event Viewer for more clues 7:32:13 AM [mysql] If you need more help, copy and post this 7:32:13 AM [mysql] entire log window on the forums
Good . Although he misses out on achieving a seamless transition between parts. For example at 12:25, what program is he using , as he just launches into it without telling which one he launched. Also, very fast speaking style that is very low to hear. Please slow it down and get somebody with not much knowledge on the subject to crituque the presentation style and content.
I have tried to get XAMPP working on my desktop many times, almost getting to the point of surrender! You have done an outstanding job with this tutorial. It has to be far and away the best tutorial I have ever attempted to use!!!!!!! Do you have a site where all your work is available?
Hi Derek, First of all I thank you for this excellent very informative video. The information is provided is excellent and to the point. I followed your step by step instructions till I got stuck at "Registration Editor". While going Microsoft--->Windows--->System---> I could not find "Filter Administration Token". All the information except this could be found. In view of this, my Microsoft Edge is not opening when I click Apache or PHP to Start. I shall appreciate your prompt response.
+Derek Banas, I figured it out!! Okay so I started over and did everything again all the way to the point where im logged in as administrator trying to have that error in xampp control about not having rights go away. Well followimg every step exactly through and it still did not allow me to have administrator rights. Id admit at first I was sad, but then I right clicked on xampp control panel and clicked on (run as administrator) and it worked!! I dont know why it didnt work in the first place once I logged in as administrator and tried opening it then. But hey this was another way I guess gor haveing administrator rights! Thank you for replying back, you do an awesome job with tutorials and I will continue to watch them and will recommend people to watch your videos only because they really helped me. Thanks again, Keldrick Brown
thank you Derek once again, can I ask, should we not be changing back the User Account Control Settings after we have installed XAMPP, or is it wise to leave it the way it is where if an app changed something, you will never be notified of it?
8:15 the moment you can see it's the MariaDB and not MySQL. We need to go back Morty. The may 7th 2013 xampp-win32-5.5.28-0-VC11-installer still has MySQL DB
When I try opening the xampp control panel normally (not as an admin) the Service boxes in the first column are fine... But if I open the control panel as an administrator, red X's appear in the Apache and MySQL service boxes (like at 6:11).. But I restart the computer, and the red X's are still there.... If I click Admin beside mySQL, I get the error "The mysqli extension is missing. Please check your PHP configuration"... How do I fix this? Thank you for your time!!
I've done everything and doubled check that is shown in this video, still I get "Object not found! The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again. If you think this is a server error, please contact the webmaster. Error 404 localhost Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.24" I've read the comments for some guide still can't get it :(
"I on purpose set my system up to cause the most amount of errors so that I can hopefully catch every error that you could possibly get into... all right, so this is Windows 10..." BAHHAHHA
Help! :( By the step: 10:42 - it says: SHOW PLUGIN LIKE '%PASSWORD_CHECK%' CANNOT READ FOLDER: 'c:\XAMPP\MYSQL\LIB\PLUGIN\' FAILCODE: 2 " no such file or directory"
Okay so you are going to want to follow these steps, what worked for me was i went into xampp>mysql, created "lib" folder, went into "lib" folder and created "plugin" folder and tried creating a user again and now user creation works using phpmyadmin.
why can't you just right click the xampp control panel and hit "run this program as administrator"? This can even be done by default by messing with that program's compatibility settings. The only difference I am seeing is that I am getting X's by everything but Mercury. Is this OK?
Hey Derek, I hae a quick question, I know you stored the msqli_connect.php file in the xamp file, but did you put the other documents we created in the htdocs file or did you also save them outside? My getstudentinfo.php file is promoting a 404 not found response.
Hi Derek, I have been following your tutorial and making changes but just realized its for Windows 10 and I have Windows 7! Should I go back and remove the changes Ive made so far? Ive completed up to Filter Admin Token. I hope I havent messed things up! Thanks
HELP: At about 26:14 in the video I get 'system error 5 has occurred', and when I type in my fictitious user name I get the message, 'the user name could not be found'. Any assistance would be greatly appreciated.
Hey there Derek, happy new year from austria :D Is there a chance to see a video on PostgreSQL from you? Really enjoy your way of explaining things :) Cheers
This tutorial worked great for me but ended in a 404 error. When I would try to open the php files in my localhost browser I would receive a 404 error. I decided then to move the php files from the general xampp folder into the htdocs folder. Then the php files would show up on my browser localhost.
I copied the code from your link into the 4 php files and saved them in my xampp folder but whenever I go to do what you did at 25:30, I get a message that says the following: "Object not Found! The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again. If you think this is a server error, please contact the webmaster. Error 404 localhost Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.24" I'm not sure If I saved it wrong or what. Any idea on what the issue is?
6:45:31 AM [Apache] Apache Service detected with wrong path 6:45:31 AM [Apache] Change XAMPP Apache and Control Panel settings or 6:45:31 AM [Apache] Uninstall/disable the other service manually first 6:45:31 AM [Apache] Found Path: "F:\software\installed\xampp\apache\bin\httpd.exe" -k runservice 6:45:31 AM [Apache] Expected Path: "c:\xampp\apache\bin\httpd.exe" -k runservice 6:45:31 AM [Apache] Problem detected! 6:45:31 AM [Apache] Port 443 in use by ""C:\Program Files (x86)\VMware\VMware Workstation\vmware-hostd.exe" -u "C:\ProgramData\VMware\hostd\config.xml"" with PID 4588! 6:45:31 AM [Apache] Apache WILL NOT start without the configured ports free! 6:45:31 AM [Apache] You need to uninstall/disable/reconfigure the blocking application 6:45:31 AM [Apache] or reconfigure Apache and the Control Panel to listen on a different port 6:45:31 AM [mysql] MySQL Service detected with wrong path 6:45:31 AM [mysql] Change XAMPP MySQL and Control Panel settings or 6:45:31 AM [mysql] Uninstall/disable the other service manually first 6:45:31 AM [mysql] Found Path: F:\software\installed\xampp\mysql\bin\mysqld.exe --defaults-file=f:\software\installed\xampp\mysql\bin\my.ini mysql 6:45:31 AM [mysql] Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql
XX:XX:XX [Apache] Status change detected: running XX:XX:XX [Apache] Status change detected: stopped XX:XX:XX [Apache] Error: Apache shutdown unexpectedly. XX:XX:XX [Apache] This may be due to a blocked port, missing dependencies, XX:XX:XX [Apache] improper privileges, a crash, or a shutdown by another method. XX:XX:XX [Apache] Press the Logs button to view error logs and check XX:XX:XX [Apache] the Windows Event Viewer for more clues XX:XX:XX [Apache] If you need more help, copy and post this XX:XX:XX [Apache] entire log window on the forums
now the Found Path: "F:\software\installed\xampp\apache\bin\httpd.exe" -k runservice 6:45:31 AM [Apache] Expected Path: "c:\xampp\apache\bin\httpd.exe" -k runservice' i still there i uninstalled the previous still it showing...
Hey Derek, Had a question. Did you figure out all these installation steps yourself? I was clear concise and very well done I was just wondering how you know how to do this so well. Thanks again awesome tutorial
Hello Derek. Two Questions: 1.) Does this setup still work in 2018? 2.) Would this setup work for using MySQL with Node.js? I want to learn about Databases but don't want to learn PHP. And I also don't want to waste my time with MongoDB, since I've read that it's best days are behind it. Thanks in advance.
I'm at the time 10:52 in the video and I keep getting an error when I press go. The error is Error:#1046 No database selected and it says MySQL returned an empty result set (i.e. zero rows). (Querry took 0.0600 seconds.). I went back to see if I had done something wrong in a previous step but I still cant figure out how fix it.
At 3:12, it says to find 443 and replace it with 8181. The example shows that you changed it in the one spot, but there are other instances of 443 on that page. Do they all need to be changed to 8181?
8:30:26 PM [Apache] Error: Apache shutdown unexpectedly. 8:30:26 PM [Apache] This may be due to a blocked port, missing dependencies, 8:30:26 PM [Apache] improper privileges, a crash, or a shutdown by another method. 8:30:26 PM [Apache] Press the Logs button to view error logs and check 8:30:26 PM [Apache] the Windows Event Viewer for more clues 8:30:26 PM [Apache] If you need more help, copy and post this 8:30:26 PM [Apache] entire log window on the forums comes up when i try to start Apache? help please
Hi @Derek Banas, when are you going to upload the second part of the C# tutorial? You promised a second part of the "C# Tutorial in one video" if i'm not mistaken...
hey Derek, in the login it doesn't accept the new password but the old had.. why is that? and still have this attention message "You are not running with administrator rights! This will work for 4:02:56 PM [main] most application stuff but whenever you do something with services 4:02:56 PM [main] there will be a security dialogue or things will break! So think 4:02:56 PM [main] about running this application with administrator rights!"
Just a like a few others have in the past, I am having trouble at 11:00 to 11:20. I'm typing exactly what's in shown the field and yet I getting an error near GRANT and when I hit go I receive a "MySQL returned and empty result in zero lines" Do I really need to do all of these steps just test php and html programming for my programming class? Is there something simpler?
question: i have een syntax error by the sql GRANT INSERT, SELECT, DELETE, UPDATE ON databasename.* to 'user'@'localhost' IDENTIFIELD BY 'password'; Error is near GRANT
First of all, thanks for the nice tuorial. Unfortunately there are a 2 things I have problems with. 1. I can't find "FilterAdministratorToken" in regedit, it simply is not listed.2. In command prompt I get a message that says " The user name could not be found. " (???)I was wondering if you could tell me what to do abut those 2 issues? I find your tutorial very clear and easy to follow though, I just didn't succeed in doing these 2 things
I really like you videos, so usefull for a beginner like me =) Can I suggest you to make a video/lesson about dev environment using Vagrant and Docker ? Thanks anyway for the great content you give us !
at 11:17, when i type the sql command and press go, it displays me the following line, "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0000 seconds.)"
Hi, Derek, i am new to Xampp, as u described in video - i am able to set up the Xampp. Just i want to know, after successful installation of Xampp, can i delete Administrator account and can work with the previous account which i have created earlier?
Thanks for the tutorial very useful and straightforward, however I got stuck because in my computer there is not a Filter Administrator Token, maybe you have a work around it? Thanks.
+URAMA85 Your welcome :) You can either add it, or ignore it because admin rights are not needed for Xampp. It is just a common question so that is why I covered it.
Hi Derek, what do I do when I already have an admin account and want to setup appache, mysql and the rest of the stuff, do you have a video for that or should just delete my admin and start from scratch. Please let me know
Hi Derek. I know almost all the subjects that you have created tutorial for, but still I like watching them. Your tutorials are excellent, short and straight to the point.
+Amir Hesamian Thank you for the compliment :) I do my best to keep them interesting.
No need to create Administrator account, just close xampp-control and re-open it with right click, run as Administrator
Underated comment, thanks man x
do you still do the registry stuff?
tnx bro
any idea how to remove the admin account?
No need to.
Hi Derek. I'm engaged in building sites and now I'm studying php programming, your lesson helped me a lot. Thank you!
Thank you :) Best of luck with your work
0:41 the way you are doing this is absolutely perfect , I sometimes have trouble with installs and like to see outcomes of what goes on. Thank you so much.
I'm happy I could help :)
Hi Derek! I made it through the tutorial. Great stuff! I just noticed that you have TONS of tutorials saved as playlists. I'll be going through some of those as well. I'm particularly interested in installing WordPress on top of my new XAMPP installation. If you don't have a XAMPP/WordPress specific tutorial, you might want to consider making one. I'm trying to find some good ones here on RUclips, but none that I have found are nearly as clear, comprehensive and understandable as the way that you product yours. Keep up the great work! It is greatly appreciate by all of us learners.
Thank you for all the nice compliments :) I made a tutorial on how to install Wordpress on your localhost that should still work ruclips.net/video/kWHvdKGLg_c/видео.html
I'll be checking that out, along with your other Wordpress videos. Have a great weekend!
you know this is the best tutorial from thousand others i have seen, really step-by-step, thank you a lot
Thank you for the compliment :) I'm glad it helped
for me, you're the best tutor...you did everything... keep it up Mr. Derek
Thank you for the nice compliment :) Many more are coming
Dude you are genius. Simple tutorial, straight to the point
Thank you very much :) I'm glad it worked for you
Hey Derek.
Your tutorial helped me a lot.
I got nothing to say, except THANK YOU !
I'm preparing a project for university and your job helped me very very much.
Keep up the good job, smart boy !
You're very welcome :) Best of luck on your project
this is literally the most useful thing in my life
+Akshaya Dinesh Thank you :) I'm glad that I could help
It finally worked!! The mysqli_connect.php file must be outside the htdocs for the database to connect. Thanks Derek for all your awesome programming tutorials. I have learned a lot. Keep up the hard work!:)
Thank you for sharing that :) I'm very happy you liked the video
I have to say I am impressed with how many languages you mastered. Thank you for clearing so many doubts.
I'm happy I could help :) I've learned a lot as an old man
Thanks Derek! I really enjoy your videos and really appreciate how you cover common problems!
+David Moncada You're very welcome :) I just make videos based on the great requests everyone makes.
The Master Derek at work!! Another awesome video
Thank you very much :)
You deserve an upvote so here it is, Thank you for the tutorial very meaningful and concise.
Thank you :) I'm glad it helped
Always great to watch your videos Derek. I learn so much and your pacing, clarity and examples are awesome ... Thank you.
+Dave Robinson Thank you for the nice compliment :)
Finally a video with some config info! Good stuff.
I'm glad it helped :)
Hi Derek, You make everything simple. Really nice tutorial.
+Amey Mhasawade Thank you :) I do my best
Just got started with xampp and found you again! You are the guy who taught me Java! I noticed that you made a mistake on line 8 of getstudentinfo.php you added an s so die() became dies(). Other than than this was an awesome video!
I'm not sure if it was mentioned in the video, but is there a reason why you changed the port number (and all the processes afterwards, in the configurations and all)? And also, are we obligated to do such changes (the ones you showed right after installing XAMPP and changing the configs) in order to work with PHP andf MySQL? And thirdly, which PHP platforms do you intend to cover sometime, and which one would you recommend for someone who wants to migrate into Web Development (I'm a Graphic Designer wanting to learn front-end and back-end web design and development)?
+Yahanan Rivière Everything I did in this tutorial was done to minimize issues on every operating system. I have tutorials on PHP, JavaScript, HTML, CSS and pretty much everything else. After you learn them you may be interested in a PHP framework like Laravel, but get very good at everything else first.
Thank you for creating this tutorial. I have a few points of (hopefully) constructive critique:
- Your double cursor issue when the screen is zoomed in is still a thing that you should fix ASAP, a lot of your vedeos are affected by that
- The error message about port 80 and 443 being used is most likely caused by Skype, and can be fixed by going to Skype's _Tools > Options... > Advanced > Connection_ then un-checking "Use port 80 and 443 for additional incoming connections", then restarting Skype. By doing this you don't have to change the numbers around and using just "localhost" in the browser without a port number will correctly send requests to the web server.
- Running without administrator rights has never caused any interference in my workflow personally, I always ignored that message, and to this day I had no issues using XAMPP, no need to set up a whole another user account and mess with registry
- The things you used SQL queries for would perhaps be easier to understand if you used phpMyAdmin's GUI to do it, sunce it has forms for both queries you ran
- You wrote "OR dies('…" instead of "OR die('…"
- Using a relative URL for the form's action (e.g. "/studentadded.php") is a lot easier to type and entering the wrong address is much less likely that way
+DJDavid98 Thank you very much for the input. I meant to set everything up so that I could cause the largest number of errors so that I could cover everything that could go wrong. I guess I didn't emphasize enough in the video that administrator writes where not needed as you said and that everything works without it.
my like set the like amounts to 2K, but seriously best tutorial, period
Thank you very much :)
Thank you, you seriously helped me out. Very clear and thorough tutorial. Subbed!
I'm very happy that I could help :)
I thoroughly enjoyed following along with this video, man thanks for making this upload!!!
Thank you :) I'm glad it helped
Perfect tutorial as usual Derek!
I hope you can do a tutorial about Laravel Framework, and/or the steps of deploying a PHP project using Git and SSH.
That would be just amazing because you make things so easy to understand, and that's the key of a successful tutorial.
+TerryDx Thank you very much :) Laravel is in the works. I hope to upload it soon.
Perfect! I can't wait.
Thanks a ton!
Excellent demo ... Thanks a lot Derek - you made my learning easy :)
You're very welcome :) I'm happy it helped
Incredible explanation. Thank you very much. No fluff just details.
Thank you :) I'm glad you liked it
Mr Banas, Thank you very much!
Amazing job, very clear and concise instruction.
Great work man!
Thank you for the compliment :)
Anyone with the #2002 error, I may have a fix for you.
This is what I did:
C: > xampp > mysql > data
Cut ib_logfile0 and ib_logfile1 and paste to another location.
Then Open up Xampp Control Panel, go to services.
Run the service that you setup in the MySQL setup. For example, "MySQL55".
After this it should work, let me know if this works for you!
Derek a like isnt enough! Thanks Man!
I'm very happy that I could help :)
Excellent tutorial. Helped me to setup XAMPP on my PC in no time. Thanks a lot.
Thank you :) I'm happy I could help
Just perfect & simple... Thanks for every efforts you make & keep the good work...
+Haythum A. Osman Thank you very much :) Your welcome
Derek i did what you said copy paste code but at the end i get"Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404"
will you please share your solution for this problem
I had this problem to what I did to fix was the addstudent, getstudent and student added not in httd.docs. Mysql_connect should only be in xampp outside the docs.
Luke Gallagher you're awesome for that
Great video, a lot to see and learn. Looking forward to more tutorials.
Thank you :) I have almost 1000 that I hope you like
Given a thumbs up, because of the new stuff that I didn't know of, like setting root password and other stuff on xampp
I'm glad I could help :)
9:08:45 AM [main] Initializing Control Panel
9:08:45 AM [main] Windows Version: Home 64-bit
9:08:45 AM [main] XAMPP Version: 5.6.30
9:08:45 AM [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
9:08:45 AM [main] You are not running with administrator rights! This will work for
9:08:45 AM [main] most application stuff but whenever you do something with services
9:08:45 AM [main] there will be a security dialogue or things will break! So think
9:08:45 AM [main] about running this application with administrator rights!
9:08:45 AM [main] XAMPP Installation Directory: "f:\software\installed\xampp\"
9:08:45 AM [main] Checking for prerequisites
9:08:45 AM [main] All prerequisites found
9:08:45 AM [main] Initializing Modules
9:08:45 AM [mysql] XAMPP MySQL Service is already running on port 3306
9:08:45 AM [filezilla] XAMPP FileZilla is already running on port 21
9:08:45 AM [filezilla] XAMPP FileZilla is already running on port 14147
9:08:45 AM [Tomcat] Java is already running on port 8005!
9:08:45 AM [Tomcat] Is Tomcat already running?
9:08:45 AM [Tomcat] Java is already running on port 8080!
9:08:45 AM [Tomcat] Is Tomcat already running?
9:08:45 AM [Tomcat] Java is already running on port 8009!
9:08:45 AM [Tomcat] Is Tomcat already running?
9:08:45 AM [main] Starting Check-Timer
9:08:45 AM [main] Control Panel Ready
9:08:56 AM [Apache] Attempting to start Apache service...
9:09:08 AM [mysql] Attempting to stop MySQL service...
9:09:15 AM [mysql] Status change detected: stopped
9:09:17 AM [mysql] Attempting to start MySQL service...
9:09:21 AM [mysql] Status change detected: running
9:09:23 AM [Apache] Attempting to start Apache service...
now the problem is gone but Attempting to start Apache service... and it never starts.. :(
Thanks so much I've been trying configure this for ages.
I'm happy I could help :)
Thanks a lot mate. I've been trying to get this working in over two months until I found you tutorial :)
Your welcome :) I'm happy it helped
Hello derek....Happy new year Bro...I am still looking forward to the C# tutorial....part 2..Love the Videos..Just when i try to learn something new...your channel always keeps me up hours on end...0_0 thanks again...
+barnebyboy Happy New Year! Sorry about the wait for the C# videos. I'm doing my best to cover the requests I get as soon as possible.
+Derek Banas - What i want to know Derek..is how do you know so many programming languages? I am just a padewon learner....dude you are a JEDI....LOL...0_0...when you do the video for c#...it would be nice to linq and windows forms...thanks again
+barnebyboy I have been programming for 30 years. I'm not that smart, I have just been doing this stuff for forever. When I get to C# I'll definitely cover it in detail.
+Derek Banas - Dude that is so cool...me i have been playing around with source code for about 14 years...never released anything...lately i have been hungry....My current project concerns artificial intellignence using the AForge DLL set...now if you ever do a video series on this....man i am all in...after these years derek..put up a patreon link...we got ya...0_0
+barnebyboy I'd love to make some AI tutorials. I have to fulfill my promises first though and cover the MEAN stack and games next. I have thought about Patreon since RUclips recently nuked my earnings, but I'm holding back for now. Thank you for thinking that my videos are worth money :)
Amazing Video, very clear structured tutorial and explanation, saved me countless hours. Great Job :]
+PokeSteelProductions Thank you :) I'm glad it helped
Phpmyadmin is asking me to login with my username and password after I changed 'cookie' and my passoword... What's my username? I don't remember setting one up... So what do I do now?
login with what did you set in config.inc file like username root password turtledove
Ah I see... I left my username as Root. Thank you.
Thanks, I had the same problem
Sorry - confused about this - what do you mean? I am using Root and the password in the config file and it's not letting me log in!
Is there a way to change password. I dont remeber my password. I tried changing in config.inc to username='root' password = ' ' , I also changed the auth_type back to config even then I am getting login screen asking for password. not sure how to solve this please help.
Excellent tutorials! love the pace mainly, Super! thank you!
+Soup Spring Thank you very much :)
Personally I wouldn’t use localhost and port number on the action attribute of the form otherwise when you come to upload your site these details won’t match the web server. I don’t think it’s good practice changing port numbers either as most web servers will use the default. Better to keep all files in htdocs too and keep your file directory contained in that. That way when you upload your site everything will point to the correct location. This guy is very knowledgeable and a great teacher, I think this particular video is made far more complex than it has to be, 99% of the time Xampp just works and no configuration is needed.
Awesome! Excellent video with exactly what I was looking for. Thank you for this.
Thank you for the nice compliment :)
Hello Mr.Derek, how can I fix this:
Error: MySQL shutdown unexpectedly.
7:32:13 AM [mysql] This may be due to a blocked port, missing dependencies,
7:32:13 AM [mysql] improper privileges, a crash, or a shutdown by another method.
7:32:13 AM [mysql] Press the Logs button to view error logs and check
7:32:13 AM [mysql] the Windows Event Viewer for more clues
7:32:13 AM [mysql] If you need more help, copy and post this
7:32:13 AM [mysql] entire log window on the forums
With this I can run WordPress locally, that's great.
+Poohbi e Yes you can. Wordpress is awesome as well.
Good . Although he misses out on achieving a seamless transition between parts. For example at 12:25, what program is he using , as he just launches into it without telling which one he launched. Also, very fast speaking style that is very low to hear.
Please slow it down and get somebody with not much knowledge on the subject to crituque the presentation style and content.
I have tried to get XAMPP working on my desktop many times, almost getting to the point of surrender! You have done an outstanding job with this tutorial. It has to be far and away the best tutorial I have ever attempted to use!!!!!!!
Do you have a site where all your work is available?
Thank you :) I'm happy I helped. Yes my website is newthinktank.com
Hi Derek,
First of all I thank you for this excellent very informative video. The information is provided is excellent and to the point. I followed your step by step instructions till I got stuck at "Registration Editor". While going Microsoft--->Windows--->System---> I could not find "Filter Administration Token". All the information except this could be found. In view of this, my Microsoft Edge is not opening when I click Apache or PHP to Start. I shall appreciate your prompt response.
+Derek Banas, I figured it out!! Okay so I started over and did everything again all the way to the point where im logged in as administrator trying to have that error in xampp control about not having rights go away. Well followimg every step exactly through and it still did not allow me to have administrator rights. Id admit at first I was sad, but then I right clicked on xampp control panel and clicked on (run as administrator) and it worked!! I dont know why it didnt work in the first place once I logged in as administrator and tried opening it then. But hey this was another way I guess gor haveing administrator rights! Thank you for replying back, you do an awesome job with tutorials and I will continue to watch them and will recommend people to watch your videos only because they really helped me.
Thanks again,
Keldrick Brown
+Keldrick Brown Thank you very much for taking the time to help out others. I greatly appreciate that. I'm glad I could help.
thank you Derek once again, can I ask, should we not be changing back the User Account Control Settings after we have installed XAMPP, or is it wise to leave it the way it is where if an app changed something, you will never be notified of it?
man man! Derek, you are just awesome! thanks alot for ur understandable video
Thank you very much :) I'm happy I could help
Help me i dont found the listen 12.34.56.78:1234
8:15 the moment you can see it's the MariaDB and not MySQL. We need to go back Morty. The may 7th 2013 xampp-win32-5.5.28-0-VC11-installer still has MySQL DB
When I try opening the xampp control panel normally (not as an admin) the Service boxes in the first column are fine... But if I open the control panel as an administrator, red X's appear in the Apache and MySQL service boxes (like at 6:11).. But I restart the computer, and the red X's are still there.... If I click Admin beside mySQL, I get the error "The mysqli extension is missing. Please check your PHP configuration"... How do I fix this? Thank you for your time!!
I've done everything and doubled check that is shown in this video, still I get "Object not found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.24"
I've read the comments for some guide still can't get it :(
Started writing a comment about how I was missing something, realized I stored files in wrong directory. oof! Well played server... well played..
"I on purpose set my system up to cause the most amount of errors so that I can hopefully catch every error that you could possibly get into... all right, so this is Windows 10..." BAHHAHHA
Help! :(
By the step: 10:42
- it says:
SHOW PLUGIN LIKE '%PASSWORD_CHECK%'
CANNOT READ FOLDER: 'c:\XAMPP\MYSQL\LIB\PLUGIN\' FAILCODE: 2 " no such file or directory"
Hi!
Did you manage to solve this? I have exactly the same problem.
br
Hakan
Okay so you are going to want to follow these steps, what worked for me was i went into xampp>mysql, created "lib" folder, went into "lib" folder and created "plugin" folder and tried creating a user again and now user creation works using phpmyadmin.
I did the same thing and it worked for me too. I found this solution in a forum. It should work as general case i guess.
Thank you! Worked for me!
Thank You @Lorenzo...Thank You So Much....You are mY Hero...that work it to me
why can't you just right click the xampp control panel and hit "run this program as administrator"? This can even be done by default by messing with that program's compatibility settings.
The only difference I am seeing is that I am getting X's by everything but Mercury. Is this OK?
Yes you don't have to be admin
Hey Derek, I hae a quick question, I know you stored the msqli_connect.php file in the xamp file, but did you put the other documents we created in the htdocs file or did you also save them outside? My getstudentinfo.php file is promoting a 404 not found response.
Hi, Yes I store the other files in htdoc
Hi Derek, I have been following your tutorial and making changes but just realized its for Windows 10 and I have Windows 7! Should I go back and remove the changes Ive made so far? Ive completed up to Filter Admin Token. I hope I havent messed things up! Thanks
Hi Marion, Everything is the same for Windows 7, but you don't have to be admin for Xampp I just covered that because I was asked to
Thanks Derek fo this great videos,, more tutorial comes hopefully
Thank you :) I do my best to upload 3 a week
Very good tutorials.Thanks for your work.
+99Plus Thank you :) Your welcome
HELP: At about 26:14 in the video I get 'system error 5 has occurred', and when I type in my fictitious user name I get the message, 'the user name could not be found'. Any assistance would be greatly appreciated.
Thank you, it help me a lot to install and configure the xampp.
I'm happy I could help :)
Hey there Derek, happy new year from austria :D Is there a chance to see a video on PostgreSQL from you? Really enjoy your way of explaining things :)
Cheers
+Richard Alscher Happy New Year :) I'll see what I can do about PostgreSQL. Thank you for the request.
Piece of cake. Bloody brilliant!!!
This tutorial worked great for me but ended in a 404 error. When I would try to open the php files in my localhost browser I would receive a 404 error. I decided then to move the php files from the general xampp folder into the htdocs folder. Then the php files would show up on my browser localhost.
Yes that is where they go. Sorry for not explaining that better
Can you add it as a note? It seems like very important information that you didn't mention in the video.
Part of learning is figuring out the error code, nice one.
@@derekbanas You should of mentioned that you idiot.
I copied the code from your link into the 4 php files and saved them in my xampp folder but whenever I go to do what you did at 25:30, I get a message that says the following:
"Object not Found!
The requested URL was not found on this server. If you entered the URL manually please check your spelling and try again.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/5.6.24"
I'm not sure If I saved it wrong or what. Any idea on what the issue is?
Try this stackoverflow.com/questions/21811684/localhost-info-php-is-showing-object-not-found-what-to-do
You're the best man!!. it helps a lot Thanks.
Thank you very much :)
Incredible! Couldn't have done it without you... JoY!
6:45:31 AM [Apache] Apache Service detected with wrong path
6:45:31 AM [Apache] Change XAMPP Apache and Control Panel settings or
6:45:31 AM [Apache] Uninstall/disable the other service manually first
6:45:31 AM [Apache] Found Path: "F:\software\installed\xampp\apache\bin\httpd.exe" -k runservice
6:45:31 AM [Apache] Expected Path: "c:\xampp\apache\bin\httpd.exe" -k runservice
6:45:31 AM [Apache] Problem detected!
6:45:31 AM [Apache] Port 443 in use by ""C:\Program Files (x86)\VMware\VMware Workstation\vmware-hostd.exe" -u "C:\ProgramData\VMware\hostd\config.xml"" with PID 4588!
6:45:31 AM [Apache] Apache WILL NOT start without the configured ports free!
6:45:31 AM [Apache] You need to uninstall/disable/reconfigure the blocking application
6:45:31 AM [Apache] or reconfigure Apache and the Control Panel to listen on a different port
6:45:31 AM [mysql] MySQL Service detected with wrong path
6:45:31 AM [mysql] Change XAMPP MySQL and Control Panel settings or
6:45:31 AM [mysql] Uninstall/disable the other service manually first
6:45:31 AM [mysql] Found Path: F:\software\installed\xampp\mysql\bin\mysqld.exe --defaults-file=f:\software\installed\xampp\mysql\bin\my.ini mysql
6:45:31 AM [mysql] Expected Path: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql
I used to see this then i follow you instruction and now it fixed
but my main problem remains
What is your main problem?
XX:XX:XX [Apache] Status change detected: running
XX:XX:XX [Apache] Status change detected: stopped
XX:XX:XX [Apache] Error: Apache shutdown unexpectedly.
XX:XX:XX [Apache] This may be due to a blocked port, missing dependencies,
XX:XX:XX [Apache] improper privileges, a crash, or a shutdown by another method.
XX:XX:XX [Apache] Press the Logs button to view error logs and check
XX:XX:XX [Apache] the Windows Event Viewer for more clues
XX:XX:XX [Apache] If you need more help, copy and post this
XX:XX:XX [Apache] entire log window on the forums
now the
Found Path: "F:\software\installed\xampp\apache\bin\httpd.exe" -k runservice
6:45:31 AM [Apache] Expected Path: "c:\xampp\apache\bin\httpd.exe" -k runservice'
i still there i uninstalled the previous still it showing...
omg u saved my life !!! thaaaaank u soò soooo much ur the best
I'm very happy that it helped :)
You should make a tutorial for Vagrant as well.
+Kavit Trivedi I'll see what I can do. Thank you for the request :)
Vagrant / Docker
Hey Derek,
Had a question. Did you figure out all these installation steps yourself? I was clear concise and very well done I was just wondering how you know how to do this so well. Thanks again awesome tutorial
Thank you :) I test everything in computer labs using multiple different types of machines and then note any issues and how to fix them.
Hello Derek. Two Questions:
1.) Does this setup still work in 2018?
2.) Would this setup work for using MySQL with Node.js?
I want to learn about Databases but don't want to learn PHP. And I also don't want to waste my time with MongoDB, since I've read that it's best days are behind it.
Thanks in advance.
Yes for both except you will also have to install NodeJS
You're the best!Thank you so much for the video.
Thank you :) I'm glad it helped
Best Video for this type of error
Thanks a lot...
I'm happy to hear it helped :)
I'm at the time 10:52 in the video and I keep getting an error when I press go. The error is Error:#1046 No database selected and it says MySQL returned an empty result set (i.e. zero rows). (Querry took 0.0600 seconds.). I went back to see if I had done something wrong in a previous step but I still cant figure out how fix it.
At 3:12, it says to find 443 and replace it with 8181. The example shows that you changed it in the one spot, but there are other instances of 443 on that page. Do they all need to be changed to 8181?
Only change what I showed
Thanks for Video Derek .I will try to use it to advance my understanding and learning here.👍📚🎓😀
I'm happy to have been of help :)
8:30:26 PM [Apache] Error: Apache shutdown unexpectedly.
8:30:26 PM [Apache] This may be due to a blocked port, missing dependencies,
8:30:26 PM [Apache] improper privileges, a crash, or a shutdown by another method.
8:30:26 PM [Apache] Press the Logs button to view error logs and check
8:30:26 PM [Apache] the Windows Event Viewer for more clues
8:30:26 PM [Apache] If you need more help, copy and post this
8:30:26 PM [Apache] entire log window on the forums
comes up when i try to start Apache? help please
+Andrew Butler It seems to be a Skype error stackoverflow.com/questions/18300377/xampp-apache-error-apache-shutdown-unexpectedly
Hi @Derek Banas, when are you going to upload the second part of the C# tutorial? You promised a second part of the "C# Tutorial in one video" if i'm not mistaken...
+Adrian - I'm working on a long form C# tutorial. Sorry about the wait. I'll get to it as soon as possible.
hey Derek, in the login it doesn't accept the new password but the old had.. why is that?
and still have this attention message "You are not running with administrator rights! This will work for
4:02:56 PM [main] most application stuff but whenever you do something with services
4:02:56 PM [main] there will be a security dialogue or things will break! So think
4:02:56 PM [main] about running this application with administrator rights!"
Sorry, but I'm not sure why the password isn't updating. You can ignore the admin error. Admin rights aren't needed for Xampp
great video! and what IDE are you use?
Thank you :) I'm using Sublime Text here
Do you teach php & mysql for absolute beginners?
Just a like a few others have in the past, I am having trouble at 11:00 to 11:20. I'm typing exactly what's in shown the field and yet I getting an error near GRANT and when I hit go I receive a "MySQL returned and empty result in zero lines" Do I really need to do all of these steps just test php and html programming for my programming class? Is there something simpler?
Try comparing your code to mine using diffnow.com. Here is my code www.newthinktank.com/2015/12/install-xampp/
question: i have een syntax error by the sql GRANT INSERT, SELECT, DELETE, UPDATE ON databasename.* to 'user'@'localhost' IDENTIFIELD BY 'password'; Error is near GRANT
+mauries Schmitz yeah me to
me too. did you find the solution for it?
First of all, thanks for the nice tuorial. Unfortunately there are a 2 things I have problems with. 1. I can't find "FilterAdministratorToken" in regedit, it simply is not listed.2. In command prompt I get a message that says " The user name could not be found. " (???)I was wondering if you could tell me what to do abut those 2 issues? I find your tutorial very clear and easy to follow though, I just didn't succeed in doing these 2 things
+Mathijs Pluijmen Create the token if it doesn't exist. Make sure the username you are using is under accounts
Okay thank you much, I will try that
Hi Derek, Awesome as always ! I hope you do a P.D.O in one video
Thanks In Advance !
Thank you :) I'll cover PDO before I cover Laravel hopefully very soon.
I really like you videos, so usefull for a beginner like me =)
Can I suggest you to make a video/lesson about dev environment using Vagrant and Docker ?
Thanks anyway for the great content you give us !
+Jacques Lefebvre Thank you :) I'll see what I can do. Thanks for the request
when I tried to create a database at 9:53 it stood: #1044 - access denied for user "@'localhost' to database '1'
at 11:17, when i type the sql command and press go, it displays me the following line, "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0000 seconds.)"
+MrARP96 Is there anything in the database? Type SELECT * FROM YourTable;
thanks a lots friend
you teached good
if you come to my college as a professor for programming language I will be take a first mark
Hi, Derek, i am new to Xampp, as u described in video - i am able to set up the Xampp. Just i want to know, after successful installation of Xampp, can i delete Administrator account and can work with the previous account which i have created earlier?
Yes you don't need the admin account for Xampp
Thank you Derek...
Interesting...thanks, and by the way, Do you know by any chance ActionScript 3.0?
+Simon Pete You're very welcome :) I used to use ActionScript a while ago. I can make a tutorial.
+Derek Banas That'd be great !
Will you make a video about the changes and new features on PHP7?
+edilsonrj I'll see what I can do. It is faster from what I've tested. I'm still working through the other changes.
Thanks for the tutorial very useful and straightforward, however I got stuck because in my computer there is not a Filter Administrator Token, maybe you have a work around it? Thanks.
+URAMA85 Your welcome :) You can either add it, or ignore it because admin rights are not needed for Xampp. It is just a common question so that is why I covered it.
Hi Derek, what do I do when I already have an admin account and want to setup appache, mysql and the rest of the stuff, do you have a video for that or should just delete my admin and start from scratch. Please let me know
You actually are not required to have an admin account at all. I just covered that because some people want to hide the xampp install from other users
I just was in properties of xampp-control and just clicked the checkbox "Run As Administrator" and it works lmao
It is great when things just work
yes it is
Thanks so much! Works perfectly!