WikiSysop: Fix incorrect wiki formatting in GRANT statement

2023-11-05T20:34:00Z

Fix incorrect wiki formatting in GRANT statement

← Older revision		Revision as of 22:34, 5 November 2023
Line 1:		Line 1:
	To avoid any security risks the refbase ''install.php'' script adds a new MySQL user to the MySQL database during installation. This user is granted only those permissions that are required to access the literature database. If you want to add this MySQL user manually (i.e. without ''install.php''), run the MySQL command interpreter with root permissions and use the following <code>GRANT</code> statement:		To avoid any security risks the refbase ''install.php'' script adds a new MySQL user to the MySQL database during installation. This user is granted only those permissions that are required to access the literature database. If you want to add this MySQL user manually (i.e. without ''install.php''), run the MySQL command interpreter with root permissions and use the following <code>GRANT</code> statement:

	GRANT SELECT,INSERT,UPDATE,DELETE ON ''MYSQL_DATABASE_NAME_GOES_HERE''.* TO ''MYSQL_USER_NAME_GOES_HERE''@localhost IDENTIFIED BY '''MYSQL_PASSWORD_GOES_HERE''';		GRANT SELECT,INSERT,UPDATE,DELETE ON ''MYSQL_DATABASE_NAME_GOES_HERE''.* TO ''MYSQL_USER_NAME_GOES_HERE''@localhost IDENTIFIED BY <nowiki>'</nowiki>''MYSQL_PASSWORD_GOES_HERE''<nowiki>'</nowiki>;

	The italic items within the above statement must match the information you've provided in ''initialize/db.inc.php''. As an example, if you've entered the following in ''initialize/db.inc.php'':		The italic items within the above statement must match the information you've provided in ''initialize/db.inc.php''. As an example, if you've entered the following in ''initialize/db.inc.php'':

WikiSysop: Original page content from 07-Feb-2006

2023-11-05T20:28:36Z

Original page content from 07-Feb-2006

New page

To avoid any security risks the refbase ''install.php'' script adds a new MySQL user to the MySQL database during installation. This user is granted only those permissions that are required to access the literature database. If you want to add this MySQL user manually (i.e. without ''install.php''), run the MySQL command interpreter with root permissions and use the following <code>GRANT</code> statement:

GRANT SELECT,INSERT,UPDATE,DELETE ON ''MYSQL_DATABASE_NAME_GOES_HERE''.* TO ''MYSQL_USER_NAME_GOES_HERE''@localhost IDENTIFIED BY '''MYSQL_PASSWORD_GOES_HERE''';

The italic items within the above statement must match the information you've provided in ''initialize/db.inc.php''. As an example, if you've entered the following in ''initialize/db.inc.php'':

$hostName = "localhost";
$databaseName = "literature";
$username = "litwww";
$password = "%l1t3ratur3?";

your <code>GRANT</code> statement would read:

GRANT SELECT,INSERT,UPDATE,DELETE ON literature.* TO litwww@localhost IDENTIFIED BY '%l1t3ratur3?';

This adds a new user ''litwww'' to the ''user'' & ''db'' tables of the ''mysql'' database and allows him to use only the SQL statements <code>SELECT</code>, <code>INSERT</code>, <code>UPDATE</code> and <code>DELETE</code> with any table of the literature database.

[[Category:Installation]]

Add MySQL User - Revision history

WikiSysop: Fix incorrect wiki formatting in GRANT statement

WikiSysop: Original page content from 07-Feb-2006