hi,
I used MySQL database server and VB.Net for my project and need to make a client-server connection.
can anyone help me? i have successfully connected my 2 laptops as server and client using ODBC connector.., but when I tried to access the database on the remote laptop, "Unknown database 'database_name' " appears. Can anyone tell me what is missing or wrong with my connection or configuration?
Main PC ODBC Config:
Data Source Name=MyConnecti on
Server=localhos t
User=root
Password=""
Database=mydb
Remote PC ODBC Config:
DSN=MyConnectio n
Server=192.168. 1.1 (IP ADD of the Server )
User=ivory
Password=mypass
DAtabase=mydb
this configuration is successful, but when I tried running my system project, the system was unable to access the database 'mydb' with error "Unknown database 'mydb'".
Note:
I already issue the command GRANT ALL PRIVILEGES *.* TO 'ivory'@192.168 .1.2 IDENTIFIED BY 'mypass'; on MYSQL Command Line at the main PC.
Please help me with this one.
Thanks
I used MySQL database server and VB.Net for my project and need to make a client-server connection.
can anyone help me? i have successfully connected my 2 laptops as server and client using ODBC connector.., but when I tried to access the database on the remote laptop, "Unknown database 'database_name' " appears. Can anyone tell me what is missing or wrong with my connection or configuration?
Main PC ODBC Config:
Data Source Name=MyConnecti on
Server=localhos t
User=root
Password=""
Database=mydb
Remote PC ODBC Config:
DSN=MyConnectio n
Server=192.168. 1.1 (IP ADD of the Server )
User=ivory
Password=mypass
DAtabase=mydb
this configuration is successful, but when I tried running my system project, the system was unable to access the database 'mydb' with error "Unknown database 'mydb'".
Note:
I already issue the command GRANT ALL PRIVILEGES *.* TO 'ivory'@192.168 .1.2 IDENTIFIED BY 'mypass'; on MYSQL Command Line at the main PC.
Please help me with this one.
Thanks
Comment