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.
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!!
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!:)
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 !
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.
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.
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.
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!
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.
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?
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.
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?
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.
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.
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.
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 ?
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
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?
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 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?
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?
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
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?
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.
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 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.
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 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?
at 11:17, when i type the sql command and press go, it displays me the following line, "MySQL returned an empty result set (i.e. zero rows). (Query took 0.0000 seconds.)"
Hi Derek, 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
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!
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?
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.
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?
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.
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!
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.
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
***** if you right click on the window where the administrator file should be,you will get an option named "new" then you can create your own DWORD REG named "FilterAdministratorToken" and then you can modify its value to 0 like the video :)
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
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?
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.
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
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.
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?
How to modify the same program to display the data on a webpage where data entered at the late is diplayed first (just as we have comments).Please help ASAP
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
Challenges with xampp control after ports have updated. I have started and restarted windows and signed back in as administrator. When I open the xampp control panel apache and mysql still have red "x". I get messages that appache and msyql are running in the ports assigned. But I am not able to sign in to localhost because of MS Edge error.
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.
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?
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!
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...
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 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.
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
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
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!!
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
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.
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
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
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
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.
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
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!
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.
The Master Derek at work!! Another awesome video
Thank you very much :)
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
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.
You deserve an upvote so here it is, Thank you for the tutorial very meaningful and concise.
Thank you :) I'm glad it helped
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/
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.
Hi Derek, You make everything simple. Really nice tutorial.
+Amey Mhasawade Thank you :) I do my best
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.
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.
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.
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 ?
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 :)
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
when I tried to create a database at 9:53 it stood: #1044 - access denied for user "@'localhost' to database '1'
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 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?
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 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
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
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.
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
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.
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 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
my like set the like amounts to 2K, but seriously best tutorial, period
Thank you very much :)
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!
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
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.
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;
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
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!
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 :-)
on 9:37 when i jump back, it wants some login with password?! i went through this step by step , but happened again :( help please
always this response: #1045 - Access denied for user 'root'@'localhost' (using password: YES)
@ 11:53, I cant seem to find the connect in the MySQL folder. Please help
You have to create it
Thank you, you seriously helped me out. Very clear and thorough tutorial. Subbed!
I'm very happy that I could help :)
I thoroughly enjoyed following along with this video, man thanks for making this upload!!!
Thank you :) I'm glad it helped
i m having a problem with creating a new database. the myphpadmin page does not show a button to create a new database...
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?
Incredible explanation. Thank you very much. No fluff just details.
Thank you :) I'm glad you liked it
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.
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...
im having all types of errors logging into sql or connecting to database with php code... any advice
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.
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.
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!
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.
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.
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
Excellent demo ... Thanks a lot Derek - you made my learning easy :)
You're very welcome :) I'm happy it helped
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
Just perfect & simple... Thanks for every efforts you make & keep the good work...
+Haythum A. Osman Thank you very much :) Your welcome
I can't seem to find FileAdministratorToken when I'm on Registry Editor
+Meshal Alawwad i have the same problem.did yous solve it?
+khadiza kobra me too... everything's going right with the tutorial until that file administrator is missing
***** if you right click on the window where the administrator file should be,you will get an option named "new" then you can create your own DWORD REG named "FilterAdministratorToken" and then you can modify its value to 0 like the video :)
khadiza kobra thanks
Hi rere, did khadiza's fix work for you?
Derek a like isnt enough! Thanks Man!
I'm very happy that I could help :)
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
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.
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?
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.
First of all, thanks for the nice tuorial. Unfortunately there are a 2 things I have problems with. 1. I can't find "FilterAdministratorToken" in regedit, it simply is not listed.2. In command prompt I get a message that says " The user name could not be found. " (???)I was wondering if you could tell me what to do abut those 2 issues? I find your tutorial very clear and easy to follow though, I just didn't succeed in doing these 2 things
+Mathijs Pluijmen Create the token if it doesn't exist. Make sure the username you are using is under accounts
Okay thank you much, I will try that
Hi Derek 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.
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
hey Derek.
after restarting Windows in which account I log in?
administrator or my account?
Your regular account
How to modify the same program to display the data on a webpage where data entered at the late is diplayed first (just as we have comments).Please help ASAP
Sorry, but I don't understand the question
I think he means ascending and descending? Maybe?
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 😊
Mr Banas, Thank you very much!
Amazing job, very clear and concise instruction.
Great work man!
Thank you for the compliment :)
why whenever i try to go in phpmyadmin to setup my sql user account there is an access denied. hope you can help me. thanks
would you kindly say how did you solve this problem:
#1044 - Access denied for user ''@'localhost' to database 'web'
Great video, a lot to see and learn. Looking forward to more tutorials.
Thank you :) I have almost 1000 that I hope you like
Given a thumbs up, because of the new stuff that I didn't know of, like setting root password and other stuff on xampp
I'm glad I could help :)
Hello derek after setting xammp is it a must for me to be near internet access when i am coding
No you don't need the internet to use Xampp
what about accesing php myadmin using localhost?
That is on your computer
Thanks, i am also installing truecafe on my computer, which i use as the server and client, walk me through that
Challenges with xampp control after ports have updated. I have started and restarted windows and signed back in as administrator. When I open the xampp control panel apache and mysql still have red "x". I get messages that appache and msyql are running in the ports assigned. But I am not able to sign in to localhost because of MS Edge error.
What is the MS error you are getting?
so I dcan achieve a complete integration of xampp with wordpress like i know i can do with the wamp server?
+Steve Burrus Yes definitely
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.
Excellent tutorial. Helped me to setup XAMPP on my PC in no time. Thanks a lot.
Thank you :) I'm happy I could help
With this I can run WordPress locally, that's great.
+Poohbi e Yes you can. Wordpress is awesome as well.
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
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.
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...
for some reason i cant click on the Administrator account to log into, i just can log into my normal user account...any suggestions?
Started writing a comment about how I was missing something, realized I stored files in wrong directory. oof! Well played server... well played..