I'm having the same issue with EOC 2.0 from Chrome Browser, with popup blocker off
http://eoc.akkadius.com/EOC2/login.php
I checked settings and ports in mysql and command line interface:
Quote:
sudo netstat -plnt
- tcp 0 LOCAL 0 127.0.0.1:3306 FOREIGN 0.0.0.0:* LISTEN 626/mysqld
|
Quote:
MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3306 |
+---------------+-------+
1 row in set (0.001 sec)
|
Quote:
Create your Database User
To create your database user you will need to run the query below to create your database user:
This will allow connections only from EOC via the specified user below, you shouldn't need to change the password because you are only allowing from the EOC server
CREATE USER 'eoc_database_user'@'192.99.119.164' IDENTIFIED BY 'eoc_database_password';
GRANT GRANT OPTION ON *.* TO 'eoc_database_user'@'192.99.119.164';
GRANT ALL ON *.* TO 'eoc_database_user'@'192.99.119.164';
|
Quote:
MariaDB [(none)]> SELECT user,host FROM mysql.user;
+-------------------+----------------+
| user | host |
+-------------------+----------------+
| eoc_database_user | 192.99.119.164
| <other user> | 192.99.119.164
| xxxx | localhost
|
i know my external IP (amazon web services host)
i know my Database name in MariaDB (not peq and i tried that anyway just in case, my db is named differently...)
the 3306 port should be open and ready
i tried username/password combos in case i was misunderstanding but none of my users/pw work
i know im doing something wrong or missing something, maybe its even the browser.. ill post if i find my mistake