Solved

Problem to create user in MySql

Posted on 2011-03-03
5
889 Views
Last Modified: 2012-05-11
translate from portuguese:

I installed MySQL-5.5.9-winx64 in Server 2008.
 I restored a database and when I try to create a User (the first), I get the following message: "Error while Storing user information. Might Have Been The user deleted. Please refresh the user list."
 Could someone help me solve this?

"Eu instalei o MySql-5.5.9-winx64 num Server 2008.
Restaurei um BD e quando tento criar um usuario ( o primeiro ), recebo a seguinte mensagem: "Error while storing user information. The user might have been deleted. Please refresh the user list."
Alguem poderia me ajudar a resolver isto?"
0
Comment
Question by:etm_wkl
  • 3
  • 2
5 Comments
 
LVL 4

Expert Comment

by:ute_arbeit
ID: 35026546
If you had the same user name before restoring the database now then it might be the case that MySQL has not cleared the user name from all internal tables.
So before creating the user try
DROP USER 'name of the user you are trying to create';

Open in new window

or
FLUSH PRIVILEGES;

Open in new window

0
 

Author Comment

by:etm_wkl
ID: 35026791
translate from portuguese:

I just installed MySql. BD was the first restored and an attempt to create the first User.

 I executed the commands (see below) but keep the same error.

 DROP USER 'name of the user you are Trying to create'
 msg: Operation DROP USER failed for 'Usr_name'@'%'

 FLUSH PRIVILEGES;
 msg: Query returnet in resultset

Tks.

"Acabei de instalar o MySql. Foi o primeiro BD restaurado e a tentativa de criar o primeiro usuario.
Executei os comandos ( cf. abaixo ) mas continuo com o mesmo erro."


0
 
LVL 4

Accepted Solution

by:
ute_arbeit earned 500 total points
ID: 35027318
How do you create the user, from the command line, from phpMyAdmin or using a GUI tool like the MySQL Workbench?

There was an error reported with MySQL version 5.5.8 for the MySQL GUI tools recently here:
http://osdir.com/ml/mysql/2010-12/msg00098.html

So if you have been getting the error from a MySQL GUI tool you should try to create the user on the command line.
0
 

Author Comment

by:etm_wkl
ID: 35029133
translate from portuguese:

OK, it's a bug of the GUI tools.
 Unfortunately, I only use this tool.
 If you do not mind, could you tell me how and where to do this insertion, or appoint another tool to manage MySQL on Windows?
Tks.

"OK, é um bug do GUI tools.
Infelizmente, só utilizo essa ferramenta.
Se não se incomodar, poderia me dizer como e onde faço essa inserção, ou indicar outra ferramenta para gerenciar o MySql no windows ? "
0
 

Author Comment

by:etm_wkl
ID: 35031740
I downloaded and ran another GUI.
OK, now.
Tks.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now