I am not a technical expert, I have repaired it following your link and could repair it.īut it suggested to me check few table error which showed (site was running perfectly) some wp forum post show me to run the below command for checking the issue and once i did that everything stopped working and that command screen is loading since almost 45 min. So I wanted to follow your suggestion by repairing the db from the cpanel/phpmyadmin. I have somehow resolved it but running the command on the wp_config file and could resolve the issue yesterday. Wp_commentmeta: 40 clients are using or haven’t closed the table properly Wp_termmeta: 36 clients are using or haven’t closed the table properly Wp_term_relationships: 44 clients are using or haven’t closed the table properly Wp_term_taxonomy: 44 clients are using or haven’t closed the table properly Wp_terms: 22 clients are using or haven’t closed the table properly Wp_postmeta: 47 clients are using or haven’t closed the table properly Wp_comments: 45 clients are using or haven’t closed the table properly Wp_posts: 46 clients are using or haven’t closed the table properly Wp_usermeta: 48 clients are using or haven’t closed the table properly Wp_users: 45 clients are using or haven’t closed the table properly Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance. Some database problems could not be repaired. Kindly help me with the below output from the repair function. I have used the repair database option in the cwp_config file and repaired the database. You can, in MySQL Version 3.Suddenly while accessing my wordpress website there was an error shown “Database connection Failed”. 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.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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |