In the previous post, I made references to MySQL but didn’t say anything about a quick local setup. So here’s what I did for mine:<\/p>\n
– Download MySQL binaries from http:\/\/dev.mysql.com\/downloads\/mysql\/<\/a>. I chose the huge 64-bit Zip archive. In the previous post, I made references to MySQL but didn’t say anything about a quick local setup. So here’s what I did for mine: – Download MySQL binaries from http:\/\/dev.mysql.com\/downloads\/mysql\/. I chose the huge 64-bit Zip archive.– I unzipped … Continue reading
– I unzipped the \/bin\/<\/b>, \/data\/<\/b>, \/docs\/<\/b> and \/share\/english\/<\/b> folders into my destination MySQL folder. Then I deleted all the *.pdb files.
– Start the server via start mysqld<\/b>. You can later stop it with mysqladmin.exe shutdown -u root<\/b>.
– By default it has a root user without password, and an anonymous user.
– Run the client with mysql -u root<\/b>.
– Delete the anonymous user or it will mess up with your ability to connect using other users you create: DELETE FROM mysql.user WHERE user=”; FLUSH PRIVILEGES; <\/b>
– Create your database and your development user: CREATE DATABASE MyDatabase; GRANT SELECT, CREATE, DELETE, UPDATE, INSERT ON MyDatabase.* to MyUser@’%’ IDENTIFIED BY "MyPassword";<\/b>
– Now you can connect as your development user with mysql -u MyUser -pMyPassword<\/b>.
– I recommend downloading MySQL Workbench from http:\/\/dev.mysql.com\/downloads\/workbench\/<\/a> to perform database maintenance.<\/p>\n","protected":false},"excerpt":{"rendered":"