database

I want to reset the password for the user pterodactyl. Would this work?
ALTER USER 'userName'@'localhost' IDENTIFIED BY 'SomePassword’;
ALTER USER 'userName'@'localhost' IDENTIFIED BY 'SomePassword’;
16 Replies
Linux123123
Linux1231234y ago
Why are you trying to modify the pterodactyl user password It is in the .env
CruelWinter
CruelWinterOP4y ago
Because I can’t connect the panel to the database.
Linux123123
Linux1231234y ago
Am I correct that the pterodactyl user is the user you used in the script?
CruelWinter
CruelWinterOP4y ago
Yes.
Linux123123
Linux1231234y ago
And you are trying to use that user in the database hosts? Well I see from the photo before that you are using that user That is not going to work. You need to create another user for the database host specifically. That is
CREATE USER 'pterodactyluser'@'127.0.0.1' IDENTIFIED BY 'somepassword';
CREATE USER 'pterodactyluser'@'127.0.0.1' IDENTIFIED BY 'somepassword';
and
GRANT ALL PRIVILEGES ON *.* TO 'pterodactyluser'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'pterodactyluser'@'127.0.0.1' WITH GRANT OPTION;
FLUSH PRIVILEGES;
This is because of panel limitations. It can't use the same user for the panel and database host
CruelWinter
CruelWinterOP4y ago
So do I make a new database or make a new user for the database that the panel is using?
Linux123123
Linux1231234y ago
You are trying to solve the problem that you dropped your panel database?
CruelWinter
CruelWinterOP4y ago
No I fixed it by rerunning the script. Now I have to add the servers again. Does rerunning the script break the panel?
Linux123123
Linux1231234y ago
Yes Not break The script fails And you won't get the servers back. You deleted the database. You can only recreate the servers with the files from wings
CruelWinter
CruelWinterOP4y ago
Yeah that’s what I’m doing. I used the merge command in ssh to merge server files but I end up with 1 folder. How do I move the server files out of the folder that the merge command created? I’m used to moving files on 0.7, not 1.0.
No description
No description
CruelWinter
CruelWinterOP4y ago
I want to move files to /home/container.
Linux123123
Linux1231234y ago
You go into that folder, then you click to select all, then move them all to ../
CruelWinter
CruelWinterOP4y ago
That worked. Just did not know how to use it.
CruelWinter
CruelWinterOP4y ago
It works now. Thank you for your help and for being patient with me. Also, is the database id random or does it mean I have 3 databases with the name panel?
No description
Linux123123
Linux1231234y ago
It means that you have created at least 2 database hosts (and deleted them) before creating this one
CruelWinter
CruelWinterOP4y ago
Ok thanks. Just wanted to make sure that I had no unused databases.

Did you find this page helpful?