MySql Connection from .NET

[kafain]

Hi,

I recently installed mysql using the connection:

server: localhost
port: 3306
username: root
password: SOMETHING

If I connect through mysql admin, I can see the databases I created.

I'm working on a .NET program that someone else started with the connection parameters:

mysql_Server: localhost
mysql_Port: 3306
mysql_Username: root
mysql_Password: SOMETHINGELSE

'This line connects to the mysqld.exe file in the database\bin directory
Call Shell(sz_InstallPath & sz_MySQLStart & " --skip-innodb", AppWinStyle.Hide)

The connection string connects to the .NET parameters as stated above.

When .NET tries to open the connection. I get this message #28000Access denied for user 'root'@'localhost' (using password: YES).

I'm assuming this is because it's trying to access my original mysql database above.

How do I get .NET to specifically access this database that is in the database\bin and not my normal connection? Do I need a different port? Do I need a "ServerThread"? What is a server thread?

Any help is greatly appreciated.

[mwasif]

Moved to MySQL forum.

[mwasif]

Call Shell(sz_InstallPath & sz_MySQLStart & " --skip-innodb", AppWinStyle.Hide)

What you are trying to do? Connecting to MySQL Server or starting it? If you want to start mysql consider starting mysqld.

[kafain]

I'm trying to open a connection to the mysql database through .NET. I believe .NET is trying to access the database I created instead of the one that is associated with my .NET application.

First the Shell is called:
Call Shell(sz_InstallPath & sz_MySQLStart & " --skip-innodb", AppWinStyle.Hide)

where sz_MySQLStart is equal to "database\bin\mysqld.exe".

Second m_strConnStr is created:
m_strConnStr = String.Format("server={0};user id={1}; password={2}; database={3}; port={4}; pooling=false", mysql_Server, mysql_Username, mysql_Password, mysql_Db, mysql_Port)

Then this code is called:

Try
mysql_Conn = New MySqlConnection(m_strConnStr)
Try
mysql_Conn.Open()
Return True
Catch
Return False
End Try
Catch ex As MySqlException
Return False
End Try

Then I get the error...in the first Catch statement. I could connect before I installed MySql and created my own database with my own connection information. Now I cannot with the above error.

[kafain]

I guess I'm on my own. If anyone is interested, I stopped MySQL services and then I was able to connect to the database through the .NET program. Now I have to figure out how to make .NET go to the other program instead of going to my default database.

[aherraiz]

I guess I'm on my own. If anyone is interested, I stopped MySQL services and then I was able to connect to the database through the .NET program. Now I have to figure out how to make .NET go to the other program instead of going to my default database.

I think you would find the MySQL .NET connector very useful (if you use VS2005). It manages the connection to the DB quite nicely and integrates in VS2005.

MySQL .NET Connector 5.1

[r035198x]

... Now I have to figure out how to make .NET go to the other program instead of going to my default database.

I'm not sure what you mean by that statement but you specify the database you're conncting to in the connection string.

[kafain]

Hi,

Thanks for the tips. I downloaded Connector/Net, but forgive my newbiness, it doesn't address my question directly. You know how SQL has the Service Manager. MySQL does too and it's "Started" and connected to database A. I have a .NET program with a database in the Debug folder (database B). If I "stop" the instance..and stop msqld.exe (manually)...it connects to database B. Otherwise, it tells me to bite it.

I don't know about threads, but would I have to create one pointing to database B? Do I have to check to see if mysqld is running and shut it down? What do you do to connect to multiple databases? There must be an easy way to tell .NET...hey I want this database and not this one.