CODEWITHSUNDEEP
mysqldatabasemysql-workbench
C Sharper
C Sharper

Reputation: 8646

connect to database in remote machine through MySQL Workbench

I want to connect to another PC's database through MySQL Workbench6.0

I have added all the related firewall exceptions for all ports in both PCs.

In Workbench i have done settings as

enter image description here

Is there anything wrong with it?

Is there any more settings i will have to do?

Please help me.

Upvotes: 0

Views: 3975

Answers (1)

melvin
melvin

Reputation: 1125

Make sure that you have set

bind-address = 192.168.1.1

set in yourr my.cnf.

Also make sure you granted the correct rights

so something like for just your client machine

grant all privilege on *.* to `username`@`your-pc-id` identified by 'password'

or

grant all on *.* to 'username'@'%' identified by 'password';

for all hosts.

Upvotes: 3

Related Questions