Problems installing MySQL on Beaglebone black Debian 8

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:

Then I run the commands suggested I got the following outputs:

I’ve tried to stop and start the mysql.service but is not working. I would really aprecciate if you could help me. Thanks

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,

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:

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?:

yeah, just reflash.. Your partition is corrupted from the failed install
when you ran out of space..

Regards,

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.