By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Unknown database ('database_name')

P: 4
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=MyConnection
Server=localhost
User=root
Password=""
Database=mydb

Remote PC ODBC Config:
DSN=MyConnection
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
Jan 17 '13 #1
Share this Question
Share on Google+
1 Reply


PsychoCoder
Expert Mod 100+
P: 465
Show us how you're connecting, i.e your connection string. And which computer are you running the application from, the system which has the instance of MySQL on it or the client machine?
Jan 18 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.