Linked Questions
19 questions linked to/from MySQL error: Access denied for user 'a'@'localhost' (using password: YES)
31
votes
7
answers
194k
views
Access denied for user 'root'@'%'
I used to access the root user in MySQL just fine. But recently, I am no longer able to.
I am able to login fine :
mysql -u root -p
Here is the mysql status after login :
mysql> status
-------...
11
votes
6
answers
176k
views
MySQL - ERROR 1045 (28000): Access denied for user
I just installed a fresh copy of Ubuntu 10.04.2 LTS on a new machine. I logged into MySQL as root:
david@server1:~$ mysql -u root -p123
I created a new user called repl. I left host blank, so the ...
18
votes
2
answers
22k
views
MySQL GRANT PROXY - what does it mean?
I run:
show grants for root@localhost;
and I see
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
From mysql docs:
https://dev.mysql.com/doc/refman/5.5/en/proxy-users.html
This ...
6
votes
2
answers
53k
views
Grant table privileges to a user connecting from any host
I have a user account - let's call it 'wordpress' - that I need to allow to access a few catalog tables in another e-commerce database on the same server. I've configured the user with three host ...
3
votes
2
answers
15k
views
How do I allow remote mysql access to all users?
I have setup a mysql server on unbuntu. The server hosts websites for my various clients. Hence, I want all of them(and any new clients) to have remote access to the mysql server. How do I configure ...
5
votes
1
answer
6k
views
User has no password set
I see these when running MySQLTuner.pl:
-------- Security Recommendations -------------------------------------------
[!!] User '@debian' has no password set.
[!!] User '@localhost' has no password ...
4
votes
2
answers
4k
views
Best practices to secure mysql
I don't have that much knowledge about mysql and i would like to secure a MySQL server.
We have a few VPS running around the world (6 currently) and they all need to store information in our mySQL ...
1
vote
0
answers
11k
views
mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect [duplicate]
I am troubleshooting a backup script (bash), and I have limited working knowledge of the current configuration since the last 3 predecessors did not leave any documentation.
I do know that my server ...
2
votes
1
answer
2k
views
How to properly secure MySQL database?
We have a web application based on the famous triad apache + php + mysql which we sell to our customers and gets installed on their servers.
Currently, we are using MySQL 5.1.41 which has only a ...
2
votes
1
answer
2k
views
MySQL: Is there a way to find out which user called stored procedure?
Server: MySQL 5.7.14
I am following the Suggestion 1 suggested here https://dba.stackexchange.com/a/109416/126860
I am trying to find out which user called the stored procedure. But since I am also ...
1
vote
1
answer
862
views
Unable to query for thread information in mysql using root
I'm connected to a server's mySql database hosted on google cloud using the user 'root' with a password.
I was under the impression that the root user had all privileges but when I try to get the ...
2
votes
1
answer
811
views
Why do I have different usernames from mysql.user and select user()?
With 10.4.6-MariaDB on my Mac OS 10.14.5
Logged in as root I can see the list of users on my server with
MariaDB [(none)]> select Host,User from mysql.user;
+--------------+-----------+
| Host ...
3
votes
2
answers
544
views
Why ALL PRIVILEGES ON `db`.* gives access to all databases?
I've installed Ubuntu 12.10(quantal) and mysql-server-5.5.
When I execute:
drop user ''@'localhost';
create database `redmine`;
grant all on `redmine`.* to 'redmine'@'localhost';
User redmine@...
2
votes
1
answer
620
views
Why does OS login not exist in the user table, but I can still login to MySQL?
mysql> select user, password, host from user;
+------+----------+---------------------------------------------+
| user | password | host |
+------+----------+-...
1
vote
1
answer
612
views
Why does CURRENT_USER() show the root@::1 when I login to MySQL?
I've set 3 different passwords for the following accounts: 'root'@'localhost', 'root'@'127.0.0.1' and 'root'@'::1'.
By typing: mysql -u root -p I can only login with my 'root'@'::1' account password ...