Apache Friends Support Forum

Hy guys
in phpmyadmin I can create many users and these can be accessed from any host.

if I want to access from a specific IP I have to specify the ip or the dns is fine?

then I can specify certain users to act on different databases?

Basically, yes to both.

http://dev.mysql.com/doc/mysql-security ... users.html

ok friend...thanks

another question...i should to know what means grant option....
because i ve created a new user with only grant privileges.....
I had understood that with these permits could change the privileges of other users ...
but if I access the mysql console with this last user (only :grant yes) and I try to change the privileges of another user is given me error

I'm confused at what you are saying there, but I'll give this a shot. It's been a long time since I've looked at GRANTs. If you have GRANT abilities, you can grant the same permissions you have access to. So if I can SELECT on a database and I have GRANT access, I can only grant SELECT to another. So if I only have GRANT, but nothing else (SELECT, INSERT, UPDATE, etc.), then I can't grant anything to another. If I missed what you were trying to explain, let me know.

http://dev.mysql.com/doc/refman/5.6/en/grant.html

it 's all ok
thanks