ERROR 1045 (28000) Access denied for user
I have been trying to connect from a workstation to server. I have turned on ssl.
I can login into mysql locally on the server. I can telnet to server from workstation on port 3306. Hostname in db matches what is shown in the error message. The hostname does not contain a domain just the hostname. plugin is cached_sha2_password. I have tried turning on mysql_native_password and changing plugin in mysql.user to mysql_native_password and get same result. Workstation and server are both running Fedora Linux 40. Wireshark is installed on both but only run on workstation. Wireshark shows that connection was made and login request was made for user. Caching_sha2_password perform_full_authentiation, caching_sha2_password unknown.
Server my.cnf:
[mysqld]
server_id=1
bind-address=0.0.0.0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log_bin=binlog
log-error=/var/log/mysqld.log
pid-file=/run/mysqld/mysqld.pid
mysql-native-password=on
default-storage-engine=myisam
ssl_ca=/var/lib/mysql/ca.pem
ssl_cert=/var/lib/mysql/server-cert.pem
ssl_key=/var/lib/mysql/server-key.pem
require_secure_transport=on
ssl-capath=/var/lib/mysql
Workstation my.cnf:
[client]
ssl-ca=/var/lib/mysql/data/ca.pem
ssl-cert=/var/lib/mysql/data/client-cert.pem
ssl-key=/var/lib/mysql/data/client-key.pem
ssl-capath=/var/lib/mysql/data
host=192.168.105.55
default-auth=caching_sha2_password
I have worked on this for a few days with lots of internet research and solutions tried. None of the suggestions has allowed remote login.
Let me know what information is needed and what I need to do to make this work.
Subject
Written By
Posted
ERROR 1045 (28000) Access denied for user
November 05, 2024 01:12AM
November 06, 2024 01:35PM
November 08, 2024 11:49AM
November 09, 2024 12:59AM
November 11, 2024 08:13AM
November 12, 2024 01:02PM
November 14, 2024 04:29AM
November 14, 2024 12:32PM
November 15, 2024 06:36AM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.