MySQL Tutorial Privilege 27 codes

  1. Home
  2. MySQL Tutorial
  3. Privilege
1 A user doesnt need a password if connecting from a certain machine
2 Add a user
3 Add localhost to mysql table for accessing sample_db
4 Add your database and users to the mysql database
5 Column privilege
6 Designate an IP or host address from which the user can connect
7 FLUSHing the Privileges
8 Give a non-local user permissions on the database for use with remote clients
9 Give ALL PRIVILEGES on a database to a local user who has to use a password to access the database
10 GRANT ALL
11 GRANT OPTION MAX_QUERIES_PER_HOUR 50 MAX_UPDATES_PER_HOUR 50
12 Grant Select and Update privilege to a user
13 GRANT SELECT, UPDATE ON databaseName
14 Grant select, update privilege for a remote user
15 Granting Privileges on the new database
16 In the default setting of MySQL access privileges, every user is permitted to create databases on a local computer that begin wi
17 No other database can allow any user to connect from any host
18 Removing Permissions from a Database
19 Removing Permissions from a User
20 Revoking privileges
21 Select convert(SUBSTR(USER(),1,INSTR(USER(),@)-1) using latin1)
22 SELECT host, user, select_priv, update_priv FROM user
23 Tables_priv
24 To allow a user to connect from anywhere you would use a wildcard %
25 To remove UPDATE, INSERT and DELETE privileges
26 To restrict the user to manipulating data (rather than table or database structures)
27 WITH GRANT OPTION condition allows the user to give others privileges to that database