-2

I have tried over and over to connect to the local server using MySQL Workbench 6.3 on my computer using the following parameters, but it won't let me connect. Do you think it is a firewall issue?

Here are my parameters: 

hostname: localhost
port: 3306
username: root
password: [not_really]

Here is the picture of my problem for anyone's viewing.

473183469
  • 1,350
  • 1
  • 12
  • 23
DMicheal
  • 1
  • 1
  • 1
  • 1

1 Answers1

0
  1. Check that the MySQL listen on port 3306 netstat -lnp | grep 3306 on server. Otherwise, check the configuration directive bind-address
  2. Check that the MySQL accessible from you webserver telnet <mysql host> 3306 ( - as in your web application configuration). Otherwise, check firewall rules. Note. telnet by default is not installed in Window, and may be missing in Linux then this component must be installed manually.
  3. If the first test is successful, you will probably need to reset a user's password in MySQL and/or reconfigure which hosts are allowed to connect to it.

Use root account for the web application with a database - a very bad idea!

Community
  • 1
Slipeer
  • 3,255
  • 2
  • 18
  • 32
  • Slipper are you saying that I shouldn't have chosen root as the default username, and actually specified a username. Do you think I will have to uninstall the program and then install it again? – DMicheal Jan 18 '17 at 07:06
  • No reinstallation of the program it does not need, it is sufficient to change the settings. But it's just a comment, **it's not your main problem**, it should work with the root account too. just not recommended to do so for security reasons. – Slipeer Jan 18 '17 at 07:10
  • Where do I go from here – DMicheal Jan 18 '17 at 07:17
  • Do you think my firewall is blocking me from connecting to it? – DMicheal Jan 18 '17 at 07:20
  • Firewsall - one of the possibilities. Perform the checks series. – Slipeer Jan 18 '17 at 07:32