my.cnf speed up access

Thursday, 28. February 2008

shantanuo 18:30h

If you are using Linux on your servers and you ssh to the server and then run the mysql client to access the server you can use a .my.cnf file to speed up access.
[client]
user =username
password =x&r%@ldc
host = localhost

Now you can just type ‘mysql’ and it connects you up automatically.

... Comment

Online for 2763 days
Last modified: 2010.03.19, 12:58

Status

Youre not logged in ... Login

... Home

... Tags

... Galleries

Calendar

Recent updates

Upgrade PEAR I spent a lot of time figuring out how to upgrade my PEAR...

by shantanuo (2010.03.19, 12:58)

Improve the bash history If you use two bash sessions at the same time, which...

by shantanuo (2010.03.15, 12:13)

Counting file types cat myawk.sh #!/bin/sh # list the type of files with count find...

by shantanuo (2010.01.11, 18:43)

show processlist ps aux When you run ps you will only get the first 40...

by shantanuo (2009.12.29, 09:50)

Which Linux? If you're a Linux expert, Fedora is for you. If you just want...

by shantanuo (2009.12.23, 14:22)

Killing processes You can enter the "kill" command in a terminal if a process hangs....

by shantanuo (2009.12.23, 14:06)

vim syntax behave mswin - Copy and Paste with Ctrl+C CtrlV set laststatus=2 - grey...

by shantanuo (2009.12.18, 17:37)

sed can make you sad! Changing the -e to -i in the following can be...

by shantanuo (2009.12.18, 17:09)

Easy SSH HashKnownHosts no Add the above line in your ssh_config file that can be...

by shantanuo (2009.12.18, 14:43)

Inernal File Separator The safe way to change IFS in a 'while read' loop is:...

by shantanuo (2009.12.01, 17:07)

Overwriting files output redirection using n> usually overwrites existing files. You can control this with...

by shantanuo (2009.11.21, 17:15)

send messages across network The following command can be used to send messages to remote...

by shantanuo (2009.11.19, 18:34)

power of wget wget is really a very powerful utility. Here is an example. wget...

by shantanuo (2009.10.18, 09:46)

Silence of the Foxes This simple Firefox tool lets you create custom Firefox installers which...

by shantanuo (2009.09.13, 19:30)

Wow 15 years IT experience and you don't know the difference between a bit and...

by lolquestionmark (2009.09.01, 18:29)

Zoom in Ubuntu I can change the tabs in firefox by using Alt + 2...

by shantanuo (2009.08.23, 07:49)

Google Calculator >> 24685316 kb in MB shows the wrong results: 24 685 316 kilobits...

by shantanuo (2009.08.16, 13:04)

Old date in Shell If you need to know the 3 days old date, it...

by shantanuo (2009.08.11, 12:50)

Finding in Linux I was looking for the file translate.html from my backup drives, e:...

by shantanuo (2009.08.10, 12:56)

Number all lines in a file perl -pe '$_ = "$. $_"' “-p” causes Perl...

by shantanuo (2009.08.09, 12:16)

Ubuntu Root The root account is disabled by default on Ubuntu installations, mainly to prevent...

by shantanuo (2009.08.09, 11:35)

Starting Ubuntu You can make Ubuntu remember the applications you had open when you last...

by shantanuo (2009.08.09, 11:31)

Export to Excel Just create a regular .PHP file, where you output your data in...

by shantanuo (2009.08.07, 13:27)

Gmail in Firefox You can set Gmail as Default Email Client in Firefox * go...

by shantanuo (2009.07.07, 20:07)

tmpdir in MySQL In MySQL, the tmpdir path is mainly used for disk-based sorts (if...

by shantanuo (2009.06.20, 07:22)