All Questions
Tagged with authentication mysql
47 questions
0
votes
1
answer
104
views
MySQL CLI asks for password but doesn't use it
I'm trying to connect to a remote MySQL database for replication.
The database is on a machine that's part of a secured network, so after opening the security enough to allow my replication ...
- 11
2
votes
1
answer
5k
views
How do I change the Authentication Plugin for users mysql.sys, mysql.session, etc?
I use MySQL version 8.0.34 on a Debian server.
With the latest update I get the message that mysql_native_password is deprecated and I should rather use caching_sha2_password instead.
With my own ...
- 33
1
vote
2
answers
17k
views
How to correctly replace 'default_authentication_plugin' with 'authentication_policy'?
I have MySQL 8.0.33 on Ubuntu. In the error log, I see the following warning:
[Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. ...
7
votes
2
answers
20k
views
How to start MySQL after failure?
After I reboot my server, I can no longer start mysql.
I have followed several solutions posted here:
This
This
Or this
Did not help much... :(
I run the following commands to start the service:
...
- 61
0
votes
0
answers
113
views
Is it possible to use check_user_proxy on AWS RDS?
My top-level goal is to enable two-user (zero-downtime) secret rotation for RDS users. To recap/summarize the approach, you always have two accounts in your DB that have equivalent access. You switch ...
- 101
0
votes
2
answers
885
views
Designating no password for account in MySQL config file
This is a theoretical question because having a DB account with no password is a terrible idea.
Question: Is there a way to designate an account with no password in the MySQL config file?
- 265
1
vote
0
answers
672
views
Why is the authentication_string different from the other one if the passwords are the same?
I've set the same passwords for the following accounts: 'root'@'%', 'root'@'127.0.0.1'.
When I type select user, host, authentication_string from mysql.user I get different values for the ...
- 141
0
votes
2
answers
8k
views
How can I find out if a user's password has expired in MySQL?
How can I find out if a user's password has expired in MySQL?
The MySQL version I'm using is 8.0.16.
- 21
0
votes
1
answer
3k
views
Access denied for user 'me'@'localhost' (using password: NO)
I am am trying to learn mysql 101. Doing so, I broke my ability to login as root.
At first I could simply connect to mysql by running
sudo mysql
In an attempt to alleviate a problem, I thoughtlessly ...
- 233
2
votes
1
answer
3k
views
MySQL change user login from one plugin type to another
I'm in the process of testing MySQL 8.0.
I have set up a test database, and the first thing I want to do is import my user account from MySQL 5.7.
So to do this I run:
/*ON MySQL 5.7*/
SHOW CREATE ...
- 2,276
0
votes
1
answer
128
views
Should i place Registered-Users Info in every table? to Restrict user access to his Own Data only
Database: Relational Database - MySQL
I am making a database with multiple tables. In order to see his data from tables, User will need to log in. I only need to display those information(through web-...
1
vote
1
answer
174
views
How to use mysql_plugin utility?
I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that
Cannot read plugin config file unix_socket. Bad format in plugin
...
- 135
0
votes
2
answers
1k
views
Percona PAM with AD authentication using SSSD
I have installed Percona PAm plugin on my Percona server as shown below:
mysql> show plugins;
...
| auth_pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL |
| ...
- 343
1
vote
1
answer
1k
views
How to verify if given user@host with 'password' exists in MySQL 8.0+?
I write sanity check script for an application. One of the tests is supposed to verify that a given user@host with 'password' exists in MySQL. I'm using simple native hash passwords. In MySQL5.7- ...
- 203
1
vote
2
answers
523
views
Where is the cache for the MySQL caching_sha2_password auth plugin stored?
Where is the cache for the new default authentication plugin caching_sha2_password in MySQL 8 stored? I want to know for future reference how to clear it in case I ever run into any problems using it.
- 505