Connection String of a MySql Database from another computer via LAN
-
Hi all, I want to connect a MySql Database. Suppose..... Database Name is mydb Database located on PC-1 (IP- 192.168.0.10) PC-1 user id = abc PC-1 password= 123 MySQL Server user ID = root MySQL Server password= mypassword now what will be the connection string for PC-1 to connect to the database ? now I want to connect the database(mydb) from another pc (suppose this pc name is PC-2 and the IP is 192.168.0.11) what will be the connection string for PC-2 to connect the PC-1 database ? I searched connectionstrings.com[^] and found ... Standard
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
and Specifying TCP port
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;but nowhere found if the server pc (PC-1) is protected by user id and password. In this case what should I do ? I Tried both the above connection string. They are Ok for PC-1 to connect its own database (localhost) but when I tried to connect the database from PC-2, I got the error**
Quote:
Host '192.168.0.11' is not allowed to connect in this mysql server
**Can anybody help me ?
-
Hi all, I want to connect a MySql Database. Suppose..... Database Name is mydb Database located on PC-1 (IP- 192.168.0.10) PC-1 user id = abc PC-1 password= 123 MySQL Server user ID = root MySQL Server password= mypassword now what will be the connection string for PC-1 to connect to the database ? now I want to connect the database(mydb) from another pc (suppose this pc name is PC-2 and the IP is 192.168.0.11) what will be the connection string for PC-2 to connect the PC-1 database ? I searched connectionstrings.com[^] and found ... Standard
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
and Specifying TCP port
Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;but nowhere found if the server pc (PC-1) is protected by user id and password. In this case what should I do ? I Tried both the above connection string. They are Ok for PC-1 to connect its own database (localhost) but when I tried to connect the database from PC-2, I got the error**
Quote:
Host '192.168.0.11' is not allowed to connect in this mysql server
**Can anybody help me ?
well, you dont say what platform you're running MySQL on, but this would be a start http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html[^] 'g'
-
well, you dont say what platform you're running MySQL on, but this would be a start http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html[^] 'g'
Hi, thank you for your reply. For your information I am using Windows 7 Ultimate and I am coding in VB.NET 2010. I checked the link but I can not understand what they are saying... maybe it is because for other platform they are saying about...
-
Hi, thank you for your reply. For your information I am using Windows 7 Ultimate and I am coding in VB.NET 2010. I checked the link but I can not understand what they are saying... maybe it is because for other platform they are saying about...
well, Im pretty sure you're a smart guy and you can google for MYSQL Windows Connection for example, and get a result .. this came up pretty quickly for example >> http://richbui.com/2009/03/06/how-to-enable-remote-access-to-mysql-server-on-windows-server/[^]
-
well, Im pretty sure you're a smart guy and you can google for MYSQL Windows Connection for example, and get a result .. this came up pretty quickly for example >> http://richbui.com/2009/03/06/how-to-enable-remote-access-to-mysql-server-on-windows-server/[^]
I tried on google but found many results except mine.
-
I tried on google but found many results except mine.
was the link I posted any good ?
-
was the link I posted any good ?
yes but I cannot do that or I cannot find mysql directory as I am using xampp server(phpmyadmin) and mysql workbench
-
well, Im pretty sure you're a smart guy and you can google for MYSQL Windows Connection for example, and get a result .. this came up pretty quickly for example >> http://richbui.com/2009/03/06/how-to-enable-remote-access-to-mysql-server-on-windows-server/[^]
Hello, I tried the process but an error message is coming....
Error Connecting to database: Authentication to host '192.168.0.101' for user 'root' using method 'mysql_native_password' failed with message: Access denied for user 'root'@'CLT'(using password: YES)
... Where 192.168.0.101 is the server (in which I am trying to connect) ... Where 'root'@'CLT' is the client (from where I am trying to connect) I tried the command...
shell> mysql --default-auth=mysql_native_password ...
shell> mysql --default-auth=mysql_old_password ...from http://dev.mysql.com/doc/refman/5.5/en/native-authentication-plugins.html[^] but failed... Please help