MySQL Administrator for Windows

1/4

Getting and installing MySQL Administrator Just like any other program, getting and installing MySQL Administrator needs to be done with caution. There are a number of components that make up the MySQL database management system, and if you don't know what you're doing, it's easy to get confused or end up with a badly configured system. Luckily, there are a number of good products for managing MySQL and deploying various MySQL functions across your servers. The three primary products that I recommend are:

Microsoft SQL Server: MySQL is included by Microsoft in all Microsoft Windows servers since the earliest versions of Windows ever released. Getting and installing MySQL on your Windows server is as simple as going to Control Panel > Administrative Tools > System Tools and selecting "Microsoft SQL Server". Installation of this component is also as simple as going to Control Panel > Add/Remove Programs and then removing the "Microsoft SQL Server" component. You can test whether your installation is successful by trying various commands or connecting to your MySQL database. If you see a message saying "You do not have access to your database", chances are that your installation of MySQL is unsuccessful because you either don't have privileges to connect to your database or you haven't written the right programs to allow access to your database.

phpBB MySQL Client: The PHP MySQL client (aka phpBB) is a web based MySQL client for the Windows OS. While it does utilize the Windows OS, the main driving force behind the installation is MySQL itself. To install the MySQL client, you need to download a PHP binary using your web browser and then install the binary using your Windows Installer. The installation is pretty simple - you just copy the files from your OS to the PHP binary you downloaded. You can connect to your MySQL database via your windows bash shell or web browser.