![]() ![]() > 'GRANT ALL PRIVILEGES ON `testgrounds`. > 'GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY PASSWORD \'*4ACFE3202A5FF5CF467898FC58AAB1D615029441\' WITH GRANT OPTION' I had to restore the privileges for user root because i was experimenting and i messed them up, so i think before doing that i could actually use the statement in the book (i dont remember 100%) -> select current_user ![]() Can't find any matching row in the user tableīut it succeds if I use a password: ->grant select on testgrounds.personas to identified by 'pass' TO bivv-acclocalhost Check the manual which says: If an identifier contains special characters or is a reserved word, you must quote it whenever you refer to it. Specifically, for users who have privileges at the global level, partialrevokes enables privileges for specific schemas to be revoked while leaving the privileges in place for other schemas. The IDENTIFIED BY clause indicates that a password is set for that user. This creates a MySQL user hugh (with no password) and allows him to pass on his privileges for the music database to other users. It corresponds to a row in the er table with no privileges set. They merely have permission to use the MySQL server, hence USAGE. ![]() TO 'username''localhost' With that command, we've told MySQL to: GRANT the PRIVILEGES of type ALL (thus everything of course). It is possible to grant privileges that apply globally if the partialrevokes system variable is enabled. USAGE is a way to tell MySQL that an account exists without conferring any real privileges to that account. To GRANT ALL privileges to a user, allowing that user full control over a specific database, use the following syntax: mysql> GRANT ALL PRIVILEGES ON databasename. The format is based on MySQL GRANT statement. Im reading O'Relly "Learning MySQL" and it says that you can create a user in MySQL by doing just this: mysql> GRANT ALL ON *.* TO IDENTIFIED BY 'the_password' īut if I try to do: -> grant select on testgrounds.personas to Error Code: 1133. 4.12 Privilege Restriction Using Partial Revokes. Multiple privileges can be specified by separating each one using a forward slash: db.table1:priv/db.table2:priv. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |