+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 21
How do you do....it? Thread, Creating multiple websites with linking databases in Technical; Hi, I'm looking for a bit of help here...or even ideas.. We want to set up 300 users on a ...
  1. #1

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    942
    Thank Post
    59
    Thanked 122 Times in 86 Posts
    Rep Power
    123

    Creating multiple websites with linking databases

    Hi,
    I'm looking for a bit of help here...or even ideas..
    We want to set up 300 users on a server so they can have their own websites and individual databases for their computer science projects, it has to be internal or we can't filter them properly, has anyone done this and if so, how did you do it? We are assuming we can create many databases from a batch file

  2. #2
    Marci's Avatar
    Join Date
    Jun 2008
    Location
    Wakefield, West Yorkshire
    Posts
    894
    Thank Post
    84
    Thanked 235 Times in 194 Posts
    Rep Power
    82
    Presuming you're talking MySQL databases...

    Code:
    CREATE DATABASE yourdbname;
    GRANT ALL PRIVILEGES ON yourdbname.* TO username@localhost IDENTIFIED BY 'thepasswordpass';
    I tend to do this in Excel. Get all the usernames in an excel table, along with passwords and desired db names. Then use Concatenate to build the commands for each student, and copy and paste the output column of the concatenation into anything that can run a MySQL Query (eg: MySQLfront), and run.

    Voila. All databases created & users assigned in one hit.

  3. Thanks to Marci from:

    NikChillin (17th June 2013)

  4. #3
    GTX
    GTX is offline

    Join Date
    Feb 2013
    Location
    Sheffield
    Posts
    158
    Thank Post
    50
    Thanked 5 Times in 4 Posts
    Rep Power
    4
    Why not use a free control panel? Like kloxo.. They will be able to have their own Panel logins, FTP and databases?

  5. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,942
    Thank Post
    886
    Thanked 1,694 Times in 1,472 Posts
    Blog Entries
    12
    Rep Power
    447
    Quote Originally Posted by RickH View Post
    Why not use a free control panel? Like kloxo.. They will be able to have their own Panel logins, FTP and databases?
    cpanel is free for education

  6. #5
    GTX
    GTX is offline

    Join Date
    Feb 2013
    Location
    Sheffield
    Posts
    158
    Thank Post
    50
    Thanked 5 Times in 4 Posts
    Rep Power
    4
    Oh really? i didnt know that. I love cPanel.. You could get softaculous to install there website/scripts

  7. #6
    Marci's Avatar
    Join Date
    Jun 2008
    Location
    Wakefield, West Yorkshire
    Posts
    894
    Thank Post
    84
    Thanked 235 Times in 194 Posts
    Rep Power
    82
    BUT... generally a cPanel account is tied to a domain name. Guessing you're not providing a unique domain name per student...

  8. #7
    GTX
    GTX is offline

    Join Date
    Feb 2013
    Location
    Sheffield
    Posts
    158
    Thank Post
    50
    Thanked 5 Times in 4 Posts
    Rep Power
    4
    You could use subdomains.

  9. #8
    Marci's Avatar
    Join Date
    Jun 2008
    Location
    Wakefield, West Yorkshire
    Posts
    894
    Thank Post
    84
    Thanked 235 Times in 194 Posts
    Rep Power
    82
    But, when you create a subdomain, the cPanel login that you'd have to issue wouldn't be restricted to JUST that subdomain's administration would it?

    We've done it in cPanel via subdomains, bulk created the ftp accounts and MySQL dbases / accounts and given these to students, but have never provided them with direct access to the cPanel interface...

  10. #9
    GTX
    GTX is offline

    Join Date
    Feb 2013
    Location
    Sheffield
    Posts
    158
    Thank Post
    50
    Thanked 5 Times in 4 Posts
    Rep Power
    4
    Quote Originally Posted by Marci View Post
    But, when you create a subdomain, the cPanel login that you'd have to issue wouldn't be restricted to JUST that subdomain's administration would it?

    We've done it in cPanel via subdomains, bulk created the ftp accounts and MySQL dbases / accounts and given these to students, but have never provided them with direct access to the cPanel interface...
    Not at all. Go create a new user on the cpanel.. Then where it says domain.. type subdomain.domain.com and look.

    Plus you can set what they can and cant do on it.

  11. #10
    Marci's Avatar
    Join Date
    Jun 2008
    Location
    Wakefield, West Yorkshire
    Posts
    894
    Thank Post
    84
    Thanked 235 Times in 194 Posts
    Rep Power
    82
    I get an error when i attempt to do so. I think your approach only works if you're not using cPanel on the same server for the main domain/site.

  12. #11
    GTX
    GTX is offline

    Join Date
    Feb 2013
    Location
    Sheffield
    Posts
    158
    Thank Post
    50
    Thanked 5 Times in 4 Posts
    Rep Power
    4
    Quote Originally Posted by Marci View Post
    I get an error when i attempt to do so. I think your approach only works if you're not using cPanel on the same server for the main domain/site.
    Ah i see.. You could try 2 subdomains.. Should work.. I take it your server is Cpanel.yourdomain.com you could always try student.cpanel.yourdomain.com. That may work as that subdomain is the child of the 1st one

  13. #12
    Marci's Avatar
    Join Date
    Jun 2008
    Location
    Wakefield, West Yorkshire
    Posts
    894
    Thank Post
    84
    Thanked 235 Times in 194 Posts
    Rep Power
    82
    Nope... same error - you can't have the top domain on the box. (see cPanel - Multiple Accounts Under Single Domain - Ashworth Creative)

    So, yes, your approach will work with a clean cPanel server that doesn't have an account existing for the root domain, but if you're already using cPanel for your main site, and intend to use the same server, this approach won't work. You'd have to commission a separate cPanel server, which would need a second dedicated public IP differing from the first, and a dedicated route out so that it reports as being this IP specifically (or the license would fail).
    Last edited by Marci; 10th June 2013 at 12:06 PM.

  14. #13
    GTX
    GTX is offline

    Join Date
    Feb 2013
    Location
    Sheffield
    Posts
    158
    Thank Post
    50
    Thanked 5 Times in 4 Posts
    Rep Power
    4
    Im not sure about that, Every time i have done it on my dedicated server i have never have any problems..

    Most be something im missing with your setup.

  15. #14
    SovietRussia's Avatar
    Join Date
    Mar 2013
    Location
    Powys, Wales
    Posts
    615
    Thank Post
    69
    Thanked 132 Times in 103 Posts
    Rep Power
    43
    I just tried it on my cPanel, works fine for subdomains.

  16. Thanks to SovietRussia from:

    GTX (10th June 2013)

  17. #15
    GTX
    GTX is offline

    Join Date
    Feb 2013
    Location
    Sheffield
    Posts
    158
    Thank Post
    50
    Thanked 5 Times in 4 Posts
    Rep Power
    4
    Quote Originally Posted by SovietRussia View Post
    I just tried it on my cPanel, works fine for subdomains.
    1-0 to me :P

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Creating a new joomla based website with photoupload
    By DJ-Jonesy in forum Web Development
    Replies: 3
    Last Post: 14th March 2012, 11:15 AM
  2. Creating A School Website With Joomla E-Book
    By in forum Web Development
    Replies: 12
    Last Post: 22nd December 2011, 09:42 AM
  3. Script to Create Multiple Websites
    By Tricky_Dicky in forum Mac
    Replies: 1
    Last Post: 10th September 2010, 11:34 AM
  4. Script to Create Multiple Websites
    By Tricky_Dicky in forum Web Development
    Replies: 2
    Last Post: 10th September 2010, 09:21 AM
  5. Creating a website with Publisher
    By Michael in forum Web Development
    Replies: 18
    Last Post: 13th May 2008, 08:03 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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