can someone help me set up mysql

[jmfour20]

please. +Rep's will be handed out accordingly, thanks in advance homeslices.

[Sounddead]

Do you mean like.. downloading it and then setting it up so you can put a DB onto it?

[jmfour20]

Do you mean like.. downloading it and then setting it up so you can put a DB onto it?

yes, and if anyone has the ac repack readme, can you tell me the default port, i changed it to 3306 out of a bright idea i had at the time and now my realms are gone.

[Sounddead]

Go here-
MySQL :: MySQL 5.0 Downloads
And download Windows ZIP/Setup.EXE (x86)

Now extract that to your desktop, double click the .exe.
Click next> Typical, next> Install.
let it install. :wave:

Check Configure the MySQL Server now and click finish.

When the next window comes up click
Next.
Detailed Configuration, next.
Devoper Machine, next.
Multifunctional database, next.
Next.
Decision Support, next.
Make sure both Enable TCP/IP Networking and Enable Strict Mode is checked, and click next.
Standard Character Set, next.
Install As Windows Service, next.
Enter in a password, make sure Enable root access from remote machines is checked and press next.
Now hit execute.


There you go.

[jmfour20]

yea everytime i go to do that i get a pop up that says "port 3306 is already in use are you sure you want to continue" and i hit yes

-then-

"The security settings could not be applied to the database because the connection has failed with the following error.

Error Nr. 1045
Access denied for user 'root'@'localhost' (using password: NO)

if a personal firewall is running on your machine, please make sure you have opened the TCP port to 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press [Retry] to apply the security settings.

If you are re-installing after you just uninstalled the MySQL server please not that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu."

now that last part doesnt apply to me and i dont know what to do..:confused::confused::confused::confused::confused:

[Sounddead]

Try it again, but first hit
ctrl+alt+delete

And end mysql-nt.exe

[jmfour20]

alright sweet it worked now how would i go about getting my database and whatnot set up? deff. giving you +Rep, you are my hero btw.

[Sounddead]

Well assuming you already have a DB (If not you can get the latest DB here Filebeam - Free Fast File Hosting)

Then download Navicat Lite(Navicat - the World's Best MySQL Front End for Windows, Linux & Mac OS X), or SQLyog(Download - SQLyog MySQL Frontend, MONyog MySQL Monitoring Tool).
Navicat is better imo, but it doesnt really matter.

(Gonna teach you how to do it with Navicat btw)
Open up Navicat and click the button called connection.
Type in a connection name such as Ascent or Your server name.
leave everything the same except for password which is what you put in the password box when setting up MySQL.
Click ok, and then it should show up on the left.
Double click your connection on the left and then it should like expand. Right click on it now and click new database.
Name it World.
now it should be in the little expandy thing, right click on it and click execute batch file, choose the file of your DB.sql, and click Execute. Should do everything on its own now.

[Sounddead]

I gots to go now though, so good luck.
I'll be back tomorrow if you have any more questions

[jmfour20]

ugh, i cant get on my server now, and it says it has something to do with the database, and i cant open the database either......./wrist

[Sounddead]

add me on msn.
[email protected]

ill help you more when I get back

[jmfour20]

alright, ill more then likely need you again lol, thanks for the help

[jmfour20]

add me on msn.
[email protected]

ill help you more when I get back

mine is [email protected]

[jmfour20]

Bump this so i dont go crazy