Linked Questions

29
votes
4answers
146k 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 -------...
7
votes
4answers
91k 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 ...
6
votes
2answers
51k 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 ...
2
votes
2answers
14k 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 ...
12
votes
1answer
11k 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 ...
5
votes
1answer
5k 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
2answers
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 ...
2
votes
1answer
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 ...
1
vote
0answers
1k 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 ...
3
votes
2answers
519 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
1answer
430 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
1answer
259 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
1answer
330 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 ...
2
votes
2answers
218 views

Beginner problems administering users on mysql

Very new MySQL user here. Two questions for the community. I seem to have created an account that I can't delete/drop. I can't seem to get MySQL to actually require newly created accounts to require ...
1
vote
1answer
259 views

My MySQL Server Died

Approximately 1 time per week my MySQL server is shutting down. This is what the log looks like: 2016-03-18 13:46:25 13166 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (...

15 30 50 per page