The virtual machine limits the memory of the application independently from the installed memory that is available to the operating system. When retrieving large result sets, you might get an error message, indicating that not enough memory is available. In this case you need to increase the memory that the JVM requests from the operating system or change your statement to return fewer rows.
When using the Windows launcher e. When using the shell or batch scripts, the available memory is defined through the -Xmx parameter for the java command.
MySQL Workbench provides DBAs and developers an integrated tools To be able to install and run MySQL Workbench on Windows your system needs to. Please note that these are old versions. New releases will have recent bug fixes and features! To download the latest release of MySQL Workbench, please visit.
In the following example, the parameter -Xmx4g sets the available memory to 4GB. Pre-requisites 4.
First time installation 4. Upgrade installation 4.
Starting the program from the commandline 4. Starting the program using the shell script 4. Configuration directory 4. Copying an installation 4.
Increasing the memory available to the application. First time installation. Upgrade installation. Starting the program from the commandline. Starting the program using the shell script. Specifying the Java runtime for the shell script. Specifying the Java location. Defining the memory for the application. Configuration directory.
The current directory The directory where sqlworkbench. General configuration settings workbench. But the path to MySQL directory depends upon the architecture of the application. If you have installed x64 version then it should be in C: Otherwise, it should be in C: Add ; at the end of the current variable value and append C: Click OK to save. To login into the MySQL server use the following command:. After the installation MySQL server will start automatically. At anytime, we can check the status of the MySQL server using the following command:.
Double-click the installer to start and go through the usual installation process. After the successful installation, you will be provided a temporary password to login into MySQL server. The temporary password is not recoverable so make sure to copy and save it in the safe place.
Consequently, we have to execute MySQL by specifying the full path to it in the terminal. As the screen shows, currently, MySQL server is not running. You will then be prompted for a password. Enter the temporary password you copied at the time of installation and hit Enter.
Once you are inside the terminal, change your password using the following command. Logoff and then login again for the changes to take effect.
To verify the changes try running MySQL with without specifying the full path to it, as follows:. Notify me of follow-up comments by email. Notify me of new posts by email. Scroll down a little and you will be displayed download links like this: You could create a database for use with tools like Drupal, for example. With MySQL Workbench, however, you better have a much deeper understanding of databases or you will have a tough time getting it to work properly.
MySQL will now be lacking a graphical tool for new users. Not only will this tool make your job easier, it will most likely introduce you to aspects of the MySQL database you never knew existed. If so, what do you think? Rate your experience and compare the results to what other TechRepublic members think. Give your own personal review in the TechRepublic Community Forums or let us know if you think we left anything out in our review.
Read our field-tested reviews of hardware and software in TechRepublic's Product Spotlight newsletter, delivered each Thursday. We explain who would use the product and describe what problem the product is designed to solve. Automatically sign up today! Jack Wallen is an award-winning writer for TechRepublic and Linux.