SmartFAQ is developed by The SmartFactory (http://www.smartfactory.ca), a division of InBox Solutions (http://www.inboxsolutions.net)
How do I get started with MySQL and C#?
Requested and Answered by Vanna on 24-Jan-2011 01:10 (5029 reads)
1.Dowload and install MySQL Community server from http://dev.mysql.com/downloads/mysql/.
Tip: During installation, it will ask for a lot of personal details. You can also just scroll to the bottom and click on skip registration.
2.Install it using default options.
3.In the final stage of the wizard, you might see that it seems to be hanged on 'Apply security settings". If it appears to be hanged, do this:
3.1 Go to Control panel->Administrative tools->services. Select MySQl and choose Stop service
3.2 Use task manager and click on end process for mySQLconfiguration.exe. The hanged dialog should exit now.
4. Go to Services panel, and start mySQL service
5. Open a command prompt and type this:
mysql -u root -p
6. It will ask for password, enter the root password you had chosen during installation.
eg., output:
1.Download ADO .NET connector from this page: http://www.mysql.com/downloads/connector/net/
2. In the download connector page, select to download mysql-connector-net-6.3.6.zip.
3. Extract the file and run mysql.data.msi
Using the database
1.Download and install MySQL workbench from http://wb.mysql.com/
2. Creata a new schema.
Following is an example for creating a new schema called "test":
Step 1:
Open SQL workbench and click on Local host
Step 2:
Click on "Create new schema button" and create it with name "test" (as per terminology, schema is a database in MySql)
Step 3:
Select default schema as "test", and then copy paste text from script file in pairsdb.sql. Then click on execute button
Tip: During installation, it will ask for a lot of personal details. You can also just scroll to the bottom and click on skip registration.
2.Install it using default options.
3.In the final stage of the wizard, you might see that it seems to be hanged on 'Apply security settings". If it appears to be hanged, do this:
3.1 Go to Control panel->Administrative tools->services. Select MySQl and choose Stop service
3.2 Use task manager and click on end process for mySQLconfiguration.exe. The hanged dialog should exit now.
4. Go to Services panel, and start mySQL service
5. Open a command prompt and type this:
mysql -u root -p
6. It will ask for password, enter the root password you had chosen during installation.
eg., output:
C:\Documents and Settings\quantcode>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.8 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
1.Download ADO .NET connector from this page: http://www.mysql.com/downloads/connector/net/
2. In the download connector page, select to download mysql-connector-net-6.3.6.zip.
3. Extract the file and run mysql.data.msi
Using the database
1.Download and install MySQL workbench from http://wb.mysql.com/
2. Creata a new schema.
Following is an example for creating a new schema called "test":
Step 1:
Open SQL workbench and click on Local host
Step 2:
Click on "Create new schema button" and create it with name "test" (as per terminology, schema is a database in MySql)
Step 3:
Select default schema as "test", and then copy paste text from script file in pairsdb.sql. Then click on execute button
Discuss or give feedback? Just enter your message and click on submit. No registration is required.
|
The comments are owned by the poster. We aren't responsible for their content.
|
||||||||||||||||||
How do I get started with MySQL and C#?Discuss or give feedback? Just enter your message and click on submit. No registration is required.