search

ondras / wwwsqldesigner

WWW SQL Designer, your online SQL diagramming tool
https://sql.toad.cz/?keyword=online_library
BSD 3-Clause "New" or "Revised" License
2.86k stars 722 forks source link

I've created a guide for cpanel and subdomains xD #289

Open EvoPulseGaming opened 4 years ago

EvoPulseGaming commented 4 years ago

In Cpanel, goto Git™ Version Control and press create, the clone url will be https://github.com/ondras/wwwsqldesigner.git the repository path, is where you want to place your files (I put it into its own folder in /public/html) and the name is whatever you want.

Then in Cpanel, go to subdomains, create your new subdomain and point its document root to where the repository path is in the previous step.

create a new .htaccess in your subdomains root and add: <IfModule mod_alias.c> RedirectMatch 301 ^/$ https://yoursubdomain.yourdomain.com/index.html </IfModule>

Then in file explorer, change the permissions of your subdomain folder to 755

Then you can visit your subdomain and design!!!

Also, you can just visit cpanel git to update whenever new changes come out!

EvoPulseGaming commented 4 years ago

To get mysql save/load to work:

in cpanel goto MySQL Databases create a new database create a new user assign new user to this new database

goto your subdomains root view /backend/php-mysql/database.sql copy everthing inside of that in phpmyadmin, open the new database, go to the SQL tab, and paste what you just copied, and run.

go back to your subdomains root edit /backend/php-mysql/index.php Inside of that file, edit the defines in "function setup_saveloadlist()" That would be the USER, PASSWORD, DB and TABLE defines.