[Solved] MySQL: Access denied for user 'username'@'host' (using password: YES) error in Workbench,HeidiSQL



While connecting to SQL server hosted on your web hosting service provider following problem occurs.
  • Access denied for user 'username'@'host' (using password: YES)
even you have entered correct username and password...

It happens because connection from outside world is blocked by server by default to solve this problem you have to either allow your static ip or give wildcard '%' entry.


  • Error occurred  while connecting through MySQL Workbench

 
  • Error occurred  while connecting through HeidiSQL


  • Solution

1] Login to cPanel

2] Click on Remote MySQL

3] Enter '%' wildcard entry to Access host

4] Done.

5] Caution: Allowing '%' all ip to access DB creates large security hole. you can also allow only your own IP.




Incomming search terms:

  • access hosted my sql server from pc
  • mysql access denied for user using password no 
  • mysql access denied for user remote  
  • mysql access denied for user 'root'@'localhost' (using password yes)
  • mysql access denied for user ''@'localhost'
  • access denied for user 'root'@'localhost' (using password yes) when trying to connect
  • mysql access denied for user to database.
  • access denied for user @'localhost' (using password: yes)
  • error 1045 access denied for user ''@'localhost' to database

Post a Comment

0 Comments