mysql change data directory mac for new install

Mysql Change Data Directory For New Install To The
Mysql Change Data Directory For New Password Is The

Never mess with internal structure of the database, if you do, you will face problems in future.

How do you find this method compared to other methods We would like to hear from you via the comment form below to reach us.

If you have any questions or doubts do ask for help in the comments section.

Millions of people visit TecMint to search or browse the thousands of published articles available FREELY to all.

Mysql Change Data Directory For New Install To The

I tried it to move the tables from my old install to the new one and all it did was mangle it to the point it wouldnt work because of structure changes, table changes, storage methods, and so on.

Doing user tables is fine, but taking all the admin tables over too just isnt going to work.

Have a question or suggestion Please leave a comment to start the discussion.

Watch Make Medium yours Follow all the topics you care about, and well deliver the best stories for you to your homepage and inbox.

You can learn how to do this by first visiting my other article, How to Run MySQL in a Docker Container on macOS with Persistent Local Data.

However, the tips you learn here will help you if youre running MySQL locally on your Mac.

SECOND NOTE Update Dec 14, 2019: I updated the linked article above to make permissions handling much easier.

Recently, I wanted to up my database game by moving my projects to the latest version of MySQL 8.0.

Mysql Change Data Directory For New Password Is The

I ran into a snag however, because in MySQL 8.0 cachingsha2password is the default authentication plugin rather than mysqlnativepassword, which is the default method in MySQL 5.7 and prior.

The moment I tried to use MySQL Workbench or DBeaver to connect, it would throw an error Unable to load plugin cachingsha2password.

As it turns out, there are a number of ways to solve this problem.

You can modify your applications to just use the newer (and better performing) cachingsha2password method and then use the compatible version of MySQL Workbench found here.

However just switching everything up may not be an easy (or convenient) thing to do in your development environment, particularly if some of your projects continue to rely on MySQL 5.7 or earlier.

Next, you can CREATE or ALTER your database user to use mysqlnativepassword with the command shown below, however this method only affects a particular user, and if you dont also ALTER your root user, then in your development environment youll almost certainly run into the plugin error above when trying to work with your dev tools and itll become irritating.

CREATE USER nativeuserlocalhostIDENTIFIED WITH mysqlnativepassword BY password; Next, if you run MySQL locally you can modify your my.cnf file by adding the line shown below and restarting your MySQL service.

This will validate all database users (including root) using mysqlnativepassword authentication.

However you would have to do this task every time you recreated the container.

Instead, you can include the necessary config parameters in your initial docker run command so that every time you start a MySQL 8.0 container, it builds and fires up with mysqlnativepassword authentication in place.

Heres the steps you need to accomplish that: Create a Local MySQL Config File Create a local folder that can contain a simple config file that well include in our docker run command.

I will use the UsersyourusernameDevelop folder I created in my other article linked above.

Now were going to create a local my.cnf file that contains the settings we want to use to modify the config inside the MySQL container during docker run time.

Control x to exit.

Create a MySQL 8.0 Docker Container Using New Config If youre replacing an existing MySQL 8.0 Docker container with this new one, youll want to stop and remove it before running the following command.

In the following command remember to substitute in your Mac user name for yourusername and your favorite MySQL root password for yourpassword.

NOTE The following is a single command that has wrapped to multiple lines due to its length.

Now the MySQL 8.0 instance will not only operate as your localhost, but will also use the native password authentication scheme youre used to.

And any time you stop and remove your containers, as long as that additional parameter is included in the run, your containers will always start that way.

Theres more Interested in MySQL tips Check out my story here on creating a query in MySQL 5.7 and 8.0 that returns the top records across a range or category.

Check out my other stories to find more helpful guides for setting up a development environment on your Mac 75 1 Docker MySQL Macos 75 claps 75 claps 1 response Written by Casey McMullen Follow Startup Entrepreneur.

Follow Written by Casey McMullen Follow Startup Entrepreneur.

More From Medium What Are APIs Kevin McLaughlin Use AppleScript to generate an enum for SF Symbols Ioannis Diamantidis Wildfly in a Cluster with Docker Auryn Engel I Failed My Coding Interview Shane Shown in Better Programming Hiccup Lightning Tutorial Iwo Herka in Makimo Tech Blog Multithreaded Python: Slithering Through an IO Bottleneck Victoria Drake in Better Programming Deploy RShiny with Kubernetes using AWS EKS and Terraform Jillian Rowe in The Startup The Dirtiest Word in Software Chris Cooney in Better Programming Discover Medium Welcome to a place where words matter.

On Medium, smart voices and original ideas take center stage - with no ads in sight.

Mysql Change Data Directory Mac For New Install