We had a student setup the MySQL program and had written instructions on how to add
users. Somehow those instructions got lost. I tried a grant command and an insert
command but neither gave me a line in db that looked like the ones previous. How do I
remove those lines to try again? Also do I need to create a database before the
insert command or will the insert command create the database as well as the user if
they don't exist?
I am running version 3.22.32 on AIX 4.3.3.
A line from the db file looks like:
| localhost | wolfe\_% | wolfe | Y | Y | Y
| Y | Y | Y | N | Y | Y
| Y |
with this header:
| Host | Db | User | Select_priv | Insert_priv | Update_priv
| Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_
riv | Alter_priv |
a line from the user file looks like:
| N | N | N | N | N |
| localhost | wolfe | encrypted password here| N | N | N
| N | N | N | N | N | N
| N | N | N | N | N |
with a header line of :
| Host | User | Password | Select_priv | Insert_priv | Update_
riv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Pro
ess_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
Thank you,
Diana
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
