restarting MySQL service resets all my privileges

		Wrox Programmer Forums > PHP/MySQL > MySQL
restarting MySQL service resets all my privileges

MySQL General discussion about the MySQL database.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 27th, 2006, 11:33 AM

crmpicco

Friend of Wrox

Join Date: Jan 2005

Posts: 1,525

Thanks: 0

Thanked 0 Times in 0 Posts

restarting MySQL service resets all my privileges

When i restart my MySQL service in Windows all my priveleges are reset for my Databases.

I can then no longer access the database(s) in my scripting.

I am using the GUI through Control Panel > Administration Tools > Services and not the command line 'net stop mysql'.

Why would this occur?

Help appreciated.

Picco

www.crmpicco.co.uk

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restarting IIS	zaghmout	ASP.NET 2.0 Professional	1	November 7th, 2007 11:01 AM
users & privileges	lompy1	Oracle	1	November 8th, 2006 04:50 PM
Restarting the current database	GandolftheWhite	Pro VB Databases	1	December 27th, 2004 07:55 PM
User/Role Privileges	mike123abc	SQL Server 2000	1	July 7th, 2004 03:07 AM