Linux Server and Workstation Configuration How To

1. IPv6 Configuration on FreeBSD

... = passwd = There write your username and password are entered when registering on the site. At this initial setup is completed, for further customization read the documentation. server = broker.freenet6.net ...

2. IPv6 Configuration on Ubuntu Linux

... will get message with Username, Password and Gateway6 Address. Now lets start server configuration. By default, in ubuntu-server IPv6 support is already enabled. In other case you can enable by command: ...

3. passwd

Command passwd Changes the password. Syntax passwd [username] Options No Description The passwd command changes your password. It asks for old password, and then the new password. If you are ...

4. How to Export, Backup Or Dump A MySQL Database

To export a MySQL database into a dump file, simply type the following command syntax in the shell. mysqldump -u username –ppassword database_name > dump.sql Replace username, password, database_name ...

5. How to Export A MySQL Database Structure

If You need to export only the MySQL database's tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql ...

6. How to Backup Only Data of a MySQL Database

For exporting MySQL database's only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing. mysqldump -u username -ppassword ...

7. How to Export A MySQL Database Structures

If You need to export only the MySQL database's tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql ...

8. How to Dump Several MySQL Databases Into Text File

Use –databases option for exporting several databases. mysqldump -u username -ppassword –databases db_name1 [db_name2 ...] >dump.sql ...

9. How to Dump All Databases in MySQL Server

To damp all MySQL databases, use the –all-databases option. mysqldump -u username –p password –all-databases > dump.sql ...

10. How to Online Backup Innodb Tables

... is then immediately released. mysqldump -u username –p password –all-databases –single-transaction > dump.sql ...

11. How To Restore and Import MySQL Database

You should upload the dump file to the MySQL server, and type this command to import the databases into the MySQL server. mysql -u username –p password database_name < dump.sql ...

12. How To Securing SSH Connection

...  Access control tcpwrapper configuration - /etc/hosts.allow and /etc/hosts.deny Choose a strong password Install "DenyHosts" to auto-block bad clients - Installing the "denyhosts" server which ...

13. Apache Authentication

Creating Password Create htpasswd file for current (pwd) path # htpasswd -mc .htpasswd yourusername Insert new password Create .htaccess file for current path # touch .htaccess # mcedit .htaccess Paste ...

14. Linux, UNIX User Management Commands

...  Ex: adduser mark - Effect: Adds a user to the system named mark     chage Used to change the time the user's password will expire.     chfn Change ...

15. Default Port Numbers

... HMMP Indication / DQS # # UNIX specific services # exec 512/tcp biff 512/udp comsat login 513/tcp who 513/udp whod shell 514/tcp cmd # no passwords used syslog 514/udp printer 515/tcp spooler # ...

16. How to Export A MySQL Database Structures

mysqldump -u username -ppassword –no-data database_name > dump.sql You can provide this command as mysqldump -u -p –no-data > dump.sql Where password argument entering without space -p ...