Boston Linux & UNIX was originally founded in 1994 as part of The Boston Computer Society. We meet on the third Wednesday of each month, online, via Jitsi Meet.

BLU Discuss list archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Discuss] mysql problem



running fc26 on acer aspire laptop
using mariadb

mysql been running fine for months.

suddenly:

# mysql

ERROR 2002 (HY000): Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111 "Connection
refused")

# dnf install mariadb
# dnf install mariadb-server

both indicated everything was already installed.

# systemctl enable mariadb.service

produced no errors

# systemctl start  mariadb.service

produced this:

> ? mariadb.service - MariaDB 10.1 database server
>   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
>   Active: failed (Result: exit-code) since Thu 2018-02-01 15:46:02 EST; 13min ago
>  Process: 20074 ExecStart=/usr/libexec/mysqld --basedir=/usr $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=1/FAILURE)
>  Process: 20000 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mariadb.service (code=exited, status=0/SUCCESS)
>  Process: 19970 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS)
> Main PID: 20074 (code=exited, status=1/FAILURE)
>
> Feb 01 15:46:01 rigel systemd[1]: Starting MariaDB 10.1 database server...
> Feb 01 15:46:01 rigel mysql-check-socket[19970]: Socket file /var/lib/mysql/mysql.sock exists.
> Feb 01 15:46:01 rigel mysql-check-socket[19970]: No process is using /var/lib/mysql/mysql.sock, which means it is a garbage, so it will be removed automatically.
> Feb 01 15:46:01 rigel mysql-prepare-db-dir[20000]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
> Feb 01 15:46:01 rigel mysql-prepare-db-dir[20000]: If this is not the case, make sure the /var/lib/mysql is empty before running mysql-prepare-db-dir.
> Feb 01 15:46:01 rigel mysqld[20074]: 2018-02-01 15:46:01 140518537700544 [Note] /usr/libexec/mysqld (mysqld 10.1.30-MariaDB) starting as process 20074 ...
> Feb 01 15:46:02 rigel systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
> Feb 01 15:46:02 rigel systemd[1]: Failed to start MariaDB 10.1 database server.
> Feb 01 15:46:02 rigel systemd[1]: mariadb.service: Unit entered failed state.
> Feb 01 15:46:02 rigel systemd[1]: mariadb.service: Failed with result 'exit-code'.

any suggestions as to what might have happened, or what i should do?

ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[no html pls]



BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org