Default mysql data directory windows

You might need to copy the data also from old data directory to the new one. Improve this answer. Jotronics Computers Jotronics Computers 21 2 2 bronze badges. Ahmad Abuhasna Ahmad Abuhasna 2, 3 3 gold badges 19 19 silver badges 36 36 bronze badges.

Thanks,what baffles me is that after specifying the file path in my. This behavior I notice in Ver 8, while it was working fine while using Ver 5. Anything else I need to check? The changes done to registry as per the solution provided Step-3 in Link 2 cited in my query above. When I open Services. But if the 'datadir' points to the default drive, then the server starts immediately. PullupSkrr PullupSkrr 1.

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog. This enables the new service to be installed correctly, but leaves the outdated service in place. Although this is harmless, it is best to remove old services that are no longer in use.

To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command line:. General Installation Guidance. Verifying the MD5 Checksum. Signature Checking Using Gpg4win for Windows. Compiler-Specific Build Characteristics. Choosing an Installation Package. Extracting the Install Archive. Creating an Option File. Initializing the Data Directory.

Starting the Server for the First Time. Windows Postinstallation Procedures. Windows Platform Restrictions. Source Installation Methods. Source Installation Prerequisites. For some suggested commands that enable testing whether the server is accessible and working properly, see Section 2. In MySQL 8. Data Directory Initialization Overview. Data Directory Initialization Procedure. Post-Initialization root Password Assignment. In the examples shown here, the server is intended to run under the user ID of the mysql login account.

Either create the account if it does not exist see Create a mysql User and Group , or substitute the name of a different existing login account that you plan to use for running the server.

Within this directory you can find several files and subdirectories, including the bin subdirectory that contains the server, as well as client and utility programs.

Create a directory whose location can be specified as the value of that variable:. Grant directory user and group ownership to the mysql user and mysql group, and set the directory permissions appropriately:. Use the server to initialize the data directory, including the mysql schema containing the initial MySQL grant tables that determine how users are permitted to connect to the server. For example:. For important information about the command, especially regarding command options you might use, see Data Directory Initialization Procedure.

Typically, data directory initialization need be done only after you first install MySQL. For upgrades to an existing installation, perform the upgrade procedure instead; see Section 2. However, the command that initializes the data directory does not overwrite any existing mysql schema tables, so it is safe to run in any circumstances. For more information, see Section 4. In the absence of any option files, the server starts with its default settings.

See Section 5. See Section 4. Data directory initialization creates time zone tables in the mysql schema but does not populate them. To do so, use the instructions in Section 5. To initialize the data directory, invoke mysqld with the --initialize or --initialize-insecure option, depending on whether you want the server to generate a random initial password for the 'root' 'localhost' account, or to create that account with no password:.

In this case, the password is marked as expired and you must choose a new one. With --initialize-insecure , no root password is generated.

This is insecure; it is assumed that you intend to assign a password to the account in a timely fashion before putting the server into production use.

For instructions on assigning a new 'root' 'localhost' password, see Post-Initialization root Password Assignment. The server writes any messages including any initial password to its standard error output. This may be redirected to the error log, so look there if you do not see the messages on your screen. For information about the error log, including where it is located, see Section 5. On Windows, use the --console option to direct messages to the console. On Unix and Unix-like systems, it is important for the database directories and files to be owned by the mysql login account so that the server has read and write access to them when you run it later.

To ensure this, start mysqld from the system root account and include the --user option as shown here:. Alternatively, execute mysqld while logged in as mysql , in which case you can omit the --user option from the command.