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,