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" El martes, 18 de julio de 2017, 14:54:55 (UTC-5), RobertCNelson escribió: > > > > On Tue, Jul 18, 2017 at 1:30 PM, <[email protected] <javascript:>> > wrote: > >> I try to install MySQL database on my begalebone black but didn't succed, >> seemed to have my disk full, solved that problem and try to install again >> but now I got the following error: >> > > Did you start with a fresh install? or did you just run the > "grow_partition.sh" script? > > Just installed it on my test {2016-05-13} image and it works: > > debian@beaglebone:~$ systemctl status mysql.service > ● mysql.service - LSB: Start and stop the mysql database server daemon > Loaded: loaded (/etc/init.d/mysql; generated; vendor preset: enabled) > Active: active (running) since Tue 2017-07-18 19:50:22 UTC; 21s ago > Docs: man:systemd-sysv-generator(8) > CGroup: /system.slice/mysql.service > ├─3859 /bin/sh /usr/bin/mysqld_safe > └─4214 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql > --plu > > Jul 18 19:50:16 beaglebone systemd[1]: Starting LSB: Start and stop the > mysql da > Jul 18 19:50:22 beaglebone mysql[3830]: Starting MySQL database server: > mysqld . > Jul 18 19:50:22 beaglebone mysql[3830]: Checking for tables which need an > upgrad > Jul 18 19:50:22 beaglebone mysql[3830]: not closed cleanly.. > Jul 18 19:50:22 beaglebone systemd[1]: Started LSB: Start and stop the > mysql dat > Jul 18 19:50:22 beaglebone /etc/mysql/debian-start[4281]: Upgrading MySQL > tables > Jul 18 19:50:28 beaglebone /etc/mysql/debian-start[4286]: > /usr/bin/mysql_upgrade > Jul 18 19:50:28 beaglebone /etc/mysql/debian-start[4347]: Triggering > myisam-reco > > > debian@beaglebone:~$ sudo /opt/scripts/tools/version.sh > git:/opt/scripts/:[a6e52fdbb7f0d94c04f3973725a85fc4d99a7858] > eeprom:[A335BNLTGW1ABBGW16051002] > dogtag:[BeagleBoard.org Debian Image 2016-05-13] > bootloader:[microSD-(push-button)]:[/dev/mmcblk0]:[U-Boot > 2016.03-00001-gd12d09f] > kernel:[4.9.38-ti-r48] > nodejs:[v0.12.18] > pkg:[bb-cape-overlays]:[4.4.20170630.1-0rcnee0~jessie+20170630] > pkg:[bb-wl18xx-firmware]:[1.20170718-0rcnee0~jessie+20170718] > pkg:[firmware-ti-connectivity]:[20161130-3] > > > It's my guess, one of mysql packages didn't fully install before you ran > out of space.. but it got marked as installed... > > try this first: > > sudo apt update > sudo apt install mysql-server mysql-client --reinstall > > otherwise start with a fresh image. > > 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/3cb00b44-af81-43a9-a293-9bdce702f42b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
