Tags:
not added yet
Installing MySQL Database on Windows
For details about MySQL installation not covered in this guide you can refer to the official documentation on dev.mysql.com Table of Contents
Supported MySql VersionsMySQL 5.5.x and 5.6.x are supported. codeBeamer-7.9.0 and higher support also MySQL 5.7.x. For more information please refer to the appropriate codeBeamer Release Notes. For codeBeamer-8.1.x or higher installations MySQL 5.7.x is recommended.Software dependency for MySQL installerThe installation of the following software is prerequisite of MySQL installation
Cleanup possible old MySql installationsIf MySQL was previously installed on the system it should be ensured that all MySQL related directories and files are removed (to avoid for example that the root password gets inherited from the old installation). The directories below should not exist. The directory names might be different depending on the Windows and MySql versions:
Fast InstallationThis section is about installing MySQL 5.x with guided wizard installer (examples are provided for specific version 5.7). Downloading MySQLDownload MySQL installer package from MySQL download site. If you cannot see the version you wish to download click on "Looking for previous GA versions?". It is not necessary to sign up if offered, there is a "No thanks, just start my download." link for bypassing that. Installing MySQL
Network configuration page:
Service configuration page:
Congratulations! MySQL server is installed and you can carry on with codeBeamer installation.
Advanced InstallationThis section is about installing MySQL 5.x from ZIP archive package (examples are provided for specific version 5.7). For details about MySQL ZIP archive not covered in this guide you can refer to the official documentation on dev.mysql.com Download and Install 2013 C++ RedistributableDownload and install the followings:
2013 C++ x86: Download MySQLDownload MySQL Community Server ZIP Archive for Windows (x86, 64bit). Go to MySQL download site. If you cannot see the version you wish to download click on "Looking for previous GA versions?". It is not necessary to sign up if offered, there is a "No thanks, just start my download." link for bypassing that.
Extract the archivesExtract the content of the .zip file into an arbitrary directory (in this example C:\MySQL5.7)
Move data locationIn enterprise environment it is common to store the data on different storage/partition than the executable program files. (This step is optional. The data folder can stay in its original place.) Copy the data folder (C:\MySQL\data\) to an arbitrary location. In this example it is the D drive (D:\data\). Create MySQL configuration fileCreate and edit my.ini configuration file in the base installation folder (C:\MySQL5.7). Save the file with the content like below, and adjust the directory paths accordingly (basedir, datadir): [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #-------------------------------------------------- basedir = "C:/MySQL5.7" datadir = "D:/data" port = 3306 max_allowed_packet=256M thread_stack=256K Secure the installationOpen up a command prompt window, go to the "bin" folder of the installation, and start MySQL server: C:\MySQL5.7\bin> mysqld --console Open up a different command prompt window and start the client connecting to server with superuser "root" account (do it also from "bin" folder): C:\MySQL5.7\bin>mysql -u root When connected to the server the prompt changes to mysql> Set the root password mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your_new_root_password'); Disconnect the client from the server with exit command: mysql> exit From now on the client needs to be started with a "-p" switch and password has to be provided to connect. C:\MySQL5.7\bin>mysql -u root -p Enter password: Stop the server running in console press: Ctrl-C Install Windows serviceInstall Windows service with specifying service name (MySQL5.7) and configuration file (my.ini) C:\MySQL5.7\bin>mysqld --install MySQL5.7 --defaults-file=C:\MySQL5.7\my.ini A new service should apper in Service Manager (configure it if necessary, e.g. startup type, or logon account). Start the new MySQL Windows service.
It might happen an error like below is displayed when trying to start the service.
If so, do the following:
To remove an already existing incorrectly defined service the "sc delete <service_name>" command can be used (be cautious running this command). E.g. C:>sc delete MySQL5.7 After the service successfully started for diagnostic purposes you can connect with client again, and run a few commands to verify the installation. E.g. mysql> show databases; Congratulations! MySQL server is installed and you can carry on with codeBeamer installation. Set up codeBeamer with MySQL databaseAt step #3 in codeBeamer setup wizard select MySQL for backend database and provide connection parameters. Before continuing to the next step test the connection.
Successful connection is confirmed with a message like the following, and the rest of the setup process can be completed.
|
Fast Links
codebeamer Overview codebeamer Knowledge Base Services by Intland Software |
This website stores cookies on your computer. These cookies are used to improve your browsing experience, constantly optimize the functionality and content of our website, furthermore helps us to understand your interests and provide more personalized services to you, both on this website and through other media. With your permission we and our partners may use precise geolocation data and identification through device scanning. You may click accept to consent to our and our partners’ processing as described above. Please be aware that some processing of your personal data may not require your consent, but you have a right to object to such processing. By using our website, you acknowledge this notice of our cookie practices. By accepting and continuing to browse this site, you agree to this use. For more information about the cookies we use, please visit our Privacy Policy.Your preferences will apply to this website only.