![]() ![]() Whether you just need PHP and MySQL so that you can experiment with WordPress template designs or are the “I build on Windows, but deploy on Linux” type or are developing for a server setup where IIS is serving both ASP.NET and PHP apps (and yes, IIS does that!), you’re going to want MySQL on your dev box. Hence this article, where I walk through the steps of installing MySQL Server 5.1 on Windows for a developer machine. You’ll be told that you need to install MySQL, but it leaves installing it up to you. One necessary thing that the Web Platform Installer doesn’t do for you – and I assume it’s because of licensing restrictions of one kind or another – is install MySQL, which many PHP apps, including a number that the Web Platform Installer installs, use. (While the old way of installing PHP on Windows wasn’t rocket science, it involved enough steps and configuration changes to justify my writing a whole article on the topic in an old developer blog of mine.) It makes installing these goodies a simple of matter of checking the items you want and clicking the Install button. 18 after 10 attempts.You’ve probably heard of Microsoft’s Web Platform Installer, a free-as-in-beer tool that makes it a snap to install a variety of Microsoft and Open Source web applications and development tools, ranging from “The Usual Suspects”, such as Visual Web Developer, IIS and SQL Server 2008 Express to stuff you might not expect, such as PHP and WordPress. ![]() Retry 10: Attempting to connect to 3306 with user root with no password.įailed to connect to MySQL Server 8. Retry 9: Attempting to connect to 3309 with user root with no password. Retry 8: Attempting to connect to 3306 with user root with no password. Retry 7: Attempting to connect to 3309 with user root with no password. Retry 6: Attempting to connect to 3306 with user root with no password. Retry 5: Attempting to connect to 3309 with user root with no password. ![]() Retry 4: Attempting to connect to 3306 with user root with no password. Retry 3: Attempting to connect to 3309 with user root with no password. Retry 2: Attempting to connect to 3306 with user root with no password. Waiting 5 seconds before the next connection attempt. MySQL error 1042: Unable to connect to any of the specified MySQL hosts. Retry 1: Attempting to connect to 3309 with user root with no password. 18 can be established (with a maximum of 10 attempts). Waiting until a connection to MySQL Server 8. 18 intialized the database successfully.Įnded configuration step: Initializing database (may take a long time)īeginning configuration step: Starting the server Successfully started process for MySQL Server 8. Process for mysqld, with ID 3420, was run successfully and exited with code 0. They will be merged with strict mode in a future is created with an empty password ! Please consider switching off the -initialize-insecure option. ' NO_ZERO_DATE', ' NO_ZERO_IN_DATE' and ' ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. Starting process with command: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe -defaults-file= " C:\ProgramData\MySQL\MySQL Server 8.0\my.ini" -console -initialize-insecure=on -lower-case-table-names= 1. Beginning configuration step: Initializing database (may take a long time)ĭeleting the data directory from a previous (failed) configuration.Īttempting to run MySQL Server with -initialize-insecure option. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |