Solved

Problem to create user in MySql

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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 tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

911 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

22 Experts available now in Live!

Get 1:1 Help Now