Posts

Showing posts from July, 2011

Viewing open ports

netstat -tunva

Some Linux commands I found useful

To find out the version of the system: -------------------------------------------------- uname -r -m To backup and restore a database ----------------------------------------------------- mysql -u root -p libdata </home/pradeep/Desktop/libuser.sql To create a database ---------------------------------------------------- mysqladmin -u root  -p create libdata To drop a database -------------------------------------------------- mysqladmin -u root  -p drop libdata Current folder path --------------------------------------------------- pwd Set up a virtual node ---------------------------------------------------- Copy the default website as a starting point. sudo cp /etc/apache2/sites-available/default /etc/apache2/sites-available/mysite  Edit the new configuration file in a text editor "sudo nano" on the command line or "gksudo gedit", for example: gksudo gedit /etc/apache2/sites-available/mysite Change the Docu...

How Do I Enable Remote Access To MySQL Database Server?

B y default remote access to MySQL database server is disabled for security reasons. However, some time you need to provide remote access to database server from home or a web server. If you want to remotely access to the database server from the web server or home, follow this quick tutorial........ http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html