Database Connection Issue

[Daniel On The Web]

User name: any

Host name: localhost

Password: no

Global privileges: usage

User group: -

Grant: no

 

User name: pma

Host name: localhost

Password: no

Global privileges: usage

User group: -

Grant: no

 

User name: root

Host name: 127.0.0.1

Password: no

Global privileges: all privileges

User group: -

Grant: yes

 

User name: root

Host name: ::1

Password: no

Global privileges: all privileges

User group: -

Grant: yes

 

User name: root

Host name: localhost

Password: no

Global privileges: all privileges

User group: -

Grant: yes

Edited August 31, 2016 by Daniel On The Web

[dsonesuk]

Do a search to see how many my.ini or my.cnf files you have on your O/S, and where they are placed.

[Daniel On The Web]

There's one my.ini in the XAMPP MySQL \bin folder.

There's also

my-huge.ini, my-innodb-heavy-4G.ini, my-large.ini, my-medium.ini, my-small.ini

in xampp\mysql.

 

There's no my.cnf, however.

[justsomeguy]

It sounds like you're still not using the correct port. The message that the machine actively refused the connections means that your connection attempt was explicitly blocked. It's not a permission issue because the attempt to even connect failed, it never had a chance to log in at all. Maybe compare the connection settings inside the phpmyadmin config file to see how that's set to connect.

[davej]

You can log into the command line console and then type...

select user();

show variables where variable_name = 'port';

[Daniel On The Web]

As I thought I did something wrong, I decided to start over on a Mac. PHP works even without XAMPP, so I believe that the service to upload my webpage supports PHP.

 

Now I'm thinking about reinstalling MySQL and phpMyAdmin in the Mac and test it again.

 

Anyway, useful info to check what's the right port.

Edited September 1, 2016 by Daniel On The Web

[dsonesuk]

Mac, I thought already has a web server feature built in? ( Apache, mysql, php )

[Daniel On The Web]

Well, guess what: I contacted with the admin of the domain I'm using to create a database for me and tried to connect to it via PHP. And it worked. Anyway, thank you for all your help.