Ok. So I just reflash the BBB, should I do the partition first? and then install the myqsl database afterwards?.Last time I did the partition fllowing this guide: https://www.element14.com/community/community/designcenter/single-board-computers/next-gen_beaglebone/blog/2017/07/17/extending-micro-sd-card-space-for-beaglebone-black-use-windows-users
Thanks. El miércoles, 19 de julio de 2017, 9:14:16 (UTC-5), RobertCNelson escribió: > > > > On Tue, Jul 18, 2017 at 10:31 PM, <[email protected] <javascript:>> > 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/ec18ef72-a41d-453a-8d03-44fac8e8edd8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
