Installer can't connect to DB

[Deuzz]

Hey, I just tried to install FlameCMS (6.x.x branch) but I always get the following error: Failed to connect to MySQL: Access denied for user 'cms'@'localhost' (using password: YES)

I'm 100% sure that I'm using the correct password. And the weird part is that if I try to connect to the DB with the cms user I can connect to it without any problems :/

[tlcd96]

Deuzz can you send an printscreen? if not, see if the user can access the database if you can't i will try to see what is happening (if the problem is with the CMS)

[tlcd96]

i will try all the install steps to see exactly what is the problem.

[tlcd96]

i've checked, and it must be your config on install... you can check it working here: (it's in portuguese :S) https://flamecms.exdemsys.tk/6.x.x/

[Deuzz]

http://puu.sh/kqSZs/b2158cfe3c.jpg - This is the settings page with MySQL user list (Blacked out the IP) http://puu.sh/kqT4j/9a0153808e.png - This is what I get when using localhost as IP (and the correct password) http://puu.sh/kqT5T/c43f67c9ff.jpg - And this is what I get when I use the IP address ..

[tlcd96]

try one thing, change temporary the password and see if works

[tlcd96]

are the ports from the router opened?

[Deuzz]

The password change did nothing -> still access denied. All ports are opened

[tlcd96]

you can try also with 127.0.0.1(localhost IP)

[tlcd96]

ok wierd

[Deuzz]

127.0.0.1 gives me the same error

[tlcd96]

external ip it works but not locakhost?

[Deuzz]

If I use the external IP then it tells me "Host 'Server IP' is not allowed to access this server"

[tlcd96]

create + 1 account, with the same settings, but the domain it's localhost (mysql it's an pain in the ass, i've had that problem)

[tlcd96]

if you want an image to explain tell

[tlcd96]

the name it's the same only changes the localhost

[Deuzz]

Now I've "website@%" and "website@localhost" with the same password - and it's giving me the same error :/

[tlcd96]

thats wierd

[tlcd96]

do you have the website in the same machine?

[Deuzz]

Yea it's on the same server

[tlcd96]

ok, what it's your apache2/nginx/mysql config?

[tlcd96]

and versions

[tlcd96]

if you only have apache and mysql, tell me what is the config and the versions to see if i can do something to help you

[tlcd96]

if you don't know how to give that, tell me if your server is windows or linux based

[tlcd96]

or do you have team viewer?

[Deuzz]

Apache: Apache/2.4.12 (Win32) OpenSSL/1.0.1l PHP/5.6.8 Configs: http://puu.sh/kr7nK/cdf070422b.txt MySQL: MySQL Community Server 5.5.19-log Configs: http://puu.sh/kr7um/956d049f52.txt (Yea, I know there's 3308 as port and on the picture of the settings is 3307 BUT I used 3308 to connect)

Sorry.. took me some time to find that stuff

[tlcd96]

soo i see your server it's win32 based, and it does not appear to have on the config's any kind of errors.... do you have teamviewer?

[Deuzz]

On my computer, yes

[tlcd96]

do you mind if you gave me access to your pc? too se if i can help?

[tlcd96]

if you want an more private place to send the id and key: add me on facebook-> https://www.facebook.com/adomasalcore3

[Deuzz]

To be honest.. I don't think that there's a way to fix it without reinstalling the MySQL server :/

[tlcd96]

try: easyphp

[tlcd96]

http://www.easyphp.org/

[tlcd96]

if you reinstall

[tlcd96]

if you install easyphp install Xdebug (it's an module of easyphp) (easy to install)

[Deuzz]

So, I tried it with EasyPhp on my computer - set the root password to 12345 and it what does it show? Right. Access denied for user root@localhost ........

[tlcd96]

seriously? O.o

[tlcd96]

thats new... can you give access to teamviewer?

[Deuzz]

Okay, got it working.. Somehow it looks like it doesn't work on another port than 3306 :/ but now I've the problem that it says that my account is not activated

[tlcd96]

have you created an account?

[tlcd96]

when you finish to create the account, go to you database, see the record, copy the activation key, go to the url: %yourhost%/account/confirm.php?passkey=%activationkey%

[tlcd96]

or, set null the activation key field on the new account record

[tlcd96]

[Deuzz]

Thanks :3

[tlcd96]

you're welcome