MySQL Client Configuration
Michael Mior

Michael Mior @michaelmior

About: Assistant Professor and Director of the Data Unity Lab at the Rochester Institute of Technology

Location:
Rochester, NY
Joined:
Oct 2, 2017

MySQL Client Configuration

Publish Date: Oct 31 '17
11 0

Perhaps I’m the only one who didn’t know this, but a while back, I discovered a handy trick for configuring the MySQL client. You can create a configuration file in your home directory, ~/.my.cnf and set options for the MySQL client to use. Really handy if you’re constantly connecting to the same server and tired of entering hostname and port parameters.

Here’s an example:

[client]
host = 127.0.0.1
user = root
password = root
port = 4040
Enter fullscreen mode Exit fullscreen mode

That’s it for this post. If you know any other time-saving tips for MySQL, please share in the comments!

Comments 0 total

    Add comment