mysql

Apr
07
2021
MariaDB Service Start Stuck at Activating

MariaDB Service Start Stuck at Activating

,
Some times when MariaDB installed first time, it runs ok but after System reboot, its start creating problems i.e. MariaDB service stuck at Activating state. if you try to start it, its seems keep waiting in staring state and when check status using command systemctl status mariadb.service its shows status like Active: activating (start) in journalctl -xe output you see errors like  AVC apparmor="DENIED" Reason for this problem is that, you probably have MySQL installed beforehand. Mean first this server had MySQL server installed and upgraded it to MariaDB server. It is a known bug: MySQL installs an AppArmor profile, and the…
Read More
May
13
2016
MySQL Update – MySQL Upgrade

MySQL Update – MySQL Upgrade

, ,
MySQL update process some times create issues like, MySQL server doesn't start. when you perform MySQL update using yum update or yum update mysql or yum update mysql-server before restarting or stopping server  , you need to run command mysql_upgrade or mysql_upgrade -uroot -p MySQL Update Errors some time mysql server stop and doesn't start and you are unable to perform mysql_upgrade command, you get error like this in mysql logs  /var/log/mysqld.log [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' [ERROR] Fatal error: mysql.user table is damaged.…
Read More