Posts by jerry@my-place.social
 (DIR) Post #AqsMOX8fTsgNSxrKtM by jerry@my-place.social
       0 likes, 0 repeats
       
       This is great! Congratulations! You're doing so much, so fast!
       
 (DIR) Post #ArDD1WFTnzlMmF9fNY by jerry@my-place.social
       0 likes, 0 repeats
       
       Wow. You're on fire! Very impressive!
       
 (DIR) Post #ArDQ0zERrKolmXkUXg by jerry@my-place.social
       0 likes, 0 repeats
       
       I don't think this error means a disastrous install problem.ECONNREFUSED is a TCP error, so this tells me you are not connecting with a socket, but using a TCP connection on port 3306. So why would the connection be refused?What I would do next, from the command line, is to see if anything is even listening on port 3306. Depending on whether anything accepts the connection, it gives the next debugging step.telnet, btw, is not natively installed on Ubuntu, so you may need to do this first before continuing:sudo apt updatesudo apt install telnetdThen:telnet localhost 3306So, is anything listening? If not, then either the database didn't start or it's listening on a different port.If something is listening, then try to access the database directly:mysql -h localhost -u root -p 3306If this fails, hopefully you get a meaningful error message telling you why. Maybe a DB issue, or perhaps no database is up.If it works, then your database is up and running and listening on port 3306. This is good news. So either your Ghost configuration has the wrong host/port information for the database, or perhaps the connection needs or doesn't need an SSL connection.But, these are the steps I'd do first just to get additional information about the issue.
       
 (DIR) Post #ArDUXpqQBN6A2XQg7c by jerry@my-place.social
       0 likes, 0 repeats
       
       I wish it finished the sentence, "not a recogonisable Ghost installation because ..."What happens when you run "sudo mysql" ?If it opens and connects, then it's still using socket-based authentication. Then I would manually run the ALTER, FLUSH, and exit. Then try to restart ghost.If it doesn't open, but asks for the password, and the password works, then this change in the authentication method already was done and the problem isn't this particular step. Does ghost doctor provide any diagnostics?
       
 (DIR) Post #ArDa5EetRdcIKImbaK by jerry@my-place.social
       0 likes, 0 repeats
       
       This is what self-hosting is about. Living in a cloud of confusion because you're dealing with a bunch of different tech, none of which you'd ever be able to become an expert in. So, there's a lot of trial and error. This is so familiar. And the fun of it.The ALTER statement format, I believe, is wrong. It is showing single quotes around "mysql_native_password" which makes it a literal string. But, IDENTIFIED WITH specifies the name of the authentication plugin, not a string. Can you try instead:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<your-new-root-password>';Reference: dev.mysql.com/doc/refman/8.0/e… and the section showing:| IDENTIFIED WITH auth_plugin BY 'auth_string'Notice, no single quotes around auth_plugin
       
 (DIR) Post #AuO5TBmmXEyXjzXdGS by jerry@my-place.social
       0 likes, 0 repeats
       
       @_elena It's great that you're having fun with this! It's great following a passion.I'm really excited to see the result!
       
 (DIR) Post #Av0gMJF7UWkB9Ur9CS by jerry@my-place.social
       0 likes, 0 repeats
       
       @_elena I just got some quiet time to view your video. I've been so excited to see it for so long. I love it! I love it! I love it!The first thing I did was post it to Facebook (where I go to visit the stubborn people who haven't moved).  I wrote, "Here's why you all shouldn't still be here!".This is so well done. I'm so grateful that you produced this. It is awesome!
       
 (DIR) Post #Av7c3By1HM69NHCpLE by jerry@my-place.social
       0 likes, 0 repeats
       
       @_elena Fortunately, not all are ignoring it. The Boston Globe is covering it, along with other unhappy-for-Trump news. It's also owned by a billionaire, but a Democrat. It's the only U.S. newspaper I subscribe to now.I don't know how to fix this. To avoid the government taking over the media, a power-hungry billionaire Klan just decided to buy all the media, after removing the laws that would stop them from doing this. Then the control of the media was unquestionably legal. They planned this.The majority of the people just don't seem to care that this is happening, nor that they idiotically allowed it. It is totally discouraging.bostonglobe.com/2025/06/14/nat…
       
 (DIR) Post #AxIEiwQTYOPJPJ6NhQ by jerry@my-place.social
       0 likes, 0 repeats
       
       @_elena @Lioh @mullana I love the new profile pic and ... also you're going to watch Star Trek? Wow, you just continue becoming an even better person every day!I think I'm in a minority, but Voyager is my favorite ST series.I'll order one of these t-shirts now.