Unknown database ('database_name')

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ivory
    New Member
    • Dec 2012
    • 4

    Unknown database ('database_name')

    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
  • PsychoCoder
    Recognized Expert Contributor
    • Jul 2010
    • 465

    #2
    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?

    Comment

    Working...