MySQL and Wamp Server 3.0 Install issues on Windows 10
The Issue
A while ago i had some issues getting My Sql Running on windows 10 , the default installation that wamp server 3.0 uses for My Sql is the route cause of the issue
The Solution
After some playing around i still could not find out why My Sql and Windows 10 wouldn't play ball , so i opted to install MySQL Community Server directly from the MySql WebSite , selecting "MySQL Community Server "
Once downloaded install it to where your MySQL is located in your wamp server setup. Once done you might need to modify the ini settings for the MySQL server in your wamp ini file( so it uses the new version). Once done it should work .
A few issues i did come across , if you have MS SQL server installed you might have port 80 in use - the typical offenders here are IIS , skype and SQL server reporting services. I now have MySQL and MS SQL Running and connected in Apache & PHP,
The prefered drivers i use are the PDO drivers listed in the previous article ( as an example for PHP 5.6 i am using php_pdo_sqlsrv_56_ts.dll) - make sure you have the it listed under your extensions and you have the correct 64 or 32 bit version installed.( see previous article if you need to find where to get the dll's from and how to identify if you need 32 or 64 bit)
The Next Articles - PHP Mailer intro , Bootstrap 3 and Mobile First.
In the next installment of this blog i'll talk about how to use the php mailer add on for non Unix systems ( The windows PHP doesn't have mail built in) and how i'm using it to send out registration details so the user can go from unregisted to register when they run a registration script .
Also for those interested i will show you how you can detect if your client is on a mobile browser, for me i change the header graphics logo so if on mobile its smaller etc.using media queries
