Daniel On The Web Posted August 31, 2016 Author Share Posted August 31, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
dsonesuk Posted August 31, 2016 Share Posted August 31, 2016 Do a search to see how many my.ini or my.cnf files you have on your O/S, and where they are placed. Link to comment Share on other sites More sharing options...
Daniel On The Web Posted August 31, 2016 Author Share Posted August 31, 2016 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. Link to comment Share on other sites More sharing options...
justsomeguy Posted August 31, 2016 Share Posted August 31, 2016 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. Link to comment Share on other sites More sharing options...
davej Posted September 1, 2016 Share Posted September 1, 2016 You can log into the command line console and then type... select user(); show variables where variable_name = 'port'; Link to comment Share on other sites More sharing options...
Daniel On The Web Posted September 1, 2016 Author Share Posted September 1, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
dsonesuk Posted September 1, 2016 Share Posted September 1, 2016 Mac, I thought already has a web server feature built in? ( Apache, mysql, php ) Link to comment Share on other sites More sharing options...
Daniel On The Web Posted September 10, 2016 Author Share Posted September 10, 2016 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now