Linked Questions

31 votes
7 answers

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 -------...
user avatar
11 votes
6 answers

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 ...
davidjhp's user avatar
  • 429
18 votes
2 answers

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: This ...
Darius.V's user avatar
  • 281
6 votes
2 answers

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 ...
db2's user avatar
  • 9,658
3 votes
2 answers

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 ...
user avatar
5 votes
1 answer

User has no password set

I see these when running -------- Security Recommendations ------------------------------------------- [!!] User '@debian' has no password set. [!!] User '@localhost' has no password ...
alfish's user avatar
  • 2,964
4 votes
2 answers

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 ...
bl0b's user avatar
  • 353
1 vote
0 answers

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 ...
filoxo's user avatar
  • 111
2 votes
1 answer

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 ...
Matteo Tassinari's user avatar
2 votes
1 answer

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 I am trying to find out which user called the stored procedure. But since I am also ...
nwarriorch's user avatar
1 vote
1 answer

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 ...
user161733's user avatar
2 votes
1 answer

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 ...
OrigamiEye's user avatar
3 votes
2 answers

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@...
Basilevs's user avatar
  • 131
2 votes
1 answer

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 | +------+----------+-...
qazwsx's user avatar
  • 3,447
1 vote
1 answer

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'@'' and 'root'@'::1'. By typing: mysql -u root -p I can only login with my 'root'@'::1' account password ...
JConstantine's user avatar

15 30 50 per page