Diana, in regard to adding and removing users. What I do is just login to the
database 'mysql' which holds the actual mysql information:
connect mysql;
Then, you can insert directly into the user table. Do you know enough about
SQL to understand how the insert statement works? Basically the Y/N fields in
the user table reflect the access this user will have to certain statements.
My advice is to look at a row for a user who your student inserted, and copy
the Y's and N's, thus giving your new user the same permissions.
Don't forget to run mysqladmin reload after you modify the user table.
In regard to creating databases: I'm not sure what you mean. Each database
should be created using the mysqladmin command:
mysqladmin create <database>
All of this is well-documented on the mysql web site, mysql.com. I suggest
you take a look at its chapters on creating users, databases, etc.
On Monday 19 November 2001 12:57 pm, DIANA CLEVELAND wrote:
> 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
---------------------------------------------------------------------
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
