113789 – after using mysql grant command, use flush privileges to refresh mysql

Bug 113789 - after using mysql grant command, use flush privileges to refresh mysql

Summary: after using mysql grant command, use flush privileges to refresh mysql

Status:	RESOLVED FIXED

Alias:	None

Product:	[OLD] Docs-user
Classification:	Unclassified
Component:	Virtual-mail HOWTO (show other bugs)
Hardware:	All Linux

Importance:	High minor (vote)
Assignee:	Xavier Neys (RETIRED)

URL:	http://www.gentoo.org/doc/en/virt-mai...
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2005-11-28 06:46 UTC by Rob Sworder
Modified:	2005-12-02 06:50 UTC (History)
CC List:	1 user (show)

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Rob Sworder 2005-11-28 06:46:34 UTC

Section 7. Mysql

after issuing the command:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE
	->     ON mailsql.*
	->     TO mailsql@localhost
	->     IDENTIFIED BY '$password';
a FLUSH PRIVILEGES command should also be sent to allow the changes to be
accepted, and immediate connections to the mailsql user.

Reproducible: Always
Steps to Reproduce:
1.
2.
3.

Actual Results:  
mailsql user failed to connect.

Expected Results:  
mailsql user should have been able to connect

Comment 1 Xavier Neys (RETIRED) gentoo-dev

2005-12-02 06:50:06 UTC

Fixed. Thanks for reporting.