• Home
  • WordPress
  • web Hosting
    • Free hosting
    • Cheap Hosting
    • comparison cloud , vps, shared, wordpress
    • managed wordpress hosting
    • managed cloud hosting
  • page Speed
  • Deals
  • Services
  • About

RAaz Kumar .com

wordpress tutorials seo hosting etc


mysql access denied for user ‘root’@’localhost’ (using password yes) no Error 1045

mysql access denied for user ‘root’@’localhost’ (using password yes)

First, you need to execute “FLUSH PRIVILEGES;” before executing any GRANT/CREATE/SET PASSWORD statement,

Possible cases:

  • Wrong password
  • connecting wrong Database or database not exist
  • insufficient privileges for the user to access the database,
  • user who doesn’t exist on the MySQL server
  • User exists but client host does not have permission to connect:
  • No global privilege

skip-grant-tables  (last step)

allows anyone to log in from anywhere and can do anything on the database.
nano /etc/mysql/my.cnf
edit:
[mysqld]
skip-grant-tables
service mysql restart
or
sudo /etc/init.d/mysql stop
sudo mysqld_safe –skip-grant-tables &
~$ mysql -u root
SHOW GRANTS FOR ‘zzz’@’127.0.0.1’;

password Authentication plugin maybe different

note: mysql 8 removed password column in mysql.users table

SELECT user,authentication_string,plugin,host FROM mysql.user;
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘Current-Root-Password’;
FLUSH PRIVILEGES;
Updating from auth_socket to mysql_native_password fixed my problem
/etc/mysql/my.cnf
bind-address = 0.0.0.0

cause 1 wrong password

