Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 .

share|improve this question

1 Answer 1

up vote 0 down vote accepted

You might want to check the users table in mySQL and ensure that there is a valid entry there for root@192.168.2.4.

There normally will be an entry for root but the hostname would be localhost which will not allow root@192.168.2.4 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.

share|improve this answer
    
I have one entry in db table of host:192.168.2.4,db:mydb,user:root,all priviliages yes except gran priveilages no. and in users table i have one entry of this Host : 192.168.2.4 user root , all privilages yes except grant privl –  Rahul Mehta Dec 7 '10 at 12:18
    
still i am not able to connect through sql yog –  Rahul Mehta Dec 7 '10 at 12:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.