Installation Process

[GioMazing16]

Does anyone know how to properly install MySql Server? I am having trouble installing it. It's one of the last steps for the MySQL installer package.

[cereal]

Exactly what is the problem? Which version are you trying to install and which platform are you using? For more information read: http://dev.mysql.com/doc/refman/5.1/en/installing.html

[TonyG_cyprus]

If you get the mysqli msi package, it's simlicity itself, assuming you're on windows of course.

[GioMazing16]

yeah i got the windows package but i didn't properly configure the server. I wasn't even able to set up a password. Now when i try to create a query it won't let me. Please help!!

[TonyG_cyprus]

Uninstall it and start again, slowly, and paying attention at every step.
The installer does it all for you with default(leave as is) settings, except for the password.

[cereal]

To avoid the reinstall you can also run:

mysqladmin -uroot password new_password

Where password is a command and new_password his value. After you set the root password you can log into the server: http://dev.mysql.com/doc/refman/5.5/en/mysqladmin.html

[TonyG_cyprus]

I see where you are with that, Cereal, but unfortunately, I've never been able to get the mysql command line client to work! My bad probably, I lose the plot, and go back to a gui, like phpmyadmin. In GioMazing's case, I'd go for the uninstall, it only takes a few minutes.

[cereal]

I see. That probably happens because MySQL bin directory is not added to the system path, I'm not sure it's possible to add a flag to include it during the installation process, right now I don't remember. But you can edit the Windows Enviroment Variables: http://docs.oracle.com/cd/E17952_01/refman-5.5-en/windows-start-service.html

That way it becomes easy to execute the commands, because the system knows where the bin directory is located. Anyway, mine was only an alternative solution. Bye!