Guide MySQL Setup Command Line

MySQL Setup - Command line

To access the SQL database, open a new terminal window and use the following commands.

mariadb -p

You will be asked for the password: 123456

use swgemu;

show tables;

select * from galaxy;

To change the name of the server:

`update `galaxy` set `name` = 'Mod the Galaxy Testcenter' where `galaxy`.`galaxy_id` = '2';`

To change the IP address:

update galaxy set address = '192.168.1.226' where galaxy.galaxy_id = '2';

To check the changed details:

select * from galaxy;

Then simply exit with:

exit;

Once an account has been created you can set the admin level by issuing these commands.

mariadb -p

show databases;

use swgemu;

show tables;

select * from accounts;

update accountssetadmin_level= '15' whereaccounts`.username = 'yourAccountNameHere';`

exit;

Once changes have been made, back in the normal terminal window restart the DB with:

sudo service mysql restart

There will be a slight pause while restarting, then you can restart the server to see any changes made.

There is a good guide to using SQL via the command line here.