1
vote
1answer
36 views

Mysql slow.log user specific

I use a slow.log logging on my MySQL server, to catch bottlenecks in my script, but at the same time, i use phpmyadmin on this server. My script and phpmyadmin has different MySQL user accounts and ...
1
vote
1answer
179 views

Add a trust hostname in mysql

how have I to add a trusted hostname in the mysql configuration? webserver.mysomain.com dbserver.mydomain.com I would like to add the webserver.mydomain.com in the mysql database installed in the ...
0
votes
1answer
104 views

Restrict MySQL Access of Users to a Specific Domain

I'd like to create a new user in mysql which will be able to connect only from my servers. I've seen a way to do it through IP ranges or domain names (e.g. CREATE USER 'repl'@'%.mydomain.com' ...
2
votes
1answer
264 views

Limit user resources on dedicated server

Is there a WHM plugin mode or something like that which would limit the amount of resources a user on a dedicated server can use (CPU and RAM) or ideally something which gives certain users priority ...
0
votes
1answer
78 views

Migrating mysql 'users' to new machine gives off errors

I have looked at the settings a great number of times but run into the same issue. When connected to my Linux box with the 'exact' same settings, no fault. When run on a fresh machine with xampp for ...
0
votes
1answer
168 views

Mysql limit on the no of users?

We are planning migrate most of our authentication system from within our application to mysql. How many no. of user can mysql handle? I am talking about a couple of thousands at the moment and ...
2
votes
2answers
77 views

Are these MySQL user settings vulnerable?

I'm using PHPMyAdmin to manage the databases and I'm new to SQL in general. Am I suppose to keep an open anonymous user on localhost so things like Drupal can access MySQL? It seems like having a ...
5
votes
2answers
653 views

How to change user's UID&GID and what comes out of that

I have MySQL data files on a thumb drive that are used on two hosts where mysql user's UIDs differ. As a result, MySQL fails to start when it's files have 0700 perms and an unknown UID as an owner. ...
1
vote
2answers
313 views

Mysql : Number of connections in a given duration

How do I find out how many connections were made to the mysql server in a given duration?
0
votes
2answers
145 views

MySQL Development machine permissions

I'm administrating two servers who follow the model of development and production machines. The production machine is stripped bare-bone software which runs under restrictive set of rules and limited ...