phpmyadmin 4 newbie

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

phpmyadmin 4 newbie

Postby soxnaples » 30. September 2014 15:56

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?
soxnaples
 
Posts: 3
Joined: 30. September 2014 15:35
Operating System: windows,linux

Re: phpmyadmin 4 newbie

Postby JJ_Tagy » 30. September 2014 16:09

JJ_Tagy
 
Posts: 678
Joined: 30. January 2012 13:44
Operating System: Windows 10 Pro x64

Re: phpmyadmin 4 newbie

Postby soxnaples » 30. September 2014 17:43

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
soxnaples
 
Posts: 3
Joined: 30. September 2014 15:35
Operating System: windows,linux

Re: phpmyadmin 4 newbie

Postby JJ_Tagy » 01. October 2014 02:21

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
JJ_Tagy
 
Posts: 678
Joined: 30. January 2012 13:44
Operating System: Windows 10 Pro x64

Re: phpmyadmin 4 newbie

Postby soxnaples » 01. October 2014 16:02

it 's all ok
thanks
soxnaples
 
Posts: 3
Joined: 30. September 2014 15:35
Operating System: windows,linux


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 4 guests