Thanks a lot! :)) This allowed me get back in WordPress admin panel. Pages weren't working, so I updated permalinks and everything now is working fine :)
Thank you so much! I'm doing a wp web for class and i thought i had lost it, but i realised idk why my sql user had lost the privileges!!! Thank you again :)
@WPBeginner - WordPress Tutorials, If I've managed to pass all of the tests in this video and my problem still persists, does it mean I might have a server resource issue? The site I'm managing is an ecommerce and goes down every week or so. I get the 'Error establishing a database connection', then I restart my server and everything comes back online. The server is running on 2GB Ram 1GB CPU, but I don't want to make the assumption that it's lacking resources as I don't have much server experience.
Troubleshooting from a server admin level is a bit beyond what we cover at this time. Our biggest recommendation would be to check any error logs you may have to help narrow down the root cause of the issue.
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'username'@'localhost' (using password: YES) in C:\xampp\htdocs\wordpress-6.0.3-en_CA\wordpress\testconnection.php:3 Stack trace: #0 C:\xampp\htdocs\wordpress-6.0.3-en_CA\wordpress\testconnection.php(3): mysqli_connect('localhost', 'username', 'password') #1 {main} thrown in C:\xampp\htdocs\wordpress-6.0.3-en_CA\wordpress\testconnection.php on line 3 what does its meaning? I still getting an error.
From taking a look at that error, it seems like your username and password are incorrect, you would want to check that information to ensure it is set up correctly.
Hi there 19 sep 23 , for me isn't work any solution, I try to fix automaticaly with wordpress with step 3 , after insert that line, and run , re-open xamp , clean pass , leave db with user root, is't work anyone can help me, I'm building on local host a website , any information will be appreciated please , thank you in advance !
If none of the methods from our guide worked for you, you could try creating a new database and connect to it to see if it is an error with the database itself.
It would depend on what you're currently using but, if you're looking to improve your WordPress search then we would recommend taking a look at our list below: www.wpbeginner.com/showcase/12-wordpress-search-plugins-to-improve-your-site-search/
Generally great advice, but it won't work in my case! The Source of error was MySQL corruption(shut down unexpectedly) @WPBeginner - WordPress Tutorials
Thanks, An addition to method one. if you restore your site from a backup then this error happens. After checking your WP config file and your My SQL database you need to check if you have a MySQL user assigned to your database. If not, create a user from the C panel in MySQL databases and then assign that user to that database and you're good to go.
If you mean the link to our written article then it is still working for us, you should be able to visit using: www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/
Thanks a lot! :)) This allowed me get back in WordPress admin panel. Pages weren't working, so I updated permalinks and everything now is working fine :)
Glad to hear our guide could help! :)
Thank you so much! I'm doing a wp web for class and i thought i had lost it, but i realised idk why my sql user had lost the privileges!!! Thank you again :)
You're welcome, glad to hear our guide was helpful!
@WPBeginner - WordPress Tutorials, If I've managed to pass all of the tests in this video and my problem still persists, does it mean I might have a server resource issue?
The site I'm managing is an ecommerce and goes down every week or so. I get the 'Error establishing a database connection', then I restart my server and everything comes back online. The server is running on 2GB Ram 1GB CPU, but I don't want to make the assumption that it's lacking resources as I don't have much server experience.
Troubleshooting from a server admin level is a bit beyond what we cover at this time. Our biggest recommendation would be to check any error logs you may have to help narrow down the root cause of the issue.
you save me a 1 month of hard hard harrrrd work 😍😍
Glad our guide could help :)
Excellent information. Thank you for help
Glad it was helpful!
Thank you so much. You are the best. I was really close to a mental breakdown.
Glad our guide could help!
Thank you!!! Method 1 fixed my problem!!
Glad it helped!
you saved my life, thank you!
Glad we could help!
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'username'@'localhost' (using password: YES) in C:\xampp\htdocs\wordpress-6.0.3-en_CA\wordpress\testconnection.php:3 Stack trace: #0 C:\xampp\htdocs\wordpress-6.0.3-en_CA\wordpress\testconnection.php(3): mysqli_connect('localhost', 'username', 'password') #1 {main} thrown in C:\xampp\htdocs\wordpress-6.0.3-en_CA\wordpress\testconnection.php on line 3
what does its meaning? I still getting an error.
From taking a look at that error, it seems like your username and password are incorrect, you would want to check that information to ensure it is set up correctly.
@@wpbeginner No,
it's correct, I have already taken a screenshot.
Hi there 19 sep 23 , for me isn't work any solution, I try to fix automaticaly with wordpress with step 3 , after insert that line, and run , re-open xamp , clean pass , leave db with user root, is't work anyone can help me, I'm building on local host a website , any information will be appreciated please , thank you in advance !
If none of the methods from our guide worked for you, you could try creating a new database and connect to it to see if it is an error with the database itself.
Great help, thank you for the clear and concise instructions.
Glad our guide was helpful!
can you guys make a video explaining how to make the tag and category search work? thanks
It would depend on what you're currently using but, if you're looking to improve your WordPress search then we would recommend taking a look at our list below:
www.wpbeginner.com/showcase/12-wordpress-search-plugins-to-improve-your-site-search/
What if this error occurs on localhost, and the wp site worked without problems for a while?
We would still recommend trying these steps for a local installation to try to solve this issue.
Generally great advice, but it won't work in my case!
The Source of error was MySQL corruption(shut down unexpectedly) @WPBeginner - WordPress Tutorials
Thanks, An addition to method one. if you restore your site from a backup then this error happens. After checking your WP config file and your My SQL database you need to check if you have a MySQL user assigned to your database. If not, create a user from the C panel in MySQL databases and then assign that user to that database and you're good to go.
Thanks for sharing this for those running into that issue!
This saved me. Thank you 🙏
Thank you so much! Option 2 fixed my issue.
Glad it helped!
how do I upload the changed wp_config?
If you used the file manager to download the file then there is an upload button at the top of the page that you would use :)
@@wpbeginner Thank you, which one is easy for beginners?
This worked! Thank you so much, I was so worried! 👏👏👏👏👏👏
You're welcome!
Thank you!
You're welcome!
Commection is written on thumbnail instead of connection
Thank you for letting us know :)
This helped
Glad our video was helpful! :)
link not working
If you mean the link to our written article then it is still working for us, you should be able to visit using:
www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/
thank you thank you
You're welcome!
nothing of this works stay same problem
If none of our recommendations work for you, please reach out to your hosting provider and they should be able to assist!
First viewer❤️
:)
please make video in hindi
While we do not have plans for that at the moment, we will consider it in the future