Click here to Skip to main content
15,850,359 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have installed MySql in a system and granted permission to all the IP. How to access that mysql database which is installed in another system
Posted
Updated 13-May-13 22:29pm
v2
Comments
Mohibur Rashid 14-May-13 3:22am    
Connect with what? c/c++ or mysql client? or what?
Usha Muhunthan 14-May-13 3:27am    
mysql Client . i am new to this, i am sorry if there is any mistakes in my questions ..
I have installed mysql in system1 and gratnted permission to all IP client. I need to access Database from System2.
Usha Muhunthan 14-May-13 3:39am    
Do i need to install mysql in all the client system. If it is, is there any way to access DB without installing mysql in client system

1 solution

Did you try Google[^] yet?
 
Share this answer
 
Comments
Usha Muhunthan 14-May-13 3:34am    
Do i need to install mysql in all the client system. If it is, is there any way to access DB without installing mysql in client system
CPallini 14-May-13 3:48am    
No, as far as I know you don't need. Of course, if you want to use mysql-client then you have to install mysql-client (if you want to remotely connect with MySQL with your application then you don't need to).
Sudhakar Shinde 14-May-13 3:36am    
You do not need to install client in case you wish to connect through some application.
Usha Muhunthan 14-May-13 6:05am    
Do i need any other support file to connect when MySQL is not in need
Usha Muhunthan 14-May-13 6:09am    
My connection string is to connect MySQL from client system is
Provider=MySQLProv;Driver={MySQL ODBC 5.0.9 Driver};Server=IPAddress;Database=DBName;User=root;Password=adminadmin;Option=3;

but it shows error The 'mysqlprov' is not registered on the local machine

I have installed connector 5.0.9

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900