Database Connection Error After Migrating To A New Host... Are My Posts GONE?

lol same thing happened to me after a migration, teh database user may exist but lack privileges on teh database.. 😅 in the host panel, assign teh user to the database with all privileges, or run GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost'; followed by FLUSH PRIVILEGES; if you manage MySQL yourself.

hmmm +1 same here. @cronnomad what did u end up doing in teh end worked for me anyway 🤷

nope

same issue here on my old thinkpad. following this therad hope that helps :)

nah tbh I'd put caching in front so most visitors never hit teh database at all. that fixes random overload far more effectively than tweaking MySQL settings. just my 2 cents

lol same thing happened to me +1 same here worked for me anyway 🤷

@uadler nah thats not it, mysql has nothing to do with it but hey ymmv

oh ive been there lol following, having teh same problem fingers crossed 🤞

pro tip: write down what u chnage. i didnt and had to redo database from scratch, i swear small is cursed

respectfully disagree, i tried that and it made mysql worse. try turning off teh firmware first, fixed it for me but hey ymmv

wait which version are you on? ??

@hjansen_45 WOWWW mariaDB was getting killed for memory. added swap, reduced the buffer pool, added page caching.. xD stable for two weeks now. owe u a beer 🍺