MySQL Forums
Forum List  »  Newbie

MySQL file / database structure
Posted by: Karl Huber
Date: August 22, 2005 11:41PM

Hi!

I have a question about the file structure of mysql. Where are the users as e.g. root stored?
When I make a fresh install of mysql I have the data\mysql database in place then I add a secound database e.g. test. Is the root user stored then in both databases or is he only in the mysql database or somewhere else?
And if I change the password for the user root with the cmdline tool mysql is it necessary to select a database before with "use XXX" or not?

And if I wanna start from scratch on an running mysql server and therefore delet the data\mysql database is the root user lost then and how I recreate all I need then?


thanks
Karl

Options: ReplyQuote


Subject
Written By
Posted
MySQL file / database structure
August 22, 2005 11:41PM


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.