MySQL Server wont start

Questions about applications and software
Forum rules
Before you post please read how to get help
Post Reply
linuxxSQL
Level 1
Level 1
Posts: 1
Joined: Sat Sep 15, 2018 5:51 pm

MySQL Server wont start

Post by linuxxSQL » Sat Sep 15, 2018 5:58 pm

hi,

i cant start a mysql server on my system

mint@mint:/var/run$ sudo service mysql restart

Code: Select all

Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
mint@mint:/var/run$ systemctl status mysql.service

Code: Select all

● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: e
   Active: failed (Result: exit-code) since Sat 2018-09-15 21:45:21 UTC; 2min 48
  Process: 24873 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exi

Sep 15 21:45:21 mint systemd[1]: mysql.service: Service hold-off time over, sche
Sep 15 21:45:21 mint systemd[1]: mysql.service: Scheduled restart job, restart c
Sep 15 21:45:21 mint systemd[1]: Stopped MySQL Community Server.
Sep 15 21:45:21 mint systemd[1]: mysql.service: Start request repeated too quick
Sep 15 21:45:21 mint systemd[1]: mysql.service: Failed with result 'exit-code'.
Sep 15 21:45:21 mint systemd[1]: Failed to start MySQL Community Server.

mint@mint:/var/run$ sudo apt-get install mysql-server

Code: Select all

Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7 mysql-server-core-5.7
Suggested packages:
  tinyca
Recommended packages:
  libhtml-template-perl
The following NEW packages will be installed:
  mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server mysql-server-5.7 mysql-server-core-5.7
0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/20.3 MB of archives.
After this operation, 160 MB of additional disk space will be used.
Do you want to continue? [Y/n] 
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 266748 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.8+1.0.4_all.deb ...
Unpacking mysql-common (5.8+1.0.4) ...
Selecting previously unselected package mysql-client-core-5.7.
Preparing to unpack .../mysql-client-core-5.7_5.7.23-0ubuntu0.18.04.1_amd64.deb ...
Unpacking mysql-client-core-5.7 (5.7.23-0ubuntu0.18.04.1) ...
Selecting previously unselected package mysql-client-5.7.
Preparing to unpack .../mysql-client-5.7_5.7.23-0ubuntu0.18.04.1_amd64.deb ...
Unpacking mysql-client-5.7 (5.7.23-0ubuntu0.18.04.1) ...
Selecting previously unselected package mysql-server-core-5.7.
Preparing to unpack .../mysql-server-core-5.7_5.7.23-0ubuntu0.18.04.1_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.23-0ubuntu0.18.04.1) ...
Setting up mysql-common (5.8+1.0.4) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-5.7.
(Reading database ... 266904 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.23-0ubuntu0.18.04.1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.23-0ubuntu0.18.04.1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.23-0ubuntu0.18.04.1_all.deb ...
Unpacking mysql-server (5.7.23-0ubuntu0.18.04.1) ...
Processing triggers for ureadahead (0.100.0-20) ...
Setting up mysql-server-core-5.7 (5.7.23-0ubuntu0.18.04.1) ...
Processing triggers for systemd (237-3ubuntu10.3) ...
Processing triggers for man-db (2.8.3-2) ...
Setting up mysql-client-core-5.7 (5.7.23-0ubuntu0.18.04.1) ...
Setting up mysql-client-5.7 (5.7.23-0ubuntu0.18.04.1) ...
Setting up mysql-server-5.7 (5.7.23-0ubuntu0.18.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
ERROR: Unable to start MySQL server:
mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 13 - Permission denied)
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ for tips on fixing common upgrade issues.
Once the problem is resolved, run apt-get --fix-broken install to retry.
dpkg: error processing package mysql-server-5.7 (--configure):
 installed mysql-server-5.7 package post-installation script subprocess returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Processing triggers for systemd (237-3ubuntu10.3) ...
Processing triggers for ureadahead (0.100.0-20) ...
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
mint@mint:/var/run$ journalctl -xe

Code: Select all

Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:22 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:22 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:35 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:47:35 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion
Sep 15 21:54:16 mint gnome-terminal-[24717]: g_menu_insert_item: assertion 'G_IS
Sep 15 21:54:52 mint gnome-terminal-[24717]: g_menu_insert_item: assertion 'G_IS
lines 1374-1396/1396 (END)
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:15 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:19 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:22 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:22 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:35 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:47:35 mint gvfsd-metadata[1764]: g_udev_device_has_property: assertion 'G_UDEV_IS_DEVICE (device)' failed
Sep 15 21:54:16 mint gnome-terminal-[24717]: g_menu_insert_item: assertion 'G_IS_MENU_ITEM (item)' failed
Sep 15 21:54:52 mint gnome-terminal-[24717]: g_menu_insert_item: assertion 'G_IS_MENU_ITEM (item)' failed

deepakdeshp
Level 11
Level 11
Posts: 3707
Joined: Sun Aug 09, 2015 10:00 am

Re: MySQL Server wont start

Post by deepakdeshp » Sun Sep 16, 2018 1:30 pm

Along with posting here you could post this at mysql and Ubuntu server forums
If I have helped you solve a problem, please add [SOLVED] to your first post title, it helps other users looking for help, and keeps the forum clean.
I am using Mint 19 Cinnamon 64 bit with AMD A8/7410 processor . Memory 8GB

User avatar
phd21
Level 16
Level 16
Posts: 6780
Joined: Thu Jan 09, 2014 9:42 pm
Location: Florida

Re: MySQL Server wont start

Post by phd21 » Sun Sep 16, 2018 5:34 pm

Hi linuxxSQL,

Welcome to the wonderful world of Linux Mint and its excellent forum!

It would help to know more about your system setup like which edition and version of Linux Mint you are using. If you run "inxi -Fxzd" and "lsusb" from the console terminal prompt, highlight the results, copy and paste them back here, that should provide enough information.

How did you install MySQL server through the Software Manager or Synaptic Package Manager (SPM) or using some other method? Why did you install MySQL for what purpose(s)?


You can always remove or remove completely (purge) MySql server from the "Synaptic Package Manager (SPM)" and reinstall it.

Hope this helps ...
Phd21: Mint KDE 17.3 & 18.3, 64-bit Awesome OS, Ancient Dell OptiPlex 780 Core2Duo E8400 3GHz,4gb Ram,256gb SDD, Video: Intel 4 Graphics, DVD Lightscribe. Why I use KDE?:https://opensource.com/life/15/4/9-reasons-to-use-kde

Post Reply

Return to “Software & Applications”