SETTING UP (Web hosting account) MYSQL AND PHPMYADMIN The lower half
SETTING UP MYSQL AND PHPMYADMIN The lower half of the dialog box gives you the option to include the bin directory in your Windows PATH. This option enables you to interact directly with MySQL and its related utilities at the command line with out the need to change directory every time. You won t need to do this very often if at all but selecting this option makes life a little more convenient if the occasion ever arises. Click Next. If you get a warning message that a Windows service with the name MySQL already exists, you will be asked if you want to use this name. You must click No and choose a different name from the drop- down menu in the Service Name field. 10. A fresh installation of MySQL has no security settings, so anyone can tamper with your data. MySQL uses the name root to signify the main database administrator with unrestricted control over all aspects of the database. Choose a password that you can remember, and enter it in both boxes. Unless you access your development server from a different computer over a network, leave the Enable root access from remote machines check box unchecked. Do not check Create An Anonymous Account. It will make your database insecure. If you are upgrading an existing version of Windows Essentials and want to keep your current root password, deselect the Modify Security Settings check box. If this is a first- time installation, you probably won t have this check box. Click Next when you have finished. 10 11. At long last, everything is ready. Click Execute. If you have installed a software fire- wall, it will probably warn you that MySQL is trying to connect to a DNS server. You must allow the connection; otherwise, MySQL will never work. 12. Assuming that all was okay, you should see a screen confirming that the configuration process is complete. MySQL should now be running even if you selected the option not to start automatically (the option applies only to automatic start on bootup). 267
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.