Linked Questions
10 questions linked to/from Cannot drop anonymous user from mysql.user
0
votes
1
answer
2k
views
xenforo vulnerability, limit max open connections by ip address
Trying to get some emergency help because my website is being attacked. It isn't as much as an actual attack, as it is a small bot to exploit xenforo vulnerability.
https://xenforo.com/community/...
- 1
5
votes
2
answers
11k
views
Only "grant usage", but can still select, drop, create?
I have a mysql user (I'll call) "user5" who only has "grant usage" (i.e. no privileges) in the output of "show grants", but can still do a select on database "app_db" (which is what I want, but I do ...
- 175
2
votes
2
answers
248
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 ...
- 123
1
vote
1
answer
3k
views
Error in login in with root user in new mysql server
I've installed a MySQL server in CentOS 6.2 machine
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------...
- 113
3
votes
2
answers
545
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@...
- 131
2
votes
1
answer
622
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 |
+------+----------+-...
- 3,467
2
votes
1
answer
186
views
mysqladmin user account not secure?
I still playing with my own DB trying to learn and saw this:
I could change the root password without any problem at all... If I'm in the server I can create an algorithm to start testing password ...
- 2,009
6
votes
3
answers
16k
views
Mysql users deleted
I have a fresh centos 6.2 with mysql in 5.1.52. Then I saw two empty user name and I deleted that then I saw 3 root user deleted that and created one like this CREATE USER 'root'@'%' IDENTIFIED BY '*...
- 979
36
votes
1
answer
9k
views
MySQL : Why are there "test" entries in mysql.db?
Recently, I posted an answer to a question about mysql.db.
Then, I got to thinking I should ask everyone this question:
I have noticed for years that upon installation of MySQL 5.0+, mysql.db is ...
- 184k
6
votes
3
answers
15k
views
What is the mysql.db table used for?
Related to my MySQL issue
I have a user with USAGE grant in mysql.user, but in mysql.db this user has Select, Insert, Update, Delete. Thus the user can successfully query the database.
I can't find ...
- 162