thank you so so so much.I spent hours figuring out how to set it up but completed it in 20 min through your video.I can't thank you enough bro.God bless you .
Very interesting and very clear, I forgot the procedure to install phpmyadmin on my new mac, I followed all the steps, I am very satisfied, I successfully installed phpmyadmin on my new mac. Thanks very match
I absolutely agree with everyone, best video for Mac installation! Jesus I spent hours researching. It was my second installation and gosh it was such a pain. Thank you soooo sooo much
For those having password issues with the latest MySQL version, try the following code to switch your password to the native encryption: alter user 'username'@'localhost' identified with mysql_native_password by 'password';
HELP -- when I enter 'localhost/phpmyadmin/ on Chrome, I am getting "Forbidden - You don't have permission to access /phpmyadmin/ on this server. Could anyone kindly advise? I followed all instructions to the tee.
I followed each and every step for running phpmyadmin on my mac but when I search for localhost/phpmyadmin/setup/ , it shows me The requested URL was not found on this server. I really need your help
if cannot log-in in last step, and facing mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client and you're using mac, try method below:- preferences -> mysql -> initialize database -> use legacy password encryption(instead of strong) -> entered same password this work to me.
can someone help me please ? when I want to Connect to localhost, it has an error message: FORBIDDEN you don't have permission to access this ressource
it says "Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin. and if i check it going to setup it displays" "phpMyAdmin - Error Configuration already exists, setup is disabled!"
When using your directions to create the index.php file, it instead creates the file index.php.save - deleting the index.html and refreshing localhost then returns "forbidden - you do not have access to this file - any solution to this?
I had the issue 1045 error; can't connect to SQL. Found out that the password given/made from SQL didn't work and used "password" as the password and it worked.
I have forced a lot with this problem, Than find a solution,The problem is about the latest mysql version , Although doing everything right it gives this mysqli_real _connect error, Listen All Friends,just download this version of mysql and download this link here. dev.mysql.com/downloads/file/?id=479114. , than do everything the same if you can delete mysql completely clean it will work , Евгений Бровдий
I agree with Abdulkadir Kara! Spent a LOT of time trying to solve this issue, but only downloading the previous version of MySQL helped! (Thank you very much for the link, by the way)
I have a problem "mysqli_real_connect(): (HY000/2002): No such file or directory" When trying to sign in at the very end Can somebody give correct solving this problem?, the internet searches didn't help me. Please help, it is very critical for me now
I have forced a lot with this problem, Than find a solution,The problem is about the latest mysql version , Although doing everything right it gives this mysqli_real _connect error, Listen All Friends,just download this version of mysql and download this link here. dev.mysql.com/downloads/file/?id=479114. , than do everything the same if you can delete mysql completely clean it will work ,
I agree with Abdulkadir Kara! Spent a LOT of time trying to solve this issue, but only downloading the previous version of MySQL helped! (Thank you very much for the link, by the way)
If using MySQL version 8 with SHA256 authentication use this command when testing MYSQL installation. "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';" The similar command in the video only works for legacy authentication.
i completed all ways that you said us about php apache server but i can not run my php file. when i try to run that localhost/PhpProject1/index.php, it gives me "requested url was not found in this url" mistake? please help me
Hi after following all the steps I'm unable to login to the dashboard of phpmyadmin. I got this error on login (mysqli::real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]). I recheck the password and I restart the mysql server using the same mysql server password. What should I do in order to access my dashboard as root? THX
I had the same problems like everyone here, and I got a solution for the problem with „mysqli_real_connect(): (HY000/2002): No such file or directory“. By doing „sudo mkdir /var/msql“ the directory was not created in the folder documents/phpMyAdmin. And I guess it should be created there. I switched the created folder "var" to documents/phpMyAdmin and then it worked well, also with the latest MySQL version. Hopefully it will work at your systems.
@@michaelfeiertag3274 thanks for your answer, but meanwhile i fear my problem is different, because my error is: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] and mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client - so few steps before ... i can´t log-in :-/
While overall this was helpful, the detail in between steps was poor. It would've helped a lot if instructor explained more what the steps in terminal were actually doing.
For those who are having trouble with mysqli_real_connect try this line of code in altering your password in mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
if you've dowloaded the latest version MySQL 8, you can try the following: alter user 'username'@'localhost' identified with mysql_native_password by 'password';
Hello there..there is a problem while login..i am typing password correctly....plsss give me ur mail id so that i can send u the image of it amd u can tell me how to fix this....its very urgent....i am in middle of my project...plsss
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client and you're using mac, try method below:
i find a best way very easy to allow everyone to change the file /etc/apache2/httpd.conf, without needing unix commande, just download visual studio code on MAC, then go to Finder and preference, clique on barre lateral , clique on HDD Macinthosh (the name of your HDD). , this just to allow it to be shown in the folder . After that open Visual Studio and go to folder /etc/apache2/httpd.conf. Open the file "ttpd.conf." search the needed line that we want to change, in our example "#LoadModule php7_module libexec/apache2/libphp7.so", then remove # and save
Very nicely done in a very straightforward manner! You are a great teacher!
thank you so so so much.I spent hours figuring out how to set it up but completed it in 20 min through your video.I can't thank you enough bro.God bless you .
can you help me please ? when I want to Connect to localhost, it has an error message:
FORBIDDEN
you don't have permission to access this ressource
I am doing this for the second time on my new Mac, thanks bro. You're the best!
can you help me please ? when I want to Connect to localhost, it has an error message:
FORBIDDEN
you don't have permission to access this ressource
Very interesting and very clear, I forgot the procedure to install phpmyadmin on my new mac, I followed all the steps, I am very satisfied, I successfully installed phpmyadmin on my new mac. Thanks very match
hey can you pls help me in installing phpmyadmin. I am really confused
can you help me please ? when I want to Connect to localhost, it has an error message:
FORBIDDEN
you don't have permission to access this ressource
I absolutely agree with everyone, best video for Mac installation! Jesus I spent hours researching. It was my second installation and gosh it was such a pain. Thank you soooo sooo much
hey can you pls help me in installing phpmyadmin. I am really confused
Thank you, this is probably the BEST video ever!!!
Thank you for helping new guys get better!
This video content works in macOS Catalina 10.15.3 as well. Thanks for such video 👍🏻
Clear and simple.. Thank you
can you help me please ? when I want to Connect to localhost, it has an error message:
FORBIDDEN
you don't have permission to access this ressource
omg you are a lifesaver!! Thank you so much!!!
at 4:30, how do you go back to the previous page after you've entered in 'index.php'?
control+x then Y then return(Enter)
Thank you so much for the tutorial!!!
can you help me please ? when I want to Connect to localhost, it has an error message:
FORBIDDEN
you don't have permission to access this ressource
thank you for this! great video.
Excellent 👌
For those having password issues with the latest MySQL version, try the following code to switch your password to the native encryption:
alter user 'username'@'localhost' identified with mysql_native_password by 'password';
Thank you!
Thank you! This works for me.
You should make a lot of videos
to educate people who are new to the environment
HELP -- when I enter 'localhost/phpmyadmin/ on Chrome, I am getting "Forbidden - You don't have permission to access /phpmyadmin/ on this server.
Could anyone kindly advise? I followed all instructions to the tee.
Thank you for amazing tutorial!!
Everything was ok until 07:55. My mysql server cannot connect! What is the problem? I restarted my computer etc. But I could not solve it..
Its been really useful THANKS A LOT = Muchas gracias
Thank you so much!
great this actually worked !
I followed each and every step for running phpmyadmin on my mac but when I search for localhost/phpmyadmin/setup/ , it shows me The requested URL was not found on this server. I really need your help
getting a warning and a parse error in the index.php file. Unable to open the localhost/phpMyAdmin/setup
nice one. thanks so much
if cannot log-in in last step, and facing
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
and you're using mac, try method below:-
preferences -> mysql -> initialize database -> use legacy password encryption(instead of strong) -> entered same password
this work to me.
yes I sam sam.
you saved me tiiiime!!
SAME.Dose anyone found a solution to fix it ?
You saved the day man!...Thanks
can someone help me please ? when I want to Connect to localhost, it has an error message:
FORBIDDEN
you don't have permission to access this ressource
thank you so so much!!!
it says
"Failed to set session cookie. Maybe you are using HTTP instead of HTTPS to access phpMyAdmin.
and if i check it going to setup it displays"
"phpMyAdmin - Error
Configuration already exists, setup is disabled!"
When using your directions to create the index.php file, it instead creates the file index.php.save - deleting the index.html and refreshing localhost then returns "forbidden - you do not have access to this file - any solution to this?
Thanks you bro!
Really good tutorial
when i access localhost/phpmyadmin/setup it says `Not Found`. Any one knows ?
make localhost/phpMyAdmin/setu
@@arsalanbabar1078 ok
Hi, did you manage the problem? I have the same (
Thank you for sharing!!!!
I acidently pressed backspace. Now the lines gone.
thanks it works
I had the issue 1045 error; can't connect to SQL. Found out that the password given/made from SQL didn't work and used "password" as the password and it worked.
I get mysqli_real_connect(): (HY000/2002): No such file or directory
When trying to sign in at the very end
The same problem( Can somebody give correct answer to solve this problem?
I have forced a lot with this problem, Than find a solution,The problem is about the latest mysql version , Although doing everything right it gives this mysqli_real _connect error, Listen All Friends,just download this version of mysql and download this link here. dev.mysql.com/downloads/file/?id=479114. , than do everything the same if you can delete mysql completely clean it will work , Евгений Бровдий
I agree with Abdulkadir Kara! Spent a LOT of time trying to solve this issue, but only downloading the previous version of MySQL helped!
(Thank you very much for the link, by the way)
You have to start the server
I have a problem "mysqli_real_connect(): (HY000/2002): No such file or directory"
When trying to sign in at the very end
Can somebody give correct solving this problem?, the internet searches didn't help me.
Please help, it is very critical for me now
I have forced a lot with this problem, Than find a solution,The problem is about the latest mysql version , Although doing everything right it gives this mysqli_real _connect error, Listen All Friends,just download this version of mysql and download this link here. dev.mysql.com/downloads/file/?id=479114. , than do everything the same if you can delete mysql completely clean it will work ,
I agree with Abdulkadir Kara! Spent a LOT of time trying to solve this issue, but only downloading the previous version of MySQL helped!
(Thank you very much for the link, by the way)
@@sukran3009 büyüksün kardes ;)
Taxi Fisch övülmeye layık Mevlamız Allah C.C dur bizlik bişey yok faydalanmana sevindim
@@sukran3009 It helped! Thank you so much!
If using MySQL version 8 with SHA256 authentication use this command when testing MYSQL installation. "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';" The similar command in the video only works for legacy authentication.
i completed all ways that you said us about php apache server but i can not run my php file. when i try to run that localhost/PhpProject1/index.php, it gives me "requested url was not found in this url" mistake? please help me
why did we make config file if its empty?
Hi after following all the steps I'm unable to login to the dashboard of phpmyadmin. I got this error on login (mysqli::real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]). I recheck the password and I restart the mysql server using the same mysql server password. What should I do in order to access my dashboard as root? THX
I got error typing "" "Error writing /Bibliotek/WebServer/Documents/index.php: No such file or directory"
OS high sierra
did you manage to solve it? same problem here...
THANNNNNNNNKS!
I had the same problems like everyone here, and I got a solution for the problem with „mysqli_real_connect(): (HY000/2002): No such file or directory“.
By doing „sudo mkdir /var/msql“ the directory was not created in the folder documents/phpMyAdmin. And I guess it should be created there.
I switched the created folder "var" to documents/phpMyAdmin and then it worked well, also with the latest MySQL version.
Hopefully it will work at your systems.
hi Michael, where do i find the var folder now to move it to documents/phpMyAdmin? thanks for your comment!
@@_carina hi carina, i did it simply by searching with the finder
@@michaelfeiertag3274 thanks for your answer, but meanwhile i fear my problem is different, because my error is: mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password] and mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client - so few steps before ... i can´t log-in :-/
Thanks
While overall this was helpful, the detail in between steps was poor. It would've helped a lot if instructor explained more what the steps in terminal were actually doing.
For those who are having trouble with mysqli_real_connect
try this line of code in altering your password in mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
When i try to run 'sudo nano /usr/local/etc/httpd/httpd.conf' it shows me an empty result. Please help me
thnx for video please install given versions
mysqli_real_connect(): (HY000/2002): No such file or directory
please, this is the error i am facing, elp.
if you've dowloaded the latest version MySQL 8, you can try the following: alter user 'username'@'localhost' identified with mysql_native_password by 'password';
Hello there..there is a problem while login..i am typing password correctly....plsss give me ur mail id so that i can send u the image of it amd u can tell me how to fix this....its very urgent....i am in middle of my project...plsss
Ctrl 0 and ctrl x don't work
same problem
After Ctrl 0 you should first enter than Ctrl X it will work
not working for me :(
pasward ?
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client
and you're using mac, try method below:
mysqli::real_connect(): (HY000/2002): No such file or directory
i find a best way very easy to allow everyone to change the file /etc/apache2/httpd.conf, without needing unix commande, just download visual studio code on MAC, then go to Finder and preference, clique on barre lateral , clique on HDD Macinthosh (the name of your HDD). , this just to allow it to be shown in the folder . After that open Visual Studio and go to folder /etc/apache2/httpd.conf. Open the file "ttpd.conf." search the needed line that we want to change, in our example "#LoadModule php7_module libexec/apache2/libphp7.so", then remove # and save
Thank you so much...