MySQL Forums
Forum List  »  Newbie

Running Mysql Manually - user and world database table not found
Posted by: Abida Mukarram
Date: February 04, 2015 10:06AM

Hello,
I am running mysql on windows 8.1 in manual mode. I downloaded the world_innodb database. Also created a user using CREATE and GRANT with all privileges.
Was able to see and log this process. All three table COUNTRY, CITY, COUNTRYLANGUAGE were created. I exited mysql and restarted to find the following
problem. My user no longer existed (not coming up under show user also)
while SHOW Databases shows the database world and USE world works for the database, I get an error for SHOW tables.

Is this happening because of manual mode? Do I need to recreate users and tables everytime? I would appreciate your help. Thanks

Options: ReplyQuote


Subject
Written By
Posted
Running Mysql Manually - user and world database table not found
February 04, 2015 10:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.