How to set a password for the root user in phpMyAdmin.
Жүктеу.....
Пікірлер: 53
@prageshkumar8907 Жыл бұрын
With the help of this video an error is solved which I was trying to solve since last 1 hour...Thank you!
@namintxx4 жыл бұрын
does this mean i have to set passwords for all the 'root' usernames? I set for only 1 of the root and big error occurred
@rahulhuilgol53045 жыл бұрын
Very helpful! Thank you!
@attran-bk3ie3 жыл бұрын
Thank you a lot. Very Very helpful!!
@sausage58495 жыл бұрын
Thank you Richard!
@wenwengalarpe1434410 ай бұрын
I love you sir keep teaching ❤
@UrQuietGamer2 жыл бұрын
Very helpful. Thank you.
@DreamSaphir6 жыл бұрын
Thank You !
@MinhLe-xk5rm7 жыл бұрын
Thank you. that was a great tutorial.
@DrRichardStibbard
7 жыл бұрын
You're most welcome, Cassandra.
@AjithRoyalz
Жыл бұрын
@@DrRichardStibbard how set first time the password
@DottiStudio3 жыл бұрын
omg thank you so much, you saved me!!!
@lattrellsapon5 жыл бұрын
Hi, how can I do this on a MAC OS?
@toma161011 ай бұрын
But you have 3 users called “root”. Do you keep same password for three of them?
@mavip775 жыл бұрын
thank you works for me!!!
@flosset96405 жыл бұрын
thank you so much
@jadeengineer3 жыл бұрын
Thank you sir
@forza4647 Жыл бұрын
thank you very much!!
@KamogeloSemenya8 жыл бұрын
thanks this was soo helpful
@DrRichardStibbard
8 жыл бұрын
+Kamogelo KayCee Semenya Glad ou found it useful!
@shivisaxena27982 жыл бұрын
I'm not getting option of edit privileges
@AdamBakerMTB3 жыл бұрын
This made life a lot easier
@KhushiVerma-wr7nf5 жыл бұрын
i didn't find password in config.inc.php file and i also lost the access to phpmyadmin
@JuanFlores-rj1he4 жыл бұрын
Gracias!
@VijayAlpha5 жыл бұрын
thank you
@YRLGROUP2 жыл бұрын
how to change username if i wish to change for mysql server ?
@zaspanyflegmatyk24464 жыл бұрын
thanks
@TechnologyLearningLive Жыл бұрын
Youtr a Lifesaver Thanks💦💔
@lisarkippen21822 жыл бұрын
Great. I just did that and now I am locked out.
@andriiauziak11786 жыл бұрын
Thanks man
@m8cul8r4 жыл бұрын
hi there, i followed exactly every single step that you show on the video, but when i go to change the password in the config.inc.php and i try to save it gives me an error: ***** This operation couldn't be completed, because an error occurred. The authenticated save for this file failed (application error code 20004) ***** , and then i try to refresh phpmyadmin i get another error and i am stacked. I already uninstalled and reinstalled XAMPP twice and now i am going to do it for the third time. This is the error i get when i try to reload the phpmyadmin after the changes in your video: mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) Any helps? Thanks.
@DrRichardStibbard
4 жыл бұрын
Try this: In the XAMPP control panel, stop Apache and MySQL Open C:\xampp\mysql\bin\my.ini in your editor. Find the line beginning [mysqld] Just under [mysqld], add a blank line and add 'skip-grant-tables' (without the quotes) Restart Apache and MySQL. Let me know if that works/doesn't work!
@stanislawunruh9082
4 жыл бұрын
Hello, it worked out for me, thx.
@xoxoo48775 жыл бұрын
thanks a looot
@lisarkippen21822 жыл бұрын
Can I access this some how and fix it?
@lisarkippen21822 жыл бұрын
I just built almost a completed site and now it's lost. I added a new site as well. But it is also gone
@lisarkippen21822 жыл бұрын
What if I have two databases
@lisarkippen21822 жыл бұрын
I cannot get back to my php admin screen.
@huseintaha2 жыл бұрын
i want create new user with password in phpmyadmin in page user account for phpmyadmin no button add user appear and this error raise --->You do not have the privileges to administrate the users! my xampp version 7.3.6 and i update myphpadmin to latest version
@lisarkippen21822 жыл бұрын
Ok, I only did this on one of the root files
@timi_t4 жыл бұрын
I am not able to edit the config.inc.php file, because I don't have the permission. Meanwhile, I can't get into myphpadmin either.
@realdvgarg
4 жыл бұрын
I followed his steps and when I reloaded I was brought to the login screen. I just entered root as my username and the new password that I set and it worked. I didn't change any file data or anything else.
@lisarkippen21822 жыл бұрын
Oh well. I guess every time I create a new site. I just get better and better.
@TechnologyLearningLive
Жыл бұрын
its a constant learning process and we should humble ourselves more then BOAST about how awesome we , im convinced yu can agree, and Im sure yu have alot of talent, One of the biggest lesson ive learned is to never for a minuie let my amaizng accomplishments,, and talents _ & or akills cloud my head... in my 20s i did that at my vey first big high profile tech jobs.. and i kept getting better and learned fast,, and then the $$ came, and then i caught myself.. having a private laugh with myself thinking i was smarter then the , next... that can really be detrimental if another human being felt that they were belittled .... & not alot of confidence or fear of JUST NOT BEING SMART ENUF LETS ..MAYBE TO BE A SOFTWARE Engineeet i think u get my point :) 💌💦
@sitinorfadzillahhidayatull62445 жыл бұрын
Why i dont have phpmyadmin
@flosset9640
5 жыл бұрын
you need to download it search download php my admin on google and also make sure to download xampp
Пікірлер: 53
With the help of this video an error is solved which I was trying to solve since last 1 hour...Thank you!
does this mean i have to set passwords for all the 'root' usernames? I set for only 1 of the root and big error occurred
Very helpful! Thank you!
Thank you a lot. Very Very helpful!!
Thank you Richard!
I love you sir keep teaching ❤
Very helpful. Thank you.
Thank You !
Thank you. that was a great tutorial.
@DrRichardStibbard
7 жыл бұрын
You're most welcome, Cassandra.
@AjithRoyalz
Жыл бұрын
@@DrRichardStibbard how set first time the password
omg thank you so much, you saved me!!!
Hi, how can I do this on a MAC OS?
But you have 3 users called “root”. Do you keep same password for three of them?
thank you works for me!!!
thank you so much
Thank you sir
thank you very much!!
thanks this was soo helpful
@DrRichardStibbard
8 жыл бұрын
+Kamogelo KayCee Semenya Glad ou found it useful!
I'm not getting option of edit privileges
This made life a lot easier
i didn't find password in config.inc.php file and i also lost the access to phpmyadmin
Gracias!
thank you
how to change username if i wish to change for mysql server ?
thanks
Youtr a Lifesaver Thanks💦💔
Great. I just did that and now I am locked out.
Thanks man
hi there, i followed exactly every single step that you show on the video, but when i go to change the password in the config.inc.php and i try to save it gives me an error: ***** This operation couldn't be completed, because an error occurred. The authenticated save for this file failed (application error code 20004) ***** , and then i try to refresh phpmyadmin i get another error and i am stacked. I already uninstalled and reinstalled XAMPP twice and now i am going to do it for the third time. This is the error i get when i try to reload the phpmyadmin after the changes in your video: mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) Any helps? Thanks.
@DrRichardStibbard
4 жыл бұрын
Try this: In the XAMPP control panel, stop Apache and MySQL Open C:\xampp\mysql\bin\my.ini in your editor. Find the line beginning [mysqld] Just under [mysqld], add a blank line and add 'skip-grant-tables' (without the quotes) Restart Apache and MySQL. Let me know if that works/doesn't work!
@stanislawunruh9082
4 жыл бұрын
Hello, it worked out for me, thx.
thanks a looot
Can I access this some how and fix it?
I just built almost a completed site and now it's lost. I added a new site as well. But it is also gone
What if I have two databases
I cannot get back to my php admin screen.
i want create new user with password in phpmyadmin in page user account for phpmyadmin no button add user appear and this error raise --->You do not have the privileges to administrate the users! my xampp version 7.3.6 and i update myphpadmin to latest version
Ok, I only did this on one of the root files
I am not able to edit the config.inc.php file, because I don't have the permission. Meanwhile, I can't get into myphpadmin either.
@realdvgarg
4 жыл бұрын
I followed his steps and when I reloaded I was brought to the login screen. I just entered root as my username and the new password that I set and it worked. I didn't change any file data or anything else.
Oh well. I guess every time I create a new site. I just get better and better.
@TechnologyLearningLive
Жыл бұрын
its a constant learning process and we should humble ourselves more then BOAST about how awesome we , im convinced yu can agree, and Im sure yu have alot of talent, One of the biggest lesson ive learned is to never for a minuie let my amaizng accomplishments,, and talents _ & or akills cloud my head... in my 20s i did that at my vey first big high profile tech jobs.. and i kept getting better and learned fast,, and then the $$ came, and then i caught myself.. having a private laugh with myself thinking i was smarter then the , next... that can really be detrimental if another human being felt that they were belittled .... & not alot of confidence or fear of JUST NOT BEING SMART ENUF LETS ..MAYBE TO BE A SOFTWARE Engineeet i think u get my point :) 💌💦
Why i dont have phpmyadmin
@flosset9640
5 жыл бұрын
you need to download it search download php my admin on google and also make sure to download xampp
It is not working.
Unfortunately, they didn't. :( I am sad.
POOP
Thank You!
thank you