hosts table for database-specific privileges".
Choosing Use text field allows us to input the exact host value we want. Let's
choose Local.
Password
Even though it's possible to create a user without a password (with the No password
choice), it's best to have a password. We have to enter it twice (as we cannot see what
is entered) to confirm the intended password. Let's input bingo.
Some administrators prefer to improve security by having phpMyAdmin generate a
password itself. In the Generate Password dialog, a click on Generate puts a random
password (in clear) on-screen. At this point, we should note the password so that we
can pass it on to the user. Then a click on Copy puts this password in the Password
and Re-Type fields.
Chapter 19
[ 285 ]
Database Creation and Rights
A frequent convention is to assign to a user the rights to a database having the
same name as this user. To accomplish this, the Database for user section offers the
checkbox Create database with same name and grant all privileges; clicking this
checkbox automates the process by creating both the database and the corresponding
rights. Please note that with this method, each user would be limited to one database
(user bill, database bill).
Another possibility is to allow users to create databases that have the same prefix as
their user name; therefore the other choice Grant all privileges on wildcard name
(username\_%) performs this function by assigning a wildcard privilege.
Pages:
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260