On Tue, Jul 18, 2017 at 10:31 PM, <[email protected]> wrote: > I did the update and then an upgrade. The upgrade tried to reinstall mysql > but got an error in the password setting step, this one: > > > <https://lh3.googleusercontent.com/-J8Spq-CB11Y/WW7Q4lNm5xI/AAAAAAAAALc/3W3yrSJQVPIv3pWTqUuJjTobrsHfHFepwCLcBGAs/s1600/passMySQL.png> > And the concerning info about it in the mentioned file would be this: > > root@beaglebone:/usr/share/doc/mysql-server-5.5# zcat > /usr/share/doc/mysql-server-5.5/README.Debian.gz > * MYSQL WON'T START OR STOP?: > ============================= > You may never ever delete the special mysql user "debian-sys-maint". This > user together with the credentials in /etc/mysql/debian.cnf are used by the > init scripts to stop the server as they would require knowledge of the > mysql > root users password else. > So in most of the times you can fix the situation by making sure that the > debian.cnf file contains the right password, e.g. by setting a new one > (remember to do a "flush privileges" then). > > * PASSWORDS: > ============ > It is strongly recommended to set a password for the mysql root user (which > /usr/bin/mysql -u root -D mysql -e "update user set > password=password('new-password') where user='root'" > /usr/bin/mysql -u root -e "flush privileges" > If you already had a password set add "-p" before "-u" to the lines above. > > > If you are tired to type the password in every time or want to automate > your > scripts you can store it in the file $HOME/.my.cnf. It should be chmod 0600 > (-rw------- username username .my.cnf) to ensure that nobody else can read > it. Every other configuration parameter can be stored there, too. You will > find an example below and more information in the MySQL manual in > /usr/share/doc/mysql-doc or www.mysql.com. > > ATTENTION: It is necessary, that a .my.cnf from root always contains a > "user" > line wherever there is a "password" line, else, the Debian maintenance > scripts, that use /etc/mysql/debian.cnf, will use the username > "debian-sys-maint" but the password that is in root's .my.cnf. Also note, > that every change you make in the /root/.my.cnf will affect the mysql cron > script, too. > > # an example of $HOME/.my.cnf > [client] > user = your-mysql-username > password = enter-your-good-new-password-here > > I'm newbie at this so before procceding I'd like some guidance on how to > do this line /usr/bin/mysql -u root -D mysql -e "update user set > password=password('new-password') where user='root'" and what implies the > "flush privileges" >
yeah, just reflash.. Your partition is corrupted from the failed install when you ran out of space.. Regards, -- Robert Nelson https://rcn-ee.com/ -- For more options, visit http://beagleboard.org/discuss --- You received this message because you are subscribed to the Google Groups "BeagleBoard" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beagleboard/CAOCHtYjzx_hqv5Q8KkBrRjdG9WyAF6atUKyXzDFNFFaid%2BGU4Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
