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.
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.
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
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.
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.
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.
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 !
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.
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?
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?
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 :(
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!
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.
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!
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
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!!
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.
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.
Hi Derek I went through the steps and what just happened is that the xamp-control icon in the xampp file has been changed to an ini file. Any idea on what the problem might be?
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.
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 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...
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?
Do we have to do the steps with Windows if we can use the browser in administrator mode? Because I can connect to LOCALHOST but when I connect to LOCALHOST:1234/DASHBOARD It cant reach that page.
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?
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.
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?
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
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.
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
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?
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
Previously I set up xampp without changing any http port and I could type in localhost into my browser address and xampp dashboard would display fine. Followed your video and changed the default port 80 to 1234, but now I have to type in localhost:1234 to get my dashboard... Is there anyway that I can set this up without having to add in port :1234 each time?
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.
Hi Derek, Great tutorial! Thank You. I was wondering if its possible to copy an excisting Database to my localhost installation? the reason is that I would like to move an wordpress / woocommerce site to another webhost and at the same time change theme. Thank You in advance Br Anders
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?
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?
happy new uyear derek. listen I don't have, in the Registry, a "FilterAdministratorToken" in the Policies/System folder! is it somewhere else in the registry?
+Steve Burrus Happy New Year! You can create it, but you don't need to be logged in as admin to use Xampp. I just covered that unless people wanted to know how to do it.
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
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.
hey i find this video very helpful. Really thanks a lot! But i have a question when you at regridet and etc... and can not find "Filter adimistator Token" what can you do?
after doing all those tutorial, in the last part of your video am I suppose to log in the web on the administrator mode or back to the usual mode? cause when I open the web on the administrator mode and try to login into localhost:1234/addstudentinfo.php this is what I get: Unable to connect Firefox can’t establish a connection to the server at localhost:1234. The site could be temporarily unavailable or too busy. Try again in a few moments. If you are unable to load any pages, check your computer’s network connection. If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web. can anyone or Derek help me out? thanks.
Hi Derek please help: Welcome to phpMyAdmin Error MySQL said: Documentation #2002 - No connection could be made because the target machine actively refused it. - The server is not responding (or the local server's socket is not correctly configured). mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it. Connection for controluser as defined in your configuration failed. mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
Hi Derek, great tutorial but I'm having a problem executing the last part in the video. When I try and access any of the php files we created on localhost I keep getting 'Object Not Found' error. I have them saved in the main xampp folder. Any ideas? Love your website by the way!
+Derek Banas Thanks for the reply! No idea, its like I cant navigate to the level above C:/xampp/htdocs, to where these files are stored (C:/xampp/addstudent.php) Do I have to edit another config file to be able to access them perhaps? Edit>> I realised that you only saved mysqli_connect outside htdocs and the other php files inside of the directory. Missed that part in the video. Thanks for your help
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
derek do you knw much about the wamp server? I am haVING the most extreme problems with trying to install it. after I install it I get an internal error!
Hi Derek, I was watching your Install XAMMP tutorial hoping that it would help me figure out installation errors that I'm encountering with XAMMP 7.1.31, 7.2.21, and 7.3.8. I've never used XAMMP before, and I installed it to use it with Word Press but right off the bat, I'm finding these errors: 1. "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why." 2. MySQL error - #1932 - Table 'phpmyadmin.pma user config' doesn't exist in engine 3. mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO) Would you be able to update your XAMMP video to cover errors such as the one I'm getting?
I keep getting the error message "Parse error: syntax error, unexpected '$query' (T_VARIABLE) in C:\xampp\htdocs\getstudentinfo.php on line 6" I tried copying your code as is but can't find the issue.
Hi, I am unable to find under hkey_local_machine, policies, system, "FilterAdministrationToken" @ 7.12. This step prevents me from getting localhost to run in Microsoft Edge. Any help appreciated.
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
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.
Ok it is a pretty old video but just it case someone is still watching the feed. How do I delete created administrator account? Standard procedure( delete user) doesn't work. That newly created administrator now cannot be deleted but my original can. Is there a specific command to undo new administrator? Help!
On my control panel it's showing "problem detected " Mercury not found" "disabling Mercury buttons" "Run this program for your XAMPP root directory" after completing up until command prompt in video.Why is that?
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!"
Can I install XAMPP into a different Disk? My laptop has gotten two internal disks, one SSD (Operation system is installed in it) and one HDD. So, can I install xampp in HDD ? (The path will not be "C:\Program Files(x86)\..."). I hope you understand what I want to say.
Hey Derek, I followed your tutorial except for doing the admin user and regedits because I didn't have such errors and show up in the console and when ever I try and go to localhost in the address bar it just constantly loads and never finishes, any idea why? This happens with WAMP as well and I'm following everything exactly as stated. UPDATE: Now it just gets to "Unable to Connect" page
Yes, when using localhost:1234/dashboard it just constantly loads, when I put just localhost it comes up with unable to connect. I changed the ports to 1234 and 8181 in the files like you explained.
Question. I am at the part where I am in Regedit. Once I get into System folder there is no FilterAdministratorToken. It goes right from EnableVirtualization to legalnoticecaption. What am I missing?
+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
Derek even tjhough I have now seen quite a few videos on how to i nstall both xampp and wordpress I am STILL not getting it right. and I also have about 3 past installations of xampp but every time I try to delete them I fail to do that. Can you please help me w. that xampp-wordpress integration?
+Steve Burrus I show how to install Wordpress on the localhost in this video ruclips.net/video/kWHvdKGLg_c/видео.html Tell me if you need any more help. What OS are you using?
+Derek Banas "What OS are you using?" The OS is si mply MS Wimndows 10. [ or is it "Windoze"? ] I will review your video on installing wordpress and tell ya what happens when I try to.
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....My registry did not have a FilterAdministratorToken inside there. So I went into the uipi and changed the default there to 0x00000001(1). But it isn't working. Any suggestions?
Thank you very much for this tutorial!!! Please may I know if you have posted the instructions anywhere so that I could read them. Thank you very much!
i tried ur method and error pops up: Warning: require_once(..lab4_13.php): failed to open stream: No such file or directory in C:\xampp\htdocs\getstudents.php on line 13 Fatal error: require_once(): Failed opening required '..lab4_13.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\getstudents.php on line 13 can u give me a reply man...
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 ?
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 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!
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 :)
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
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.
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
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'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.
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
this is literally the most useful thing in my life
+Akshaya Dinesh Thank you :) I'm glad that I could help
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.
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
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.
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
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?
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 :(
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!
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
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!
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
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!!
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.
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.
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
You deserve an upvote so here it is, Thank you for the tutorial very meaningful and concise.
Thank you :) I'm glad it helped
Hi Derek I went through the steps and what just happened is that the xamp-control icon in the xampp file has been changed to an ini file. Any idea on what the problem might be?
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!
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
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.
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
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 :)
Do we have to do the steps with Windows if we can use the browser in administrator mode? Because I can connect to LOCALHOST but when I connect to LOCALHOST:1234/DASHBOARD It cant reach that page.
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...
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.
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
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.
The Master Derek at work!! Another awesome video
Thank you very much :)
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
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?
Hi Derek, You make everything simple. Really nice tutorial.
+Amey Mhasawade Thank you :) I do my best
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
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?
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
Started writing a comment about how I was missing something, realized I stored files in wrong directory. oof! Well played server... well played..
Finally a video with some config info! Good stuff.
I'm glad it helped :)
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
Previously I set up xampp without changing any http port and I could type in localhost into my browser address and xampp dashboard would display fine. Followed your video and changed the default port 80 to 1234, but now I have to type in localhost:1234 to get my dashboard... Is there anyway that I can set this up without having to add in port :1234 each time?
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.
Hi Derek,
Great tutorial! Thank You.
I was wondering if its possible to copy an excisting Database to my localhost installation? the reason is that I would like to move an wordpress / woocommerce site to another webhost and at the same time change theme.
Thank You in advance
Br
Anders
Everything I cover here should still work ruclips.net/video/kWHvdKGLg_c/видео.html
Derek Banas thank you Derek for your quick reply. I'll have a look 😊
my like set the like amounts to 2K, but seriously best tutorial, period
Thank you very much :)
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/
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
happy new uyear derek. listen I don't have, in the Registry, a "FilterAdministratorToken" in the Policies/System folder! is it somewhere else in the registry?
+Steve Burrus Happy New Year! You can create it, but you don't need to be logged in as admin to use Xampp. I just covered that unless people wanted to know how to do it.
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 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.
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.
Thanks a lot for the video. Unfortunately the admin account gives me a bunch of issues. Any tips on how to remove it?
hey i find this video very helpful. Really thanks a lot!
But i have a question when you at regridet and etc... and can not find "Filter adimistator Token" what can you do?
+Elena Constantinou Thank you :) You can either add it, or skip it because admin privileges are not needed
after doing all those tutorial, in the last part of your video am I suppose to log in the web on the administrator mode or back to the usual mode? cause when I open the web on the administrator mode and try to login into localhost:1234/addstudentinfo.php this is what I get:
Unable to connect
Firefox can’t establish a connection to the server at localhost:1234.
The site could be temporarily unavailable or too busy. Try again in a few moments.
If you are unable to load any pages, check your computer’s network connection.
If your computer or network is protected by a firewall or proxy, make sure that Firefox is permitted to access the Web.
can anyone or Derek help me out? thanks.
Hi Derek please help:
Welcome to phpMyAdmin
Error
MySQL said: Documentation
#2002 - No connection could be made because the target machine actively refused it.
- The server is not responding (or the local server's socket is not correctly configured).
mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
Connection for controluser as defined in your configuration failed.
mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
Do you know how to install FIlezilla in the XAMPP control panel? I don't know how to open up Windows Server's NAT router.
hey Derek.
after restarting Windows in which account I log in?
administrator or my account?
Your regular account
Can you explain why you change some of the settings???
I have the Same Question. Switching to this from full stack JS(mostly MERN) it would be great to see the why
great video! and what IDE are you use?
Thank you :) I'm using Sublime Text here
Hi Derek, great tutorial but I'm having a problem executing the last part in the video. When I try and access any of the php files we created on localhost I keep getting 'Object Not Found' error. I have them saved in the main xampp folder. Any ideas? Love your website by the way!
+Brendan Ahern Thank you :) Do you know what lines of code are causing that error?
+Derek Banas Thanks for the reply! No idea, its like I cant navigate to the level above C:/xampp/htdocs, to where these files are stored (C:/xampp/addstudent.php) Do I have to edit another config file to be able to access them perhaps?
Edit>> I realised that you only saved mysqli_connect outside htdocs and the other php files inside of the directory. Missed that part in the video. Thanks for your help
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.
derek do you knw much about the wamp server? I am haVING the most extreme problems with trying to install it. after I install it I get an internal error!
+Steve Burrus Yes Wamp for some reason acts poorly on some systems. That is why I tell people to avoid it and use Xampp instead.
Derek, haven't watched the video yet. I use wamp. Is there a compelling reason to switch to xampp?
+wjrasmussen666 No they are very similar and the set up is pretty much the same.
Do you teach php & mysql for absolute beginners?
Hi Derek, I was watching your Install XAMMP tutorial hoping that it would help me figure out installation errors that I'm encountering with XAMMP 7.1.31, 7.2.21, and 7.3.8. I've never used XAMMP before, and I installed it to use it with Word Press but right off the bat, I'm finding these errors:
1. "The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why."
2. MySQL error - #1932 - Table 'phpmyadmin.pma user config' doesn't exist in engine
3. mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Would you be able to update your XAMMP video to cover errors such as the one I'm getting?
I keep getting the error message "Parse error: syntax error, unexpected '$query' (T_VARIABLE) in C:\xampp\htdocs\getstudentinfo.php on line 6"
I tried copying your code as is but can't find the issue.
Hi, I am unable to find under hkey_local_machine, policies, system, "FilterAdministrationToken" @ 7.12. This step prevents me from getting localhost to run in Microsoft Edge. Any help appreciated.
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
System error 5 has occured.
- this message was at the cmd when i type in net user administrator /active:yes
you probably didnt run cmd as administrator. right click it then click run as admin
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
Incredible explanation. Thank you very much. No fluff just details.
Thank you :) I'm glad you liked it
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.
Ok it is a pretty old video but just it case someone is still watching the feed. How do I delete created administrator account? Standard procedure( delete user) doesn't work. That newly created administrator now cannot be deleted but my original can. Is there a specific command to undo new administrator? Help!
On my control panel it's showing "problem detected " Mercury not found" "disabling Mercury buttons" "Run this program for your XAMPP root directory" after completing up until command prompt in video.Why is that?
i m having a problem with creating a new database. the myphpadmin page does not show a button to create a new database...
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
Can I install XAMPP into a different Disk? My laptop has gotten two internal disks, one SSD (Operation system is installed in it) and one HDD. So, can I install xampp in HDD ? (The path will not be "C:\Program Files(x86)\...").
I hope you understand what I want to say.
Yes you can install it in any drive
Derek Banas thank a lot for your reply 🙂
Hey Derek, I followed your tutorial except for doing the admin user and regedits because I didn't have such errors and show up in the console and when ever I try and go to localhost in the address bar it just constantly loads and never finishes, any idea why? This happens with WAMP as well and I'm following everything exactly as stated.
UPDATE: Now it just gets to "Unable to Connect" page
Are you using the port with localhost?
Yes, when using localhost:1234/dashboard it just constantly loads, when I put just localhost it comes up with unable to connect. I changed the ports to 1234 and 8181 in the files like you explained.
when I tried to create a database at 9:53 it stood: #1044 - access denied for user "@'localhost' to database '1'
Question. I am at the part where I am in Regedit. Once I get into System folder there is no FilterAdministratorToken. It goes right from EnableVirtualization to legalnoticecaption. What am I missing?
+Jason Pelberg Don't worry about it. You can add the value or ignore it. Admin isn't needed for Xampp
Thank you, you seriously helped me out. Very clear and thorough tutorial. Subbed!
I'm very happy that I could help :)
+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.
Derek even tjhough I have now seen quite a few videos on how to i nstall both xampp and wordpress I am STILL not getting it right. and I also have about 3 past installations of xampp but every time I try to delete them I fail to do that. Can you please help me w. that xampp-wordpress integration?
+Steve Burrus I show how to install Wordpress on the localhost in this video ruclips.net/video/kWHvdKGLg_c/видео.html Tell me if you need any more help. What OS are you using?
+Derek Banas "What OS are you using?" The OS is si mply MS Wimndows 10. [ or is it "Windoze"? ] I will review your video on installing wordpress and tell ya what happens when I try to.
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.
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 !
Derek, why had you changed the port number to 1234 and SSL port to 8181?
Because of a conflict
would you kindly say how did you solve this problem:
#1044 - Access denied for user ''@'localhost' to database 'web'
With this I can run WordPress locally, that's great.
+Poohbi e Yes you can. Wordpress is awesome as well.
Hi Derek....My registry did not have a FilterAdministratorToken inside there. So I went into the uipi and changed the default there to 0x00000001(1). But it isn't working. Any suggestions?
You actually don't need it for most everything you will normally do with Xampp. Try it without
Thank you very much for this tutorial!!! Please may I know if you have posted the instructions anywhere so that I could read them. Thank you very much!
+Susana Rodriguez You're very welcome :) I have some tips and code here www.newthinktank.com/2015/12/install-xampp/
i tried ur method and error pops up:
Warning: require_once(..lab4_13.php): failed to open stream: No such file or directory in C:\xampp\htdocs\getstudents.php on line 13
Fatal error: require_once(): Failed opening required '..lab4_13.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\getstudents.php on line 13
can u give me a reply man...
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 ?