MyAssQL

[Shadowplate]

If most of you don't already know, I am taking computer programming in college. One of the subjects that I am currently taking right now is Business Software Systems. I've been prompt to do an assignment (more like a mini quiz) that requires MySQL. There is a full instructed word document in detail that my instructor provides in the college's website, and I followed every single instruction in that document only to get an error at the end of the configuration part. The server will not work with my laptop, so I told my instructor that it wouldn't work and he redirected me to the IT help desk. So for 2 hours (by then class is done and probably lost the mark, we'll see) me and one of the 2 guys at the help desk was trying to figure out what's wrong with mySQL, eventually a third IT guy came and he basically said that the IT help desk, that my teacher/instructor fully suggested, doesn't support MySQL and therefor couldn't help me but suggested that I should manually install the program on my own because for some reason manually installing it at the IT help desk doesn't work. And to add it all up, my laptop ran out of batteries because the chargers there didn't work, just fffuuuuuuuuuuuughafhafkwaoawdnd /AngryBeardedEmoteFace.

Anyways I was hoping if anyone has or uses MySQL to help me or give me some suggestions, that would be awesome. I'm also googlen this problem, haven't found anything yet, but I'll keep searching.

[Hogger]

Yeah MySql can be annoying to just set up, can you explain everything you've done and what you're trying to do; are you using a compiler like Visual Studio or just something like the Apache console?

What are you trying to do with the assignment anyways, simple database stuff with making tables and blargh? I have a MySql database you could connect to but I would only be able to explain how using Visual Studio.

Can you just explain what you're doing in bit more depth pl0x

[GinsengSamurai]

Not sure if you already did this, but I suggest you download XAMPP. The latest stable releases of:

Apache 2.2.21
MySQL 5.5.16
PHP 5.3.8
phpMyAdmin 3.4.5
FileZilla FTP Server 0.9.39
Tomcat 7.0.21

I use this for development on my Windows machine. To test out your local web files, you need to move them to the htdocs folder inside XAMPP. Then point your browser to http://localhost/ and it will run them accordingly. PHPMyAdmin will be used to create your SQL table.

XAMPP can test out ASP files too. It's just a web-emulated environment to test out your web files. Mind you, as Hogger mentioned, you still need Visual Studio to create the .NET files.

[Shadowplate]

My compiler is Visual Studio, and I am currently trying to make tables with MySQL. I tried using tons of methods from google to get the service to work, some of which I don't remember but most of them were basically installing MySQL a different way. Most of those suggestions you provided I've already installed and tried, but I haven't gotten any Apaches. I'll consider getting those installed as well. I'll describe the installation and error:

1. Install MySQL Product
2. Check for newer versions of the product, Execute
3. (using)Developer Default, Installation Path: C:\Program Files\MySQL\, Data Path: C:\ProgramData\MySQL\MySQL Server 5.5 (/ ! \ The data path already exists.)
4. The following requirements must be installed before the selected products can be installed. (Checked) Microsoft Visual C++ 2010 32-bit runtime MySQL Workbench CE 5.2.38, (Checked) Microsoft .NET Framework 4 Client Profile MySQL Workbench CE 5.2.38
5. To be installed (in order); MySQL Server 5.5.21, MySQL Workbench CE 5.2.38. Connector/ODBC 5.1.8, Connector/C++ 1.1.0, Connector/C 6.0.2, Connector/J 5.1.15.0, Connector/NET 6.4.4, MySQL Documentation 5.5.21, Samples and Examples 5.5.21 - Execute
6. MySQL Server 5.5.21 Initial configuration. (grayed out) Samples and Examples 5.5.21Initial configuration. (Next >)
7. Please select the type of configuration for the MySQL Server instance - (checked) Developer Machine, Server Machine, Dedicated Machine
8.Please specify the Network, Windows, and Security settings - (checked) Enable TCP/IP Networking (Port Number ----) - (checked) Create Windows Service Name (MySQL55) - Security Settings (Current Root Password ****)(MySQL Root Password ****) --both the same password--
9. MySQL Server 5.5.21 | Configuration failed. Check details - Show Details >

mysql-server-5.5-winx64:6 - Looking for valid template
mysql-server-5.5-winx64:13 - Found valid template.
mysql-server-5.5-winx64:20 - Attempting to process template.
mysql-server-5.5-winx64:26 - Processed template.
mysql-server-5.5-winx64:33 - Attempting to configure service.
mysql-server-5.5-winx64:40 - Configured service.
mysql-server-5.5-winx64:46 - Attempting to start service.
mysql-server-5.5-winx64:100 - Unable to configure service.
mysql-server-5.5-winx64:100 - Product configuration controller finished configuration.

Last Error: Unable to configure service.

damn

[Hogger]

I remember trying to do it the way you say SP then gave up and did some sort of automatic install. The only thing you have to do after that in Visual Studio is add the MySQL reference and .dll file.

I won't have my laptop until Saturday night but I'll be able to give you a step by step on how to set it up then if you still need it (tbh I don't get why your tutor couldn't have just let you use normal SQL, same functionality minus the headaches)

[GinsengSamurai]

His tutor probably wants Shadowplate to go through the same pain and misery himself went through.

[Hogger]

His tutor probably wants Shadowplate to go through the same pain and misery himself went through.

Hehe true

[Hogger]

Ooh by living in the future I can see it's your birthday tomorrow SP, 21 too ^^

Have a good birthday man and make sure you get plenty of drinks

[Hogger]

Still need help with this issue, SP?

[Shadowplate]

Well I haven't done anything since my last post, it's just too frustrating to work with and I rather celebrate my birthday before I do anything else.

[Hogger]

Try following this Shadowplate:

1. Go to this link, you should see this:





2. Click on the upper most link seen here:





3. Click the text that says "» No thanks, just take me to the downloads!" seen here:





4. Click on a download link, yours should have some Canadian links at the top SP as it works off your IP address (All the links are clean so don't worry about which you use) Being in the UK I see this:



Just click the top link that shows up for you.



5. When the file has downloaded open it up and you should see this installer:





6. Click "Typical" on the install options:





7. Go through the installer with the usual nexts, then click finish:





8. Now you need to open up Visual Studio, make a new C# application




9. Call it anything:





10. You should see a nice blank form like this:





11. Now click on "Project" and go down to "Add Reference":





12. Go to the .Net tab and scroll down to find "MySQL.Data"





13. If the reference added properly you should be able to see the reference in the Solution Explorer:





14. That should be everything! Now we can test some code to make sure it works. Drag a button and a label onto the form:





15. (I made you a database on the MySQL database I have for you to test this on)

Double click on the button and paste the following code into the function:

Code: Select all

            MySqlConnection con = new MySqlConnection("server=my01.winhost.com;Database=mysql_19162_shadowplate;user=shadowplate;password=shadowplate123;");
            MySqlCommand command = new MySqlCommand("Create table test(username varchar(50), time datetime, randomText varchar(50))", con);
            con.Open();
            command.ExecuteNonQuery();
            con.Close();

            MySqlCommand command2 = new MySqlCommand("insert into test values ('Shadowplate',date(current_timestamp),'lololololol')", con);
            con.Open();
            command2.ExecuteNonQuery();
            con.Close();

            label1.Text = "done";

Then go up to the references at the top and paste this under the other references:

Code: Select all

using MySql.Data.MySqlClient;

This should look like this:



and the button code should look like this:






16. Press 'F5' and click on the button. If it works you should see this:




If you see "done" then just close the application




17. Now we need to go see the table data to make sure it added properly. Make sure Server Explorer is up by going to View -> Server Explorer:





18. Now go to the Server Explorer pane and click on the Add Connection button at the top:





19. On the following pane click Change datasource:





20. Choose MySQL Database:





21: Click Ok and type in the following into the relevant boxes:

Code: Select all

Server name: my01.winhost.com

Username: shadowplate

Password: shadowplate123

Database name:  mysql_19162_shadowplate

This should look like this:





22. Click Ok, then go back to the Server Explorer pane and click the arrow next to Tables then right click on "test_table" and click retrieve data:





23: If it all worked you should see this:






Et voilà!

If any steps don't work for any reason please just make a screenshot or explain the error and I'll have a look. If you need any help actually making some code for a project or anything just ask.

[Shadowplate]

Not exactly what I wanted, but quite useful nonetheless. Thanks, I shall use this.

And keep this information, I might need it later.

[GinsengSamurai]

Yeah this should be a good reference point for me as well. Thanks for the info.