Primasaja.com: Service WEB, MOBILE & SOFTWARE DEVELOPMENT , ENGINEERING & ARCHITECTURE , DESIGN & CREATIVE , ADMIN SUPPORT , SALES & MARKETING , INSTALASI JARINGAN & KOMPUTER
Email: jakaprima123@gmail.com
Phone: 081311086653
Fax: -
Url:
cash, credit card
Perum Griya Rajeg Lestari Blok C No 24
Tangerang indonesia 15540

Cara Memperbaiki Error Mysql 1045 28000 Access denied for user root localhost using password NO

0
jaka prima maulana
www.primasaja.com -

pada tutorial kali ini saya akan membahas memperbaiki error MySql tidak dapat masuk ke mysql walaupun passwordnya sudah No berikut tahap - tahapnya

1. matikan service mysql yang sedang berjalan dengan mengetikkan:

sudo /etc/init.d/mysql stop

2. lalu ketikkan:

mysqld_safe --skip-grant-tables &

3. jika errornya sama seperti ini:

mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.

buat folder dengan mengetikkan 

sudo mkdir -p /var/run/mysqld

lalu jalankan lagi mysql_safenya

4. jika info seperti ini:

mysqld_safe Logging to '/var/log/mysql/error.log'.

mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

maka sudah bisa masuk

5. ketikkan

mysql -u root 

maka anda akan mendapatkan text welcome mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 2

Server version: 5.7.25 MySQL Community Server (GPL)


Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.







Total Komentar : 0
Tidak Ada Komentar: