belllooki.blogg.se - Setup mysql database server on desktop

#Setup mysql database server on desktop install
#Setup mysql database server on desktop zip file
#Setup mysql database server on desktop software
#Setup mysql database server on desktop password

Edit this file, find the following lines and modify them as follows (all should exist already): Now, navigate to C:\PHP, and copy php.ini-development to php.ini. Search for the line starting DirectoryIndex. It MUST match the Apache version installed. The version of the module file matters (2_4 in this case). LoadModule php7_module "C:/PHP/php7apache2_4.dll" At the end of this file (or wherever you like if you want to be more organised) add the following lines: In the file explorer navigate to C:\Apache24\conf\nf. Also, if you get weird error messages, or no error messages at all, read the bit on the left of where it talks about installing "C++ Redistributable for Visual Studio")

In a console window, type php -v to see if it worked.

#Setup mysql database server on desktop zip file

Open the zip file and extract to C:\PHP\.Go to and download php-7.0.0-Win32-VC14-圆4.zip file or x86.zip depending the Operating System you have.

#Setup mysql database server on desktop install

Now install the PHP scripting language on your PC.

You should get a screen up to the effect that Apache is installed and working.

To test it worked type ' into your browser.

Don't close this window, you will need it again in a minute. you may well get a warning about the server name. BUT, right click, and select 'Run as administrator'.

Find Start > All programs > Accessories > Command Prompt.

You should end up with a directory 'Apache24' (or whatever the latest version is). You need to be careful that the module dll in PHP matches the version of Apache you install. Scroll down the page until you find the download for the 'Apache 2.4 win32 binaries' and download.

Install the Apache web server on your PC.

After successful installation check for the link – for further set-up.

You don't have to worry too much about this.

The server management screen should appear.

A box should pop up asking for the root password. Under Server Administration (right hand column, double click 'Local MySQL56' (or whatever you called it).

On the Service details page, accept the defaults and hit Next and then Next a couple more times for the configuration progress.

This would be good practice on a public server but just using the 'root' user will suffice for testing. You can also create a 'User' account just for Moodle with more restricted access if you like.

#Setup mysql database server on desktop password

On the password screen, supply a password for the 'root' (main administrator) user.

Accept all the defaults on the 'MySQL Server Configuration' and hit Next.

At 'Configuration overview' hit Next to go to the basic configuration screen.

#Setup mysql database server on desktop software

At 'Installation progress' screen, hit Execute - the MySQL software will be installed.Click Execute and follow onscreen instructions to install them. A number of downloads of required software may be identified.At 'Choose a Setup Type' accept the "Developer Default" and click Next.Go to and select Product Version 5.7.29.0 download the mysql-installer-community-5.7.29.0.msi. We will do this using the 'MSI' one-click installer for Windows. Install the MySQL database server on your PC.

Sometimes it didn't appear but you do see a shield dimly flashing in the task bar. Make sure your Windows installation is in good shape, you clear out all the junk and stuff making it run slower (because installing all this server software certainly isn't going to make it run faster!) and that you have installed any outstanding updates.ĪNOTHER NOTE: Watch out for the irritating "Do you want this program to get control of your computer" window that comes up at various stages. I never use Windows and I managed, but this may not be the quickest or most efficient way to do things. NOTE: This assumes that you are comfortable with administering a Windows system and can use the command line. Proper server configuration and security is not considered. This is intended only as a testing/evaluation install via 'localhost'. These are instructions for installing on Windows 7 desktop (they may also be useful for a server install with some thought to security) using individual components rather than a one click installer.