MySQL in a Nutshell, 2nd Edition

Name

mysql_setpermission

Synopsis

mysql_setpermission options

This utility is an interactive Perl program that allows an administrator to set user privileges. To run the program, you would typically give the --user option with the administrative username so you can set privileges. A text menu of options will be displayed for a variety of user administration tasks, including setting the password and privileges for an existing user and creating a new user. The program requires that Perl and the Perl DBI module be installed on the system where it’s executed.

mysql_setpermission options

--host

This option specifies the name or IP address of the server for connection.

--help

This option displays help information about the utility.

--password=password

This option provides the password of the administrative user with which the utility is to log into the server, not the user for which to change privileges.

--port=port

This option specifies the port number to use for connecting to the server.

--user=user

This option provides the administrative username for logging into the server, not the user for which to change privileges.

--socket=filename

This option provides the name of the server’s socket file.