Saturday, April 26, 2014

mysql

  •  mysql  command example
mysql is probably the most widely used open source database on Linux. Even if you don’t run a mysql database on your server, you might end-up using the mysql command ( client ) to connect to a mysql database running on the remote server.
To connect to a remote mysql database. This will prompt for a password.
$ mysql -u root -p -h 192.168.1.2
To connect to a local mysql database.
$ mysql -u root -p
If you want to specify the mysql root password in the command line itself, enter it immediately after -p (without any space).
 
 
 

Related Posts:

  • hostname   hostname Print or set system name SYNTAX $ hostname With no arguments, `hostname' prints the name of the current host system. With one argument, it sets the current host name to the specified str… Read More
  • xargs   xargs command examples Copy all images to external hard-drive # ls *.jpg | xargs -n1 -i cp {} /external-hard-drive/directory Search all jpg images in the system and archive it. # find / -name *.jpg -type… Read More
  • history   history command example Linux bash history keeps every command a user typed in the command line terminal into a file named .bash_history. Here is an example of Linux history command with no option running i… Read More
  • yum yum command examples To install apache using yum. $ yum install httpd To upgrade apache using yum. $ yum update httpd To uninstall/remove apache using yum. $ yum remove httpd … Read More
  • jobs   jobs command example Print currently running jobs and their status. Syntax jobs [OPTIONS] [PID] Options: -c --command Print the command name for each process in jobs -g --group Only… Read More

0 comments:

Post a Comment