Package: mysql-server-4.1
Version: 4.1.11a-4
mysql_setpermission is broken in this package. Attempting
to use menu option #4 (``Create/append database
administrative privileges for an existing database and
host combination'') causes the script to crash with
Incorrect usage of DB GRANT and GLOBAL PRIVILEGES at
/usr/bin/mysql_setpermission line 260, <STDIN> line 15.
Transcript as follows:
ious:/etc/apt# mysql_setpermission
Password for user to connect to MySQL:
######################################################################
## Welcome to the permission setter 1.3 for MySQL.
## made by Luuk de Boer
######################################################################
What would you like to do:
1. Set password for an existing user.
2. Create a database + user privilege for that database
and host combination (user can only do SELECT)
3. Create/append user privilege for an existing database
and host combination (user can only do SELECT)
4. 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)
6. 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)
8. Remove all privileges for for an existing database and
host combination.
(user will have all permission fields set to N)
0. exit this program
Make your choice [1,2,3,4,5,6,7,0]: 2
Which database would you like to add: fishsoup
The new database fishsoup will be created
What username is to be created: fishsoup
Username = fishsoup
Would you like to set a password for fishsoup [y/n]: n
We won't set a password so the user doesn't have to use it
We now need to know from what host(s) the user will connect.
Keep in mind that % means 'from any host' ...
The host please: localhost
Would you like to add another host [yes/no]: no
Okay we keep it with this ...
The following host(s) will be used: localhost.
######################################################################
That was it ... here is an overview of what you gave to me:
The database name : fishsoup
The username : fishsoup
The host(s) : localhost
######################################################################
Are you pretty sure you would like to implement this [yes/no]: yes
Okay ... let's go then ...
Everything is inserted and mysql privileges have been reloaded.
######################################################################
## Welcome to the permission setter 1.3 for MySQL.
## made by Luuk de Boer
######################################################################
What would you like to do:
1. Set password for an existing user.
2. Create a database + user privilege for that database
and host combination (user can only do SELECT)
3. Create/append user privilege for an existing database
and host combination (user can only do SELECT)
4. 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)
6. 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)
8. Remove all privileges for for an existing database and
host combination.
(user will have all permission fields set to N)
0. exit this program
Make your choice [1,2,3,4,5,6,7,0]: 6
Which database from existing databases would you like to select:
You can choose from:
- fishsoup
- mysql
Which database will it be (case sensitive). Type * for any:
fishsoup
The database fishsoup will be used.
What username is to be created: fishsoup
Username = fishsoup
Would you like to set a password for fishsoup [y/n]: n
We won't set a password so the user doesn't have to use it
We now need to know from what host(s) the user will connect.
Keep in mind that % means 'from any host' ...
The host please: localhost
Would you like to add another host [yes/no]: no
Okay we keep it with this ...
The following host(s) will be used: localhost.
######################################################################
That was it ... here is an overview of what you gave to me:
The database name : fishsoup
The username : fishsoup
The host(s) : localhost
######################################################################
Are you pretty sure you would like to implement this [yes/no]: yes
Okay ... let's go then ...
Incorrect usage of DB GRANT and GLOBAL PRIVILEGES at
/usr/bin/mysql_setpermission line 260, <STDIN> line 15.
--
``... one of the main causes of the fall of the Roman Empire
was that, lacking zero, they had no way to indicate successful
termination of their C programs.'' (Robert Firth)
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
