MySQL Forums
Forum List  »  MySQL Administrator

Help adding new db and user information concern please
Posted by: David Rix
Date: July 19, 2012 04:57PM

A database was created using the regular mySQL gui and it works fine running a program called radiodj.

This database was called 'radiodj' and the user was just 'root'

Now I need that same database with a new name and a new user and I have discovered this great mySQL Admin which I would like to use.

This is what I have done thus far in Admin..

Saved a backup .sql of the radiodj db. (The file is correct)

Created a new db called lonniele_radiodj

Restored Backup file to lonniele_radiodj (Shows in catalog,Tables,Indices)

Added new user called lonniele_root

These are my concerns.............

Can't see any Info,Privileges for either of the users, lonniele_root or root

User connections only show for 'root' user

Dos it seem that I have done this correctly and are my concerns valid?



Options: ReplyQuote

Written By
Help adding new db and user information concern please
July 19, 2012 04:57PM

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.