forum.excito.com

I am trying again. What does this mean?

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Well, I didn't have any passwords in the table, that's what I said already. If that can't be, then I don't know what to say. I have access to MySQL with two users, but no software updates because of: "Failed to access MySQL with default root login, unable to continue with upgrade" I am try...

I get: "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)" the same goes for the other, non-root user. Su, or no su, makes no difference.

If I use -p I get in with the password. I have two users, "root", and one more that's not root.

I didn't have any passwords in that table: "Host User Password", it looked exactly the same as in the example above. I still have "Failed to access MySQL with default root login, unable to continue with upgrade" Word Press works fine. Where does the password in /etc/mysql/debian....

thx Ubi, this is great! Learn the hacks first and the basics later!

Thanks for all advice! I am trying to get into these things as a beginner. I succeeded in moving the Word Press- site to B3 from another machine where I have it on localhost, created a database and an other user that's not root, but has all the privileges anyway. Now I learn from Eek's link that it ...

"You are not correct in stating that the system and wordpress need the same database." They both need MySQL anyway. What I want to learn about is the best practice for security with Word Press, and how to get my updates back. I guess Ubi told me to delete the root password and it should be...

Thx Eek! The instructions were simple and had the desired effect, now I can see all the databases. The problem is that the default root login for upgrades from Excito is gone: "Failed to access MySQL with default root login, unable to continue with upgrade" I need the DATABASE for Word Pre...

I have been trying to move a Word Press site to B3. MySQL database is a mess with the "Access denied for user 'root'@'localhost' " messages. Now I noticed a new message about upgrade:"Failed to access MySQL with default root login, unable to continue with upgrade" I have not chan...

I took the easy way out. What I know now is that one has to be very careful with "denyhosts".
THX for the advice anyway!

Well, I have to nuke the whole sh*t. There should be a way to pre-empt the situation where you get locked out from SSH-connection to B3.

Maybe it would be better to know which precautions to take so that this could never happen. Reinstalling every time something happens is too much of fuss.

It shouldn't be possible for admin to get shut out from b3 on your own LAN but that is what SSH did to me.

I was able to log in with SSH without problems. Out of nowhere it just stopped. Everything else works as usual. What should I look for in the logs? I installed some things on b3 like denyhosts and snort. Could it be a problem with denyhosts?

Got this suddenly: ssh_exchange_identification: Connection closed by remote host

What can I do?

No access here either on Mac OS X 10.6.8. B3 doesn't show in Network. Initially it did open, but it didn't give me any "easyfind" address, it "failed to connect to database server", from there things just went wrong. Now it doesn't show up at all. How do I get it back? I got it w...