How to set up mysql for a ubuntu server? | Unturned | Page 1

regal marsh May 21, 2023, 10:34 AM

#

I have a remote server and I am trying to get mysql working on it, but so far no success. I made a sql 5.7.32 server on my pc and I have mysql downloaded on the host server, but I dont understand what I need to do now. I can connect to mysql on my pc using heidsql, but I dont understand if I need to connect to the host pc ip, because that isnt working for me

pulsar river May 21, 2023, 10:37 AM

#

regal marsh I have a remote server and I am trying to get mysql working on it, but so far no...

Why not use newest mysql and host it on the ubuntu server and not on your own pc

#

Because that will cause latency to be high. And might cause lag

regal marsh May 21, 2023, 10:37 AM

#

How can I go about doing that?

pulsar river May 21, 2023, 10:38 AM

#

Well

#

Google "how to install mysql server ubuntu xx.xx"

#

Replace the x with your ubuntu version

#

Also to allow remote connection you will need to edit the mysql config file and make a user that can connect from anywhere

regal marsh May 21, 2023, 10:39 AM

#

is 9.1 a valid version?

#

https://cdn.discordapp.com/attachments/850816286346182677/1109574317907386578/image.png

#

or is it 10.3

pulsar river May 21, 2023, 10:41 AM

#

Write
lsb_release
In the ubuntu console

regal marsh May 21, 2023, 10:42 AM

#

pulsar river May 21, 2023, 10:43 AM

#

It is most likely 20.04

regal marsh May 21, 2023, 10:43 AM

#

a ubuntu is 20.04 yes

#

i tought you meant mysql version

pulsar river May 21, 2023, 10:44 AM

#

I meant ubuntu

#

Latest mysql might be 8.something

regal marsh May 21, 2023, 10:45 AM

#

I get this error

#

I tried downloading mysql before aswell

#

and got the same problem

#

#

I am pretty sure I alr have mysql

#

but I dont know what I need to do with the mysql do get it working with the plugins

pulsar river May 21, 2023, 11:14 AM

#

regal marsh

You have to fix the broken packages issue

regal marsh May 21, 2023, 11:22 AM

#

How i tried finding a way but didnt find anything useful

frigid bridge May 21, 2023, 1:57 PM

#

you can always try to classic one

#

known as "yeet the server (and start over)"

regal marsh May 21, 2023, 2:17 PM

#

did that

#

got further now

#

#

what to I need to set here

#

ik the ip alr

#

but where can I find what should go in the other fields?

regal marsh May 21, 2023, 2:20 PM

#

frigid bridge you can always try to classic one

turned out my server install included lamp, wich did its own mysql download

#

so I switched to one with no added programms

frigid bridge May 21, 2023, 2:26 PM

#

who'd have thought that the LAMP stack contains MySQL GrieferThonk

regal marsh May 21, 2023, 2:27 PM

#

unhappied

regal marsh May 21, 2023, 2:28 PM

#

frigid bridge who'd have thought that the LAMP stack contains MySQL <:GrieferThonk:55187152348...

Got any idea what I am supposed to put in the fields?

frigid bridge May 21, 2023, 2:34 PM

#

regal marsh but where can I find what should go in the other fields?

I mean you need an user/password

#

that's about it

regal marsh May 21, 2023, 2:34 PM

#

do i make them up myself?

#

or are they linked to something

frigid bridge May 21, 2023, 2:36 PM

#

well, you'd first want to create an user

regal marsh May 21, 2023, 2:37 PM

#

using this?

#

CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password';

#

and to I just put what ever password and name?

#

and replace localhost with ip

regal marsh May 21, 2023, 3:13 PM

#

@frigid bridge

frigid bridge May 21, 2023, 3:33 PM

#

well yes

regal marsh May 21, 2023, 3:56 PM

#

I am supposed to use ipv4 right in the command, because thats what I did

#

ok got it working

pulsar river May 21, 2023, 4:31 PM

#

regal marsh

If you want any IP to be able to connect you can use % instead of the IP

regal marsh May 21, 2023, 5:17 PM

#

pulsar river If you want any IP to be able to connect you can use % instead of the IP

do you know any reason why only these 2 generated and not vehicle/item shop veriants, or am i supposed to make those myself

pulsar river May 21, 2023, 5:18 PM

#

They should get generated

#

Check logs

regal marsh May 21, 2023, 5:30 PM

#

pulsar river They should get generated

regal marsh May 21, 2023, 6:03 PM

#

do i remove the uconomy file and try again?

regal marsh May 21, 2023, 6:36 PM

#

tried it it only created the same files again

#

no item or vehicle shop

frigid bridge May 21, 2023, 7:18 PM

#

pulsar river If you want any IP to be able to connect you can use % instead of the IP

I mean it should be all local connections anyways so even just using loopback for everything should work

regal marsh May 21, 2023, 7:48 PM

#

I am using local

#

Just remote accessing it trough my pc

#

But why doesnt it generate the item and vehicle shop sql files

#

When it does generate the uconomy file

regal marsh May 21, 2023, 8:15 PM

#

<DatabaseAddress>127.0.01</DatabaseAddress>
<DatabaseUsername>root</DatabaseUsername>
<DatabasePassword>my password here</DatabasePassword>
<DatabaseName>unturned</DatabaseName>
<DatabaseTableName>uconomy</DatabaseTableName>
<DatabasePort>3306</DatabasePort>

frigid bridge May 21, 2023, 8:25 PM

#

is there an actual root user set?

regal marsh May 21, 2023, 8:39 PM

#

yes

#

how else did it create the first file?

frigid bridge May 21, 2023, 8:40 PM

#

for the mysql instance

#

why add more users if you'll just use root regardless?

regal marsh May 21, 2023, 9:00 PM

#

to remote access

#

I got my pc and the server is a vps

#

but how can I get the uconomy to work

#How to set up mysql for a ubuntu server?