Find the answer to your Linux question:
Results 1 to 4 of 4
Hi Guys I am messing around with mysql 5.1.30 on my ubuntu 8.10 setup. I am alittle confused on how accounts work on this system. Say for instance I wanted ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Dec 2006
    Posts
    4

    Adding accounts onto MySQL


    Hi Guys

    I am messing around with mysql 5.1.30 on my ubuntu 8.10 setup. I am alittle confused on how accounts work on this system. Say for instance I wanted to host 5 websites on my server, how would I create the accounts for each user?

  2. #2
    Just Joined!
    Join Date
    Dec 2008
    Location
    Lithuania
    Posts
    12
    Hi. What do hosting different websites have in common with MySQL? Do you want to have each website with different MySQL user and different DB? Or do you want to have all websites same user, just use different DB's? Do you want to host each site as a different systems user?

  3. #3
    Just Joined!
    Join Date
    Dec 2006
    Posts
    4
    Hi MrKrabs

    I am not too sure tbh honest because I am still in the processing of learning all this stuff. Basically, I want a folder for each user (can probably configure that through apache or something) and want to have a database for each user. Within this DB they create,delete etc as many dbs as they want. I can do this to an extent by using priliages but the problem is that all the users can see EVERY database created regardless of who made it. I have tried to restrict them to one DB, the problem with that is they cannot create their own DBs then...

  4. #4
    Linux Guru
    Join Date
    Nov 2007
    Posts
    1,755
    The MySQL documentation is *very* complete.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •