New user's registration have been closed due to high spamming and low trafic on this forum. Please contact forum admins directly if you need an account. Thanks !

MySQL server password

Got problems with your B2 or B3? Share and get helped!
Post Reply
WimS
Posts: 6
Joined: 18 Nov 2009, 15:34
Contact:

MySQL server password

Post by WimS »

Hi,

I managed to get phpMyAdmin installed (was not working untill I did a restart of the apache server (was not mentioned in the how to)) and did get the message that there is no password on the MySQL server (user root). Is this the intention or is it better to set a password? Or does that messes up future upgrades of the bubba2 of the use of mediathomb etc.?

Greetings...
Wim

[give me a few years and I understand Debian :lol: ]
asparak
Posts: 173
Joined: 08 Jun 2009, 07:38

Re: MySQL server password

Post by asparak »

Hi,

Welcome to the world of Linux.
Generally, if you make any changes to Webservers like Apache, it is best to restart it anyway, so that it picks up your changed config. In almost all instances, webservers only read config changes at startup.

MySQL in the real world would most definitely have a password on it and most people on the forum would have done that straight away. Unfortunately that will cause some issues, because currently the Excito upgrade process via the GUI relies on their being no password in place. If you do decide to add a password, then you will need to manually apply upgrades for yourself from the SSH login using apt-get update and apt-get dist-upgrade, so that you can interactively type the password when required.

Excito are aware of this and are actively looking at options to fix this for future releases. Personally, I'm much happier just installing a password and running the upgrades from the SSH terminal, rather than leaving an insecure MySQL server theoretically vulnerable to an easy attack. With a password in place, any hacker would have to work just that little bit more to get at the data :)
WimS
Posts: 6
Joined: 18 Nov 2009, 15:34
Contact:

Re: MySQL server password

Post by WimS »

Thanks for your comment, I will keep it in mind when the next upgrade fails :roll:

Greetings...
Wim
Post Reply