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
Solved

Problem to create user in MySql

Posted on 2011-03-03
5
912 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Scenario:  You do full backups to a internal hard drive in either product (SBS or Server 2008).  All goes well for a very long time.  One day, backups begin to fail with a message that the disk is full.  Your disk contains many, many more backups th…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

856 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