Post4VPS Forum | Free VPS Provider
Open game panel MySQL Offline - Printable Version

+- Post4VPS Forum | Free VPS Provider (https://post4vps.com)
+-- Forum: Gaming Section (https://post4vps.com/Forum-Gaming-Section)
+--- Forum: Game Server Support (https://post4vps.com/Forum-Game-Server-Support)
+--- Thread: Open game panel MySQL Offline (/Thread-Open-game-panel-MySQL-Offline)

Pages: 1 2

Open game panel MySQL Offline - youssefbasha - 07-26-2019

Hello,
Long time since i posted about OGP but days ago my VPS (OVH) expired and the one who was paying is not available so someone gifted me a VM from Google and he is paying and the VM is working fine (panel is installed and working) i tired to install MySQL server and phpmyadmin and then used sudo mysql_secure_installation and filled the required info and tried to add the same info in the panel but i got this when i set the connection method to direct connection 

[Image: ss2871_Screenshot_2019-07-26-13-49-26-11...chrome.png]
And this when i set Connection method: Connection through remote server named firex-host
[Image: ss1297_Screenshot_2019-07-26-13-52-29-15...chrome.png]
And this when i go to ip/phpmyadmin
[Image: ss2394_Screenshot_2019-07-26-13-54-20-67...chrome.png]
Hope someone can help me Sad
PS: all of this at Google cloud
And my current system is Debian 9

RE: Open game panel MySQL Offline - hamed - 07-26-2019

Go to the link to the ogp community : https://opengamepanel.org/forum/index.php
This is Open game panel Forum . you should send ticket in open game panel forum not here . good luck man

RE: Open game panel MySQL Offline - youssefbasha - 07-26-2019

Open game panel support is not good, i tried it before and they achieved my post without a solution..

RE: Open game panel MySQL Offline - Mashiro - 07-26-2019

OS?
MySQL or MariaDB?
Installed phpMyAdmin by hand or package manager?

MySQL processes running?

RE: Open game panel MySQL Offline - youssefbasha - 07-26-2019

(07-26-2019, 04:38 PM)Hidden Refuge Wrote: OS?
MySQL or MariaDB?
Installed phpMyAdmin by hand or package manager?

MySQL processes running?
Debian 9 is the OS
Maria DB (sudo apt-get install mariadb-server

sudo mysql_secure_installation


)
Command line (hand)
How can I check this?

RE: Open game panel MySQL Offline - Mashiro - 07-26-2019

You can use htop or ps to find out if the processes of MariaDB/MySQL are running.

htop is a advanced task manager that will list all processes. ps is a simple one and you need filtering.

PS command to findout MySQL/MariaDB processes:
Code:
ps aux | grep mysql

Post the output here.

You installed phpmyadmin by hand? Where did you put the folder? Doesn't look like you put it into the default folder of the web server.

RE: Open game panel MySQL Offline - youssefbasha - 07-27-2019

Thanks @Hidden for your help, you helped me alot at fixing my problem.
Appreciated.
If you can, share ur steps here so everyone can get help

RE: Open game panel MySQL Offline - Mashiro - 07-27-2019

Part 1 of the fix is already available here: https://post4vps.com/Thread-Reset-MariaDB-Root-Password

Part 2 is nothing special either. I created a second user that is not called root and I granted it global administrative permission. All of this through the MySQL command line client "mysql".

The commands I used are:
Code:
1. mysql -u root -p
2. USE mysql;
3. CREATE USER 'username'@'localhost' IDENTIFIED BY 'passwordhere';
4. GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
5. FLUSH PRIVILEGES;
6. exit

In MySQL 5.7 and MariaDB 10.1 login as root in applications has usually been disabled as a security protection method. You can usually only login as root from the MySQL command line client "mysql". To fix that I created a new user as described above.

Or better said:
https://askubuntu.com/questions/763336/cannot-enter-phpmyadmin-as-root-mysql-5-7 Wrote:MySQL 5.7 changed the secure model: now MySQL root login requires a sudo. phpMyAdmin will be not able to use root credentials. The simplest, safest and permanent solution will be create a new user and grant required privileges.


About your phpMyAdmin not found issue. You simply installed it wrong or at the wrong location. I just downloaded the latest version as .zip file, moved the file to /var/www/html, extracted it, renamed the extracted folder and then inside I renamed "config.inc.sample.php" to "config.inc.php" and set the required "blowfish secret" inside that file.

RE: Open game panel MySQL Offline - roy79482 - 09-01-2019

It's not working.
Server is online mysql is offline..
I have test everything but mysql is not online

RE: Open game panel MySQL Offline - Mashiro - 09-01-2019

@roy79482

The problems addressed in this thread were solved weeks ago! The solution(s) to this problems have been posted here.

If the solutions didn't work for you then you a) either have a very different problem or b) you didn't do it right. Looking at the history of your posts and your overall activity here... I'm not going to add more to this.

Open a new thread about your issues. Describe the exact problem. If you have post any error messages, logs and etc. I'm sure someone will be able to help you if you cooperate properly for once.