• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Jaranguda

Belajar Mengajar

  • Home
  • Sponsor/Jasa
  • Tentang

MySQL Error Access denied for user Debian

Last Updated on 25 November 2016 By tommy Leave a Comment

Error yang muncul

● mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: active (running) since Fri 2016-11-25 23:37:14 WIB; 2min 6s ago
  Process: 31020 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 31049 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
   CGroup: /system.slice/mysql.service
           ├─31077 /bin/sh /usr/bin/mysqld_safe
           └─31437 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/log/mysql/error.log --pi...
 
Nov 25 23:37:14 load-balancing mysql[31049]: Starting MySQL database server: mysqld ..
Nov 25 23:37:14 load-balancing mysql[31049]: Checking for tables which need an upgrade, are corrupt or were
Nov 25 23:37:14 load-balancing mysql[31049]: not closed cleanly..
Nov 25 23:37:14 load-balancing systemd[1]: Started LSB: Start and stop the mysql database server daemon.
Nov 25 23:37:14 load-balancing /etc/mysql/debian-start[31495]: Upgrading MySQL tables if necessary.
Nov 25 23:37:14 load-balancing /etc/mysql/debian-start[31514]: Checking for insecure root accounts.
Nov 25 23:37:14 load-balancing mysql[31049]: ERROR 1045 (28000): Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)

Error tersebut karena user bawaan Debian debian-sys-maint ngga bisa login ke MySQL/MariaDB.

Solusi

Cek password yang saat ini digunakan debian-sys-maint

cat /etc/mysql/debian.cnf
### output
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = kjIsdaf1248FGq5HA
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = kjIsdaf1248FGq5HA
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

lihat di bagian password, selanjutnya login ke MySQL sebagai root

mysql -u root -p

dan berikan akses penuh ke user debian-sys-maint

GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'kjIsdaf1248FGq5HA';

Sampai disini sudah selesai. Untuk melihat log MySQL Debian, cek /var/log/mysql/error.log

Tulisan menarik lainnya

  • Mengatasi Error MySQL Unknown/unsupported storage engine: InnoDB

    Error sewaktu menjalankan MySQL $ service mysql start [FAIL] Starting MySQL database server: mysqld .…

  • Cara Mereset Password MySQL Server

    Untuk mereset password mysql server ini adalah anda harus memiliki hak akses root, karena kita…

  • Mengatasi Error mysql.service has failed

    Log errornya dilihat dari journal -xn -- Unit mysql.service has begun starting up. Feb 12…

  • Mengatasi Error MySQL logger: command not found Debian

    Error yang muncul sewaktu menginstall mysql di Debian 7 Setting up mysql-server-5.5 (5.5.40-0+wheezy1) ... debconf:…

Filed Under: Linux Tagged With: debian 8, mysql

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Pencarian

Tanya Jawab tentang DevOps SRE CPE, gabung di https://t.me/devopsindonesia

Terbaru

  • Cara Mengganti Port Screen Sharing macOS
  • Cara Menonaktifkan Pager di macOS
  • Cara Mengupdate Nama Apple silicon-as-a-Service Scaleway
  • Cara Force Delete Namespace di Kubernetes
  • Install PHP MariaDB di Mac Monterey

Komentar

  • adi on Menggunakan Mikrotik Sebagai SSH Client
  • aris u on Solusi Simple Queue Mikrotik Tidak Berjalan
  • Bowo on Cara Mematikan SSID Molecool Balifiber
  • aris on Solusi Simple Queue Mikrotik Tidak Berjalan
  • Alief on Password Router Huawei HG8245H5 Indihome

Tulisan Populer

  • Password Router Huawei HG8245H5 Indihome 1.1m views
  • Password Terbaru ZTE F609 Indihome 784.5k views
  • Password Superadmin Huawei HG8245A 318k views
  • Cara Setting Manual Modem GPON ZTE F609 Indihome 273k views
  • Cara Setting Wireless ZTE F609 Indihome 257.1k views
  • Mengaktifkan Port LAN di Huawei HG8245 Indihome 169.8k views
  • Akses UseeTV Indihome via Wireless ZTE F609 156.8k views
  • Kemana Menghilangnya Saldo BCA 50 ribu 153k views
  • Cara Reset Password ZTE F609 Indihome 147.5k views
  • Cara Setting DHCP Server Modem/Router ZTE F609 113.5k views

Kategori

  • Delphi
  • dll
  • Gambas
  • Internet
  • Java
  • Lazarus
  • Linux
  • PHP
  • Review
  • Teknologi

Sponsor

kadal.id
carakami.com
kuotabisa.com
Untuk jadi sponsor, hubungi kita lewat halaman sponsor
© 2021. Jaranguda
  • Linux
  • PHP
  • Internet
  • Teknologi
  • Delphi
  • Gambas
  • Java