Home / server / Questions / 209913
Accepted
Rahul Mehta
Asked: 2010-12-08 03:30:36 +0800 CST

Access on remotely of mysql

  • 772

I want to acces mysql server on my system in sql yog.but it is giving me error of 

access denied for user root @ 192.168.2.4 to database database name

what can i do to solve this .

ubuntu mysql permissions

1 Answers

  1. Best Answer

    You might want to check the users table in mySQL and ensure that there is a valid entry there for [email protected].

    There normally will be an entry for root but the hostname would be localhost which will not allow [email protected] to connect.

    If you want to access the system as root from this ip address you need to make 192.168.2.4 a valid host for the root user or use wildcard % which would allow you to connect from any ip address (not recommended).

    The best solution would be to configure SQLYog to use root@localhost when connecting to you local system. I haven't used SQLYog so I am not really sure how to go about doing this.

    Look here for the reference on adding users in mySQL.

    • 0