The mysql_setpermission Program

$ mysql_setpermission --user=root --password=the_mysql_root_password
######################################################################
## Welcome to the permission setter 1.3 for MySQL.
## made by Luuk de Boer
######################################################################
What would you like to do. Set password for an existing user. Create a database + user privilege for that database and host combination (user can only do SELECT. Create/append user privilege for an existing database and host combination (user can only do SELECT. Create/append broader user privileges for an existing database and host combination
(user can do SELECT,INSERT,UPDATE,DELETE)
5. Create/append quite extended user privileges for an existing database and host combination (user can do
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,
LOCK TABLES,CREATE TEMPORARY TABLES. Create/append database administrative privileges for an existing database and host combination (user can do
SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,INDEX,LOCK TABLES,
CREATE TEMPORARY TABLES,SHOW DATABASES,PROCESS)
7. Create/append full privileges for an existing database and host combination (user has FULL privilege. Remove all privileges for for an existing database and host combination.
(user will have all permission fields set to N. exit this program
Make your choice The program’s very easy to use for example, let’s choose option number to set the password for the user allmusic connecting from localhost
:
Setting anew) password fora user.
For which user do you want to specify a password allmusic
Username = allmusic
Would you like to set a password for allmusic [y/n]: y
What password do you want to specify for allmusic: the_password
Type the password again the_password
We now need to know which host for allmusic we have to change.
Choose from the following hosts- localhost
The host please (case sensitive localhost
The following host will be used localhost.
######################################################################
That was it ... here is an overview of what you gave to me:
The username : allmusic
The host : localhost
######################################################################
Are you pretty sure you would like to implement this [yes/no]: yes
Okay ... let's go then ...

Download 4.24 Mb.

Share with your friends: