Mageia Bugzilla – Attachment 9775 Details for
Bug 21982
Can not connect to the local MYSQL server when running mysql_secure_installation as root as suggested after installing task-lamp
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Requests
|
Help
|
Log In
[x]
|
New Account
|
Forgot Password
Result of systemctl status mysql and mysqld
systemctl mysql and mysqld (text/plain), 3.14 KB, created by
Kristoffer Grundström
on 2017-11-05 21:46:12 CET
(
hide
)
Description:
Result of systemctl status mysql and mysqld
Filename:
MIME Type:
Creator:
Kristoffer Grundström
Created:
2017-11-05 21:46:12 CET
Size:
3.14 KB
patch
obsolete
>[root@localhost ~]# systemctl status mysql >Failed to dump process list, ignoring: Unit mysql.service not found. >â mysql.service > Loaded: not-found (Reason: No such file or directory) > Active: inactive (dead) >[root@localhost ~]# systemctl status mysqld >â mysqld.service - MySQL database server > Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor prese > Active: active (running) since sön 2017-11-05 21:40:51 CET; 3min 1s ago > Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, statu > Main PID: 1532 (mysqld) > Status: "Taking your SQL requests now..." > CGroup: /system.slice/mysqld.service > ââ1532 /usr/sbin/mysqld > >nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653 >nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653 >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057594 >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653 >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653 >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653 >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit >nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit >nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB' >nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server. >lines 1-19/19 (END)...skipping... >â mysqld.service - MySQL database server > Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: enabled) > Active: active (running) since sön 2017-11-05 21:40:51 CET; 3min 1s ago > Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS) > Main PID: 1532 (mysqld) > Status: "Taking your SQL requests now..." > CGroup: /system.slice/mysqld.service > ââ1532 /usr/sbin/mysqld > >nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB: Waiting for purge to sta >nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB: Percona XtraDB (http:// >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140575942633216 [Note] InnoDB: Dumping buffer pool(s) n >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [Warning] mysqld: GSSAPI plugin : defau >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] mysqld: Server GSSAPI error (ma >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] Plugin 'gssapi' init function r >nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: MariaDB Audit Plugin version 1.4.2 STARTED. >nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: Query cache is enabled with the TABLE events. >nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 M >nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server.
[root@localhost ~]# systemctl status mysql Failed to dump process list, ignoring: Unit mysql.service not found. â mysql.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [root@localhost ~]# systemctl status mysqld â mysqld.service - MySQL database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor prese Active: active (running) since sön 2017-11-05 21:40:51 CET; 3min 1s ago Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, statu Main PID: 1532 (mysqld) Status: "Taking your SQL requests now..." CGroup: /system.slice/mysqld.service ââ1532 /usr/sbin/mysqld nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653 nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 14057653 nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057594 nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653 nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653 nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 14057653 nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB' nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server. lines 1-19/19 (END)...skipping... â mysqld.service - MySQL database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: enabled) Active: active (running) since sön 2017-11-05 21:40:51 CET; 3min 1s ago Process: 1464 ExecStartPre=/usr/sbin/mysqld-prepare-db-dir (code=exited, status=0/SUCCESS) Main PID: 1532 (mysqld) Status: "Taking your SQL requests now..." CGroup: /system.slice/mysqld.service ââ1532 /usr/sbin/mysqld nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB: Waiting for purge to sta nov 05 21:40:49 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:49 140576539478080 [Note] InnoDB: Percona XtraDB (http:// nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140575942633216 [Note] InnoDB: Dumping buffer pool(s) n nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [Warning] mysqld: GSSAPI plugin : defau nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] mysqld: Server GSSAPI error (ma nov 05 21:40:50 localhost.localdomain mysqld[1532]: 2017-11-05 21:40:50 140576539478080 [ERROR] Plugin 'gssapi' init function r nov 05 21:40:50 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: MariaDB Audit Plugin version 1.4.2 STARTED. nov 05 21:40:51 localhost.localdomain mysqld[1532]: 171105 21:40:50 server_audit: Query cache is enabled with the TABLE events. nov 05 21:40:51 localhost.localdomain mysqld[1532]: Version: '10.1.28-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 0 M nov 05 21:40:51 localhost.localdomain systemd[1]: Started MySQL database server.
View Attachment As Raw
Actions:
View
Attachments on
bug 21982
: 9775