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.
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
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.
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!:)
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 !
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!
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.
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.
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?
+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
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.
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 :)
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.
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.
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.
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!!
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.
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?
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.
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?
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?
You have to open Apache and MySQL in hte XAMPP Control Panel. Then go in your Browser and type "localhost:1234/phpmyadmin" if you used the Port 1234 like in the video. If you dont changed the Port you can use "localhost:80/pypmyadmin" or just "localhost/phpmyadmin". The Port is showing in the row of Apache in the XAMPP Control Panel in the Column "Port(s)" at first place. I hope this will help you.
I need help here! i feel confuced do i need to go into settings and change things to let this program work for me in windows 10? i 5:17 at the video it doest not work for me to write the commands in my laptop i get a error i write everything right like-----> net user administrator * why does this not work for me?!
im totally new into programming its feel some confusing... should i skip the whole video? can i still run it as the program as admin? why did you change at the beginning port nummber ?
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
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
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.
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?
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
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!"
Thanks for the tutorial Derek. Please I need your help on 5:30 of the tutorial. When I type the 'net user administrator /active:yes', it says "System error 5 has occurred. Access denied. Can you help me please?
+Nkemdilim Eze Have you seen this social.technet.microsoft.com/Forums/windows/en-US/e6100404-773b-4dfc-b1a9-cb587af499ca/net-user-administrator-activeyes-access-denied?forum=w7itprosecurity
Hi Derek i follow your tutorial now i have a new adm acn and i still get the " You are not running with administrator rights! This will work for 3:31:29 PM [main] most application stuff but whenever you do something with services 3:31:29 PM [main] there will be a security dialogue or things will break! So think 3:31:29 PM [main] about running this application with administrator rights! " Can you help please?
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?
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
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.. :(
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.)"
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?
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 @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...
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.
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
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
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.
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
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 :(
Hey Derek, I am grateful you made this video. I do seem to have a problem tho, I can't open my edge browser. I keep getting an error message saying that "Microsoft Edge can't be opened using the built in administrator account" what should I do to rectify the issue and will I only be able to use the local server on the administrator account?
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
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!
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 :)
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
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
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
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
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
this is literally the most useful thing in my life
+Akshaya Dinesh Thank you :) I'm glad that I could help
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!
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.
You deserve an upvote so here it is, Thank you for the tutorial very meaningful and concise.
Thank you :) I'm glad it helped
Finally a video with some config info! Good stuff.
I'm glad it helped :)
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.
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 :)
The Master Derek at work!! Another awesome video
Thank you very much :)
Hi Derek, You make everything simple. Really nice tutorial.
+Amey Mhasawade Thank you :) I do my best
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!
Incredible explanation. Thank you very much. No fluff just details.
Thank you :) I'm glad you liked it
I thoroughly enjoyed following along with this video, man thanks for making this upload!!!
Thank you :) I'm glad it helped
my like set the like amounts to 2K, but seriously best tutorial, period
Thank you very much :)
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.
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
Thank you, you seriously helped me out. Very clear and thorough tutorial. Subbed!
I'm very happy that I could help :)
Mr Banas, Thank you very much!
Amazing job, very clear and concise instruction.
Great work man!
Thank you for the compliment :)
Just perfect & simple... Thanks for every efforts you make & keep the good work...
+Haythum A. Osman Thank you very much :) Your welcome
Excellent demo ... Thanks a lot Derek - you made my learning easy :)
You're very welcome :) I'm happy it helped
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 :)
Excellent tutorial. Helped me to setup XAMPP on my PC in no time. Thanks a lot.
Thank you :) I'm happy I could help
Derek a like isnt enough! Thanks Man!
I'm very happy that I could help :)
Amazing Video, very clear structured tutorial and explanation, saved me countless hours. Great Job :]
+PokeSteelProductions Thank you :) I'm glad it helped
Awesome! Excellent video with exactly what I was looking for. Thank you for this.
Thank you for the nice compliment :)
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
Piece of cake. Bloody brilliant!!!
+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.
Great video, a lot to see and learn. Looking forward to more tutorials.
Thank you :) I have almost 1000 that I hope you like
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!
Excellent tutorials! love the pace mainly, Super! thank you!
+Soup Spring Thank you very much :)
With this I can run WordPress locally, that's great.
+Poohbi e Yes you can. Wordpress is awesome as well.
Thanks so much I've been trying configure this for ages.
I'm happy I could help :)
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
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 :)
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.
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.
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.
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!!
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
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 :)
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
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
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
You're the best man!!. it helps a lot Thanks.
Thank you very much :)
Incredible! Couldn't have done it without you... JoY!
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.
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
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/
how did you get there at 8:27 ?
thanks
it doesn't work for me :(
what are to do???
You have to open Apache and MySQL in hte XAMPP Control Panel. Then go in your Browser and type "localhost:1234/phpmyadmin" if you used the Port 1234 like in the video. If you dont changed the Port you can use "localhost:80/pypmyadmin" or just "localhost/phpmyadmin".
The Port is showing in the row of Apache in the XAMPP Control Panel in the Column "Port(s)" at first place.
I hope this will help you.
I also found out, that you can click on the MySQL -> "Admin"-Button on the XAMPP Control Panel. This takes you to the page instantly.
You're the best!Thank you so much for the video.
Thank you :) I'm glad it helped
omg u saved my life !!! thaaaaank u soò soooo much ur the best
I'm very happy that it helped :)
I need help here! i feel confuced do i need to go into settings and change things to let this program work for me in windows 10? i 5:17 at the video it doest not work for me to write the commands in my laptop i get a error i write everything right like-----> net user administrator * why does this not work for me?!
You can skip the admin part. It isn't needed but I covered it unless people wanted to know how to do it
im totally new into programming its feel some confusing... should i skip the whole video? can i still run it as the program as admin? why did you change at the beginning port nummber ?
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
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
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
Best Video for this type of error
Thanks a lot...
I'm happy to hear it helped :)
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?
Started writing a comment about how I was missing something, realized I stored files in wrong directory. oof! Well played server... well played..
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.
Thanks so much! Works perfectly!
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
Thanks for the tutorial Derek. Please I need your help on 5:30 of the tutorial. When I type the 'net user administrator /active:yes', it says "System error 5 has occurred. Access denied. Can you help me please?
+Nkemdilim Eze Have you seen this social.technet.microsoft.com/Forums/windows/en-US/e6100404-773b-4dfc-b1a9-cb587af499ca/net-user-administrator-activeyes-access-denied?forum=w7itprosecurity
+Derek Banas Thanks for the link. That really helped.
Thank you, it help me a lot to install and configure the xampp.
I'm happy I could help :)
Hi Derek i follow your tutorial now i have a new adm acn and i still get the
" You are not running with administrator rights! This will work for
3:31:29 PM [main] most application stuff but whenever you do something with services
3:31:29 PM [main] there will be a security dialogue or things will break! So think
3:31:29 PM [main] about running this application with administrator rights! "
Can you help please?
I wouldn't worry about it. You don't need admin rights to use Xampp. I only covered that for people that were doing very high level things
Derek Banas Oh ok im a student i thought it might be a problem for my pc security.Thnx for the help.
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...
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.
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.. :(
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;
@ 11:53, I cant seem to find the connect in the MySQL folder. Please help
You have to create it
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
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
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.
hi Derek when i'm in databases i have red cross saying No Privileges what have i missed
cheers
@derek banas I'm also stuck here, please help
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.
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?
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
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
WHat if we didnt got any errors from the start should we still do the changes?
If you didn't have the errors ignore the extra stuff
I am good until 11:16...can you explain how you save a word pad file as .php and which browser you were using to write the subline text, thank you
I don't think you can use Wordpad to save PHP files. Use NotePad++, Sublime Text, Atom instead and that will clear up your problem
thank you very much Derek.
So at 7:11, when it tells me to go to FilterAdministratorToken and change the value to 1, I wasn't able to locate the file itself.
Feel free to skip that part. It isn't needed for Xampp to work. It is just something people asked me to cover
Ok, thank you :-)
when I tried to create a database at 9:53 it stood: #1044 - access denied for user "@'localhost' to database '1'
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
hey Derek how does one log out from command prompt which key to type in?
I don't know if I'm understanding your question. You can just close the window. If you are in mysql type quit
thx this one solved. but I can't seem to find Filter Administrator Token in Internet Explorer.
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 :(
Thank you. Great tutorial.
+Keffelew Assefa You're very welcome :)
Hey Derek, I am grateful you made this video. I do seem to have a problem tho, I can't open my edge browser. I keep getting an error message saying that "Microsoft Edge can't be opened using the built in administrator account" what should I do to rectify the issue and will I only be able to use the local server on the administrator account?
Thank you :) You don't need to be logged in as admin to use Xampp. Sorry if I didn't explain that better
Thanks for your reply. Is there a way i can have my server online?
hey Derek.
after restarting Windows in which account I log in?
administrator or my account?
Your regular account
Help me a lot!! Thank you man!!
Thank you :) I'm happy you liked it
Great tutorial. Thanks a lot :)
Thank you very much :)