However, if you want to use it with PHP, changes have to be made to the php.ini file. The newly installed MySQL Server will run on it’s own without any problem and is an ideal platform to learn the SQL (Structured Query Language). Hurray! Rejoice because you have been able to correctly install MySQL on Windows 7 ! Configuring PHP to work with the MySQL installation This simple SQL command instructs MySQL to display the names of the installed databases and there should be four of these. Type show databases (the semi-colon at the end is not a typo) and hit the enter key. The MySQL client displays the mysql> prompt on successful login. Now enter the MySQL password – the characters you type will be replaced by the asterisk sign (the password is not shown for security reasons – obviously). Fire it up from “ All Programs” -> “ MySQL” -> “ MySQL Server 5.5“. The easiest way to check MySQL installation and confirm that it’s working properly is to use the MySQL Command Line Client. Now go to C:\MySQL\bin folder and double click on MySQLInstanceCOnfig.exe file to launch the wizard once again. However, if the MySQL Instance Configuration Wizard becomes unresponsive (the window shows a ‘Not Responding’ message), launch the Task Manager either from the Control Panel or use the old Ctrl-Alt-Del key combination and kill the program. Generally, the instance should be configured without any problem. Ignore messages from the anti-virus program and answer in the affirmative when the Windows 7 UAC (User Account Control) asks whether you want to run MySQLInstanceConfig.exe file.The configuration wizard has received all the information it needs and is ready to create a MySQL server instance.The password doesn’t have to be very strong because, I suppose, you would be using MySQL on your computer for learning/development and NOT production. Remember to keep a note of it and don’t lose it. The password for the MySQL server instance has to be typed in twice.Yes, it’s recommended to install MySQL as a Windows service and have the system include the MySQL bin directory in the Windows PATH variable. Move ahead with the “ Standard Character Set”.For the networking options configuration, put a check mark in front of “ Enable Strict Mode” if it’s not there.The same goes for the subsequent screen click “ Next”.In the following screen, don’t mess with the default values and click “ Next”.I suggest going ahead with “ Multifunctional Database” unless you know what you are doing.Select “ Detailed Configuration” option.Please note that you cannot use MySQL until an instance has been configured, so these steps are quite important. The MySQL Instance Configuration Wizard will now launch click “ Next” to proceed.You are now prompted to Configure the MySQL server click “ Finish”. Congratulations – MySQL has been installed on your computer. When the process finishes, you’ll get to see the final screen.You may also get messages along the way – simply click on “ Next” to proceed.It would take some time for the progress bar to start moving… be patient.You are now ready to install MySQL on Windows 7 operating system.The installer will change the MySQL installation folder to the one specified by you – C:\MySQL.Click the “ Browse” button and enter C:\MySQL in the Folder name field.FYI, choosing Typical will put MySQL deep down in the “ Program Files” folder. In the following screen, select Custom installation which will allow you to specify the folder to which MySQL will be installed.Accept the terms in the License Agreement by checking the box and hit “ Next”
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |