mysql command

How do I connect to my MySQL database server from an other server (say Apache or Tomcat app server) in same VLAN under CentOS / Fedora / RHEL / Redhat Linux?

{ 0 comments }

How do I install Oracle (Sun) MySQL database server v5.x under Ubuntu Linux operating systems? How do I add a new user and database for Apache web server and php access under Ubuntu Linux?

{ 0 comments }

Cacti is a network graphing tool similar to MRTG. How do I install and configure common options to collect SNMP data and various other data (such as system load, network link status, hard disk space, logged in users etc) into an RRD?

{ 63 comments }

How do I specify MySQL SQL queries on the UNIX / Linux command line?

{ 10 comments }

Restore a backup of a MySQL Database Server

by Vivek Gite on November 10, 2007 · 2 comments

Q. How can I restore a backup of a MySQL database server made with mysqldump program discussed here? A. You can use standard mysql – the MySQL command-line tool to restore a backup of a MySQL database server. Read back dump file You can read the dump file back into the server like this: mysql [...]

{ 2 comments }

MySQL Change User Password

by Vivek Gite on July 13, 2007 · 8 comments

How do I change user password under MySQL server? I’d like to change a password for user called tom using UNIX / Linux command line option.

{ 8 comments }

Q. I am new to MySQL database server. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same?

{ 21 comments }