Jump to content


Photo

MySQL Security and Database Ownership


  • Please log in to reply
2 replies to this topic

#1 9AF

9AF
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 11 November 2003 - 10:02 AM

Hi all,

I am trying to make mysql more secure by not having databases created and listed under root. I have created my own account with all the necessary privileges. However, if I create a database whilst logged in with my account, later on when I exit and re-enter the Control Centre the database I created is listed under root. Is there an option in the setup that causes this to happen or am I just not doing something correctly?

I am using MySQL 4.0.16 and Mysql Control Centre 0.93.

Thanks
RB

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 11 November 2003 - 05:33 PM

sounds like the way the mysql control centre is setup. can you edit its connection information to your user?
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 9AF

9AF
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 12 November 2003 - 09:31 AM

I think I\'ve managed to resolve the issue.

I went into the edit option for the account I created in Control Center. Selected the databases tag and made sure the database created was only attributed to the account. For the root account I also made sure I removed the database from the list of used databases.

Thanks for the response[/b]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users