?
Solved

Problem to create user in MySql

Posted on 2011-03-03
5
Medium Priority
?
961 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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 setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Suggested Courses

752 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