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.
GioMazing16 0 Newbie Poster
cereal 1,524 Nearly a Senior Poster Featured Poster
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 36 Newbie Poster
If you get the mysqli msi package, it's simlicity itself, assuming you're on windows of course.
GioMazing16 0 Newbie Poster
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 36 Newbie Poster
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 1,524 Nearly a Senior Poster Featured Poster
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 36 Newbie Poster
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 1,524 Nearly a Senior Poster Featured Poster
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.