Ubuntu server

[Alexandre24]

One question bothers me . Can one Ubuntu server ( I have no GUI ) , to ensure that I have 3 or equivalent terminal to launch 3 cells of the server? I do not know if I'm clear ..

And then how do you update a database when there is in the update a sql ? For example: abilities.sql .

I find no way has screw up all my base and of course , it clears my character .

Thank you !

[kjLotus]

there's a section in the wiki on using screen to run 3 servers in one terminal

you use mysql command line to manually edit the columns using sql statements (ALTER TABLE chars ADD COLUMN <whatever> etc.). or if you really like using navicat, you can add a new mysql user to the db on your server that allows connections from your work pc, and have navicat connect to your server db (that's what i do for mine)

[Alexandre24]

Thank you for using the screen . I'll check that.

Ok, so if I understand well . You use Windows for navicat . And through the intermediary of the network , you update your given basic ubuntu server? Interesting

[kjLotus]

yep - if you do add connection in navicat, you can specify the IP, port, user and password. then you have to make a new user using mysql in your terminal, make sure that its host is visible (not 127.0.0.1), and then finally you have to edit mysql's settings to change the default bound IP (which is 127.0.0.1) to also be visible, and then restart it

[Alexandre24]

So there is something I not understand. I took her in Navicat and it refuses to connect

EDIT: I have been in /etc/mysql/my.cnf and I changed the IP address

but after , I do not understand how to change the privileges of the base given pr she stopped wanting to connect to 127.0.0.1

[kjLotus]

did you add a new user with the right ip? default root is local only

and did you change the bind-address in mysql configuration?

[Alexandre24]

if I understand well .

I have to write this?
CREATE USER ' DarkStar'@'192.168.0.101 ' IDENTIFIED BY ' mypass ';

[kjLotus]

the IP in there is the IP you connect from, either use your PCs IP (not servers) or % (for any IP)

[Alexandre24]

bah 192.168.0.101 is my IP adress of my machine. I do not understand the principle . I have to take local IP of the machine to communicate with each other , it's his ? Because my only goal is that the linux server communicates with Navicat is it on Windows to help me update .sql

[kjLotus]

just do CREATE USER 'DarkStar'@'%' IDENTIFIED BY 'whatever'

that lets any IP address connect - then in the config file for mysql (in /etc/mysql/my.cnf) change bind-address to the wan address of your server (192.168.whatever), and restart mysql

that's all there is to it