What is the meaning of “Error Establishing a Database Connection”? And i f you are a girl, do not hesitate to check the high performing feminine themes which many successful female bloggers are using now. Consider reading the best five WordPress blog themes to get your right theme. Note: If you are just about starting a new blog, it is very important to have a perfect blog theme from the very beginning. In fact, there are a number of things that can cause WordPress database connection issues which we will learn in this post. The error establishing a database connection in WordPress occurs when the files in your hosting are unable to make a connection to the database. Most probably, it will be just a configuration issue that can be solved quickly. Whatever is your hosting, let us check the causes of such DB errors. As I shifted my blog hosting to a reliable hosting company, I did not face any such database issues with a new host. Often we will see such errors at the starting point of WordPress installation in GoDaddy, Bluehost, or any other web hosting platform. In fact, many of the WordPress users might have seen the error establishing a database connection in GoDaddy at some point in their life. WordPress beginners probably get a bit scared right now looking for its meaning, but let me assure you that this database connection error problem can be fixed very easily irrespective of your hosting in Godaddy or Bluehost. You can, in MySQL Version 3.If you cannot see your website’s home page showing the message “ Error Establishing a Database Connection” in GoDaddy/Bluehost/Hostgator, it appears that there exists a fatal error that makes your website pages inaccessible to the user.
#GODADDY PHPMYADMIN LOCALHOST UPDATE#
At this prompt type the following: (Where ******** is the new password, NOTE: the single quotes ARE REQUIRED) mysql> UPDATE er SET Password=PASSWORD('********') WHERE User='root' įlush privileges will make the change take effect immediately. at the console, type: mysqld_safe -skip-grant-tables -autoclose.
#GODADDY PHPMYADMIN LOCALHOST PASSWORD#
To change the mysql password for the root user, do the following: PS: contains more interesting settings :)įollow the root password change if you dont know the root password and then login in, it worked for me. So you get: $cfg = 'cookie' (or http if you wish)ģ) clear/delete all browser cookies for your server (usually look for localhost or 127.0.0.1 cookies)Ĥ) Go to phpyadmin's webpage again - now you will be prompted with login box (html or http - depends on whether you set the cookie or http)ĥ) LOGIN - AND YOU'RE DONE ! :) Suddenly 'Privileges'/'Users' tab is shown, the exit button appears suddenly too ! :) (next to the "little house"-left-top) $cfg = 'SOMETHING' - change 'SOMETHING' to 'cookie'
you may find more of those configs, however the one you need is the one that contains line:.SET PASSWORD FOR = PASSWORD('YOURPASSWORDHERE') Ģ) Search for in your wamp/xampp folder and change auth_type: On a main page you should see the current root user - usually So query for password change:.Just for the record: mysql> USE mysql ġ) I set a root password through SQL query like this: My suggestion is that you either find CREATE scripts for the tables in database mysql or do a complete reinstall (as it appears, you don't have much DB's to lose anyway). So you've really deleted the 'user' table. You need to delete only the localhost cookies. Note that you can select what cookies to delete via the developers tab in Chrome. This, AFAIK, is a bug affecting Google Chrome in particular but I can't say for certain for other browsers. If you are sure that you are running as root, try clearing your cookies then refresh.
0 kommentar(er)
