johnhardy
Forum Replies Created
-
Forum: Fixing WordPress
In reply to: Error establishing a database connectionThank you for all the help I have received it really has helped me on my way into learning WordPress.
My best regards
John H
Forum: Fixing WordPress
In reply to: Error establishing a database connectionHello Pranjal Pratap Singh
I thought I would let you know I have managed to get the database back by updating the password Courtesy of youtube at https://www.youtube.com/watch?v=hVQQKFmk-H8
Its wonderful to see phpmyadmin once again.
Regards
John H
Forum: Fixing WordPress
In reply to: Error establishing a database connectionYes it is 8081
Thank you so much for your quick answer
I could not hear the words from the video
but I think it is wanting a password
entered for this line
$cfg[‘Servers’][$i][‘password’] = ”;
I am not sure where this password was set up
but I think I know what it is.
It seems to be the main password for phpmyadmin?
C:/xampp/phpmyadmin/
Sorry to have been so long in answering
never been here before!!Forum: Fixing WordPress
In reply to: Error establishing a database connectionA bit more info I get this information about the problem is a pink error page,
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/1045): Access denied for user ‘root’@’localhost’ (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Any ideas please?
John H
Forum: Fixing WordPress
In reply to: Error establishing a database connectionHello,
I have to hang my head in shame.
I do not know why but I have lost access to phpmyadmin
I use http://localhost:8081/phpmyadmin/ and get
This site can’t be reached localhost refused to connect.
Try: Checking the connection
Checking the proxy and the firewallERR_CONNECTION_REFUSED
Regards
John H
Forum: Fixing WordPress
In reply to: Error establishing a database connectionMany thanks,
Re “In case, you don’t remember password for your user root. Use one of the following code to change your password”Where or what do I open to set the query please?
Thanks again
John HForum: Fixing WordPress
In reply to: Error establishing a database connectionHello Pranjal Pratap Singh and thanks for this information
I was expecting an image to appear but perhaps this is correct.
The url seems to work OK
This is really a test image to make sure I am getting the method of attaching the required image correct.I will send the others when I here from you.
Regards
John H
Forum: Fixing WordPress
In reply to: Error establishing a database connectionHello,
Thanks for all of the help
I have uploaded the images to ImageKit.io I assume I have to download these to this thread but I cannot see a way to do this. Am I on the right track please?Thank you
John HForum: Fixing WordPress
In reply to: Error establishing a database connectionRe:
“I can enter the text OK but cannot see how to include images.
I took some images as requested to send but could not see how to include these in this document. Can someone please explain how to include an image with this document”. I have not heard anything yet regarding the problems I have.
The images are quite important as they show the problems.
Sorry I was not clearer.
=========================================
As my original query is overly wide for this document I am pasting it below slimmed down a little to make the viewing easier.
Copied from the Top ———————–
I am trying to match wp-config.php with the database fields in phpMyAdmin
When I try to open wp-admin I get
Error establishing a database connection
I am trying to understand where the Database username is established as a database field.
Seems like it could be from several fields in the table wp_users at the moment these fields all have admin as the entry
user_login = admin
user nicename = admin
display_name = admin
I hope this helps, regardsJohn H
Forum: Fixing WordPress
In reply to: Error establishing a database connectionI thank you all for your answers, very helpful.
I did by mistake send these details by email and I see this has not arrived and I now realise that this is not preferred.I can enter the text OK but cannot see how to include some images. Can someone please explain.
Many thanks
John H
Forum: Localhost Installs
In reply to: Fields in user_usermetaForum: Localhost Installs
In reply to: Fields in user_usermetaThe software for this site was downloaded about 3 months ago and I heard that
“the details for user_login and the user_pass in the table wp_users must be included in in the table wp_usermeta.”
Is that the case please?
Apologies for the late replyThanks
John H
Forum: Localhost Installs
In reply to: Backup of localhost/phpmyadminMany thanks for the information. It is very helpful!
Regards
John H
Forum: Localhost Installs
In reply to: Backup of localhost/phpmyadminThanks very much for the information.
When a db backup is being created “Exported” is it OK for this to be Exported to c:/Users/name/Downloads/ ?Regards
John H
Forum: Fixing WordPress
In reply to: Localhost site will not open but OK on RemoteThank you for your responses,
I am using my home computer and working on localhost to create a WordPress website.
I have uploaded this site to a web server and this is working OK. When I try to open the site on my Localhost I enter
http://localhost:8081/wp-xxxx-info/wp-admin/index.phpWhen I press enter the url then changes to
http://localhost:8080/wp-xxxx-info/wp-login.php?redirect_to=http%3A%2F%2Flocalhost%3A8081%2Fwp-xxxx-info%2Fwp-admin%2Findex.php&reauth=1
and I see “This site can’t be reached etc”I was using 8080 but was advised to use 8081
I hope this is clear
Thank you
