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.

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

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!!

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.

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

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.

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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.