Michael Mior · Jan 6, 2012

MySQL Client Configuration

0Sign in to vote or save

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

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 =…

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

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

Read on michael.mior.ca ↗

Comments

Nothing yet. Say the first thing.