Mariadb and mysql active failed or status failure

I can't start mariadb and or mysql a few hours ago after disable mysql.service and mariadb.service.

Then I do check status:

$ sudo systemctl status mysql.service
AND
$ sudo systemctl status mariadb.service

Result:

  Active: failed (Result: exit-code)
  (code=exited, status=1/FAILURE)

How to resolve this:

$ sudo systemctl disable mysql.service
$ sudo systemctl disable mariadb.service

Or do opposite (make sure both mysql.service and mariadb.service are disabled)

then, do the right step:

should do first:

$ sudo systemctl enable mysql.service

then:

$ sudo systemctl enable mariadb.service

and check:

$ sudo systemctl status mysql.service
AND
$ sudo systemctl status mariadb.service

This give me result in both service:

  Active: inactive (dead)
  (code=exited, status=0/SUCCESS)

Run test:

$ sudo systemctl start mysql.service
AND
$ sudo systemctl start mariadb.service

Yes, it works for me! Hope it help.

view raw mariadb_mysql_failure_error.md hosted with ❤ by GitHub

Order Roti

How to add user as sudoers

A few minutes ago I can't install new software in Ubuntu 14.04. It said that my user is not in the sudoers file (or something, I forgot what it clearly said in terminal). So here we go..

1. Open terminal
2. type su -
3. type your user password
4. type sudo adduser your_user_name sudo
5. just it. Hope this help :)

Apache 2.4 is running very slow or hangs

I have migrated from XAMPP (which hasn't x64 version) to WAMP (Win x64 version), after run the services several times I found my apache suddenly running very slow and hangs. I don't know exactly what have done. Now, it solved! I find this from google:

Fix:
Add this configuration snippet to Apache24/conf/httpd.conf (bottom of file seems fine):
AcceptFilter http none
AcceptFilter https none

And restart all services. Done! Hope this help.