SELECT Host, User, authentication_string, PASSWORD(‘forgotten’) FROM mysql.user WHERE User=’newrelic’;
SELECT Host, User, authentication_string, PASSWORD(Raazk23@#123) FROM mysql.user WHERE User=’newrelic’;
SELECT Host, User, authentication_string, PASSWORD FROM mysql.user WHERE User=’newrelic’;
PASSWORD(‘forgotten’) hash does not match the authentication_string column, which means password string=’forgotten’ is not the correct password to log in.

solution: Change or update MySQL user password using UPDATE statement

USE mysql;
UPDATE user SET password = PASSWORD(‘dolphin’) WHERE user = ‘dbadmin’ AND host = ‘localhost’;
FLUSH PRIVILEGES;
from 5.7mysql only use authentication string removed password column
USE mysql;
UPDATE user SET authentication_string = PASSWORD(‘Raazk23@#123’) WHERE user = ‘newrelic’ AND host = ‘localhost’;
FLUSH PRIVILEGES;
OR
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘insert_password’;

Solution 2: Grant all required privileges or permissions to user

error executing `SHOW GLOBAL VARIABLES`: Error 1045: Access denied for  user
GRANT ALL PRIVILEGES ON . to ’-your_name-’@’your-hostname’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

Case 3: client host does not have permission to connect:

hosts:

localhost, same machine

127.0.01 = same machine
‘%’ = from anywhere

possible solution 1 : Allow remote ip connections

mysql> SHOW VARIABLES LIKE ‘skip_networking’;
+—————–+——-+
| Variable_name   | Value |
+—————–+——-+
| skip_networking | OFF   |
+—————–+——-+
bind address = 127.0.0.1, ip1, ip2

mysql access denied for user ‘root’@’localhost’ (using password no) linux

  • there maybe  a password for mysql user and you not entered.
  • Possible all other errors with using password no

 

error 1045 mysql 28000 linux in phpmyadmin

 

useraccounts>>select user & edit previligios>> change password.

or Databases>>mysql>>users table>. select users>> and change the password column with native password plugin. authentication type md5.

check wordpress password reset using phpmyadmin.

 

mysql password working shell client but not from the script client

  • authentication method that the plugin implements may or may not use a password stored in the user table.
  • Passwords stored in the user table are encrypted using plugin-specific algorithms
  • ASCII characters (A-Z, 0-9, and dashes (-))vs non-ASCII characters>> client applications should call the mysql_options()

Set a password in ASCII and try

 

UPDATE user SET authentication_string = PASSWORD(‘Raazk23@#123’) WHERE user = ‘newrelic’ AND host = ‘localhost’;

 

mysql -u root -p

UPDATE user SET authentication_string = PASSWORD(‘Raazk23-234’) WHERE user = ‘newrelic’ AND host = ‘127.0.0.1’;

or

mysql> ALTER USER ‘newrelic’@’127.0.0.1’ IDENTIFIED WITH mysql_native_password BY ‘Raazk23-234’;
Query OK, 0 rows affected (0.01 sec)

 

 

 

 

Related topics:

  1. new relic mysql install integration – 2 ways fix problems
  2. wordpress password reset in 3 ways mail, phpmyadmin, mysql command
  3. new relic installation linux (infrastructure agent , php, mysql , nginx)
  4. mysql commands
  5. mysql errors

tutorials

  • Vivek Bindra Videos Transcription (business strategy)
  • git commands
  • new relic php agent install in 3 steps
  • new relic mysql install integration - 2 ways fix problems
  • new relic installation linux (infrastructure agent , php, mysql , nginx)
  • xampp tutorials 2021 installation errors fix wordpress phpmyadmin mysql apache
  • Redis performance metrics & tuning for nginx apache ubuntu & debian
  • Devops course Syllabus topics PDF AWS, Azure, cisco, redhat
  • CCNA Syllabus pdf (CCNA / CCNP vs devops vs mcsa /MCSE)
  • how to create a website free of cost on google
  • what is vpn vs proxy vs tor, http vs https, http2, tcp vs udp, kali linux sql source code injection
  • nginx server tutorials (installation, configuration, performance tuning, security)
  • MySQL Tutorial (create,connect database, update tables, export etc) Documentation & TIPS
    • mysql 8 installation on ubuntu 20.4
    • mysql auto backup ubuntu 22.04 using automysqlbackup
    • mysqltuner installation suggestions
    • mysql memory limit setting increase or decrease allocation
    • mysql open_files_limit increase to raise open file cache table definition cache
    • mysql restart ubuntu status start stop in linux windows reload
    • monitoring mysql with new relic
    • mysql access denied for user 'root'@'localhost' (using password yes) no Error 1045
    • mysql slow query log enable disable set query time ideal mysql long query time
    • mysql user creation, password , grant permissions user management guide
    • mysql root password change reset update set A-Z info
    • mysql configuration file location linux , windows , mac
    • mysqldump import /export mysql database command line, phpmyadmin, Cpanel, mysql workbench, xamp
    • MySQL query cache vs redis vs memcached buffer pool database cache
    • MySQL innodb memory allocation & usage calculation
    • mysql max connections limit check increase how to decide thread cache size
    • Innodb vs myisam (table engines row lock vs table lock)
    • mysql errors
    • mysql workbench tutorials (Sql Development , modelling, server admin export & import)
    • How measure & adjust mysql buffer pool size by pages, read requests etc
    • improve mysql performance wordpress my.cnf file configuration
    • phpmyadmin install / configure on nginx ubuntu 20.04 apache2 debian 10
    • mysql commands
  • AUdio Editing Background Noise removal (Audacity, Adobe Premiere Addition, Camtasia Filmora Windows Obs)
  • Android Studio tutorials syllabus Topics Course details #AndroidApplicationDevelopment
  • [INTRO] Ethical hacking / cyber Security / Penetration testing Tutorial -{updates frequently}
  • redis install ubuntu 20.04 with wordpress php redis mysql configuration
  • ubuntu tutorials installation download issues etc
  • Php tutorials
  • HTML & CSS Tutorials
  • Core Java Tutorial Free online
  • Linux sysadmin tutorials linux system administrator
  • apache server tutorial (install,config, performance tuning, security, error handling)

 

 

wordpress Pagespeed optimization

Digitalocean free $100 Credit

Cloudways Review pricing promo codes

Siteground cpu limits Pricing

Shared Hosting

Managed wordpress Hosting

Managed Hosting Cloud server

VPS Hosting

Cloud Hosting – Unmanaged

Google cloud Pricing

Aws Pricing

Azure pricing

nginx server tutorials

apache server tutorials

linux sysadmin tutorials

mysql Commands list pdf

LEMP Install Ubuntu

Mysql Performance Tuning

Nginx Performance tuning

Linux Performance tuning

Php -fpm performance tuning

Redis Performance tuning

linux server security

nginx security best practices

wordpress security plugins

 

 

wordpress

 

Top 5  WP Google Analytics Plugins

WP Backup Plugins

Wp Comment Plugins

Top wordpress Security Plugins

WP Seo Plugins

WP Caching Plugins

Best Adsense Plugins for WordPress

Wp social Sharing Plugins

autoshare social media plugins

WP speed Optimization Plugins

Speedup WordPress google Score

More Wp tuts

Server Admin Cloud

 

Installing Nginx LEMP On ubuntu

Installing apache Lamp ubuntu

nginx fastcgi cache enable

php – fpm install  & Configuration

Opcache install & Configure

php -fpm pool manager explained

Mysql Install & Configuration

Redis Object cache install & configure

 

Nginx as Reverse Proxy and Load balancer

Load Balance / auto scaling in google cloud

Linux Commands PDF

Mysql Commands Pdf

Letsencrypt tutorial

mysqldump export & import 

Pagespeed Module install & configure

nginx.conf best file

mysql.conf best file

upgrade ubuntu

© 2023 - All Rights Reserved Disclaimer & Privacy Policy