0ct0pu5
/
tutorials


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
							    <!DOCTYPE html>
    <html lang="en" xmlns="http://www.w3.org/1999/xhtml">
      <head>
        <title>Portable MySQL USB Flash Install Guide</title>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <meta charset="UTF-8">
        <meta name="keywords" content="MySQL,Database,Relational Database,Community Edition,USB,Flash Drive,Portable,Portable Software,How To,Tutorial,i12bretro">
        <meta name="author" content="i12bretro">
        <meta name="description" content="Portable MySQL USB Flash Install Guide">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="revised" content="03/20/2022 12:21:09 PM" />
				          <link rel="icon" type="image/x-icon" href="includes/favicon.ico">
				  <script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
				        <script type="text/javascript" src="includes/js/steps.js"></script>
        <link href="css/steps.css" rel="stylesheet" type="text/css" />
      </head>
      <body>
        <div id="gridContainer">
          <div class="topMargin"></div>
          <div id="listName" class="topMargin">
            <h1>Portable MySQL USB Flash Install Guide</h1>
          </div>
          <div></div>
          <div id="content">
          <h2>Things You Will Need</h2>

<ul>
	<li>A USB flash drive, at least 8 GB <a href="https://amzn.to/3wkR5ju" target="_blank">https://amzn.to/3wkR5ju</a> | <a href="https://amzn.to/3qkrJ1p" target="_blank">https://amzn.to/3qkrJ1p</a> | <a href="https://amzn.to/3Nhu9b9" target="_blank">https://amzn.to/3Nhu9b9</a></li>
</ul>

<ol>
	<li>Download MySQL Workbench <a href="https://dev.mysql.com/downloads/workbench/" target="_blank">Download</a></li>
	<li>Download the latest MySQL binary .zip <a href="https://dev.mysql.com/downloads/mysql/" target="_blank">Download</a></li>
	<li>Extract the downloaded .zip file</li>
	<li>Rename the extracted folder MySQL</li>
	<li>Cut the MySQL folder to the USB flash drive</li>
	<li>Navigate back to the folder with the MySQL Workbench .msi</li>
	<li>While holding Shift, right click in the whitespace &gt; Open PowerShell window here</li>
	<li>Run the following command in PowerShell to extract the .msi to the USB flash drive, update the drive letter as needed
	<div class="codeBlock PS">msiexec /a mysql-workbench-community-8.0.25-winx64.msi /qb TARGETDIR=H:\<br />
	exit</div>
	</li>
	<li>Navigate to the USB flash drive and create a new text file called MySQL.bat</li>
	<li>Paste the following contents into the .bat file
	<p>&quot;%~dp0MySQL\bin\mysqld.exe&quot; --standalone</p>
	</li>
	<li>Save MySQL.bat</li>
	<li>Navigate into \MySQL\bin on the USB flash drive</li>
	<li>While holding Shift, right click in the whitespace &gt; Open PowerShell window here</li>
	<li>Run the following command to initialize the MySQL server
	<div class="codeBlock PS">.\mysqld --initialize<br />
	exit</div>
	</li>
	<li>Find the .err file in the \MySQL\data directory and open it in a text editor</li>
	<li>Search for the phrase temporary password &gt; Copy the randomly generated password for the root account to the clipboard</li>
	<li>Right click MySQL.bat on the root of the USB flash drive &gt; Run as Administrator</li>
	<li>The MySQL server process is now running</li>
	<li>Navigate into \MySQL\MySQL Workbench 8.0 CE\ on the USB flash drive and launch MySQLWorkbench.exe</li>
	<li>Click the Plus icon next to MySQL Connections</li>
	<li>Enter a connection name (ie Portable MySQL) &gt; Click OK</li>
	<li>Double click the new connection</li>
	<li>Paste the password found in the .err file</li>
	<li>Enter and confirm a new root password</li>
	<li>The connection should be successful, click OK</li>
	<li>Welcome to a portable MySQL database instance with GUI</li>
</ol>

<p><em>To stop the MySQL instance, simply kill mysqld.exe by pressing CTRL+C in the open command prompt running MySQL.bat</em></p>

<p><em>Additional server options for MySQL.bat <a href="https://dev.mysql.com/doc/refman/8.0/en/server-options.html" target="_blank">https://dev.mysql.com/doc/refman/8.0/en/server-options.html</a></em></p>
          </div>
        </div>
      </body>
    </html>