Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sites.google.com/site/fiveservercom/home offline !! #23

Open
ToniFabri opened this issue Nov 20, 2023 · 2 comments
Open

sites.google.com/site/fiveservercom/home offline !! #23

ToniFabri opened this issue Nov 20, 2023 · 2 comments

Comments

@ToniFabri
Copy link

I need the tutorial to get the mysql codes to work on the server, the site is offline, is there another place or on github I can get these codes, thank you

@themasterz
Copy link

themasterz commented Feb 9, 2024

https://web.archive.org/web/20201102183724/https://sites.google.com/site/fiveservercom/win32-howto

mysql> create database fiveserver;
Query OK, 1 row affected (0.00 sec)

mysql> grant select,insert,update on fiveserver.* to 'fiveserver'@'%' identified by 'we9le';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update on fiveserver.* to 'fiveserver'@'localhost' identified by 'we9le';
Query OK, 0 rows affected (0.00 sec)

mysql> create database sixserver;
Query OK, 1 row affected (0.00 sec)

mysql> grant select,insert,update on sixserver.* to 'sixserver'@'%' identified by 'proevo';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select,insert,update on sixserver.* to 'sixserver'@'localhost' identified by 'proevo';
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| fiveserver |
| mysql |
| performance_schema |
| sixserver |
| test |
+--------------------+
6 rows in set (0.00 sec)

Now we have the databases created and access to them configured, but we still need to create the schemas for these databases: meaning create the necessary tables. To do that execute these commands:

mysql> use fiveserver;
Database changed
mysql> source schema.sql
Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.03 sec)

mysql> source alter_001_add_settings.sql
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql>
mysql> use sixserver;
Database changed
mysql> source schema6.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.03 sec)

Query OK, 0 rows affected (0.05 sec)

mysql> source alter6_001_modify_profiles.sql
Query OK, 0 rows affected (0.00 sec)

mysql>

We're done with this step. Quit the mysql client too, by entering:

mysql> exit

@WagnerSami
Copy link

Não tem como coloca servidor com Hamachi?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants