#There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000]

37 messages · Page 1 of 1 (latest)

weak briar
#

hello guys im trying to create a database from nodes to connect in my server cs2 cuz i need for skins / add admins etc
someone can tell me how to do it? i would apprecaite

image.png image.png
sonic iron
#

@weak briar

weak briar
#

hello @sonic iron thanks for responding

image.png
#

ERROR 1396 (HY000): Operation CREATE USER failed for 'pterodactyluser'@'127.0.0.1'

#

wow thanks my man

image.png
weak briar
#

Btw when i try to connect in winscp
It get timed out i cant connect in winscp

wary badge
sonic iron
wary badge
weak briar
#

i wanted to know what i need to do to manage the db?
so how really i can connect it with sql website etc i need phpmyadmin to get install in vps to manage databases ?

#

i need to connect with my vps which im hosting cs2 server

wary badge
#

with 127.0.0.1 you cant connect externally with programs because 127.0.0.1 / localhost is looking at your own pc location.

image.png
weak briar
wary badge
#

if you want external connection yes

weak briar
#

Yeah i need that
For this im asking
So to manage my db
I need to configure a website installing apache2 or nginx
Then php admin
Then database

#

Cuz im getting experience trying to learn new things everyday 🙂

#

So is required
In vps where i host cs2 by ovh
Install web
Install php admin
Creating database and connect it to pterodactyl panel

#

asked chat gpt but shows me all other things also doesnt work alot of cmds to install

wary badge
#

that is 1 of the options you can do it or just following the guide again but instead using 127.0.0.1 use your ip adres of your vps ?

weak briar
#

I used now ip of 0.0.0.0 on my vps where i have cs2 server

#

i connected in pterodactyl and created a database for my server

#

but i cant have access on winscp to manage files etc i used both pw of database and one of which is connected on pterodactyl

image.png
#

nano /etc/mysql/mariadb.conf.d/50-server.cnf
changed the Bind port from 127.0.0.1 TO 0.0.0.0

#

now i change 0.0.0.0 to my vps where my cs 2 server is created and linked it also created db for my server
just cant connect in winscp maybe im doing smth wrong but i remember years ago i used to manage my databases to upload files etc or im wrong ?

weak briar
wary badge
wary badge
weak briar
#

no

#

i use 54.38 by ovh for cs2 server
hetzner for panel

wary badge
#

looks ok

weak briar
#

im using my cs2 ip machine and db looks to work good in pterodactyl
thanks for responding 🙂

image.png