Linux

How to import and export record from table to another MySQL without import ID

How to import and export record from table to another MySQL without import ID ? Come importare ed esportare record da una tabella mysql a un’altra senza importare l’ID? INSERT INTO databasename.TargetTable (column_list) SELECT column_list FROM databasename.SourceTable Example INSERT INTO newproject.content (desc,author,`fulltext`) SELECT desc,author,`fulltext` FROM oldproject.content Note If you have fulltext field in your column_list, …

How to import and export record from table to another MySQL without import IDLeggi altro »

How to activate Nessus on Backtrack 5 – Come attivare Nessus su Backtrack 5 ?

Solution: You have to register on http://www.nessus.org/register root@bt:~# /opt/nessus/bin/nessus-fetch –register code-that-you-receive-through-email Your activation code has been registered properly – thank you. Now fetching the newest plugin set from plugins.nessus.org… Your Nessus installation is now up-to-date. If auto_update is set to ‘yes’ in nessusd.conf, Nessus will update the plugins by itself. root@bt:~# nessus-update-plugins Fetching the newest …

How to activate Nessus on Backtrack 5 – Come attivare Nessus su Backtrack 5 ?Leggi altro »

Backtrack not possible to upgrade | dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1

Problem: When you try to install, upgrade o autoremove packages with apt-get you can encounter in the following error: Setting up se-toolkit (4.2.1-bt0) … svn: OPTIONS of ‘http://svn.trustedsec.com/social_engineering_toolkit’: Could not read status line: Connection reset by peer (http://svn.trustedsec.com) dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered …

Backtrack not possible to upgrade | dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1Leggi altro »

How to redirect non-www to www with .htaccess – Come redirigere non-www to www tramite .htaccess

Problem: How to redirect any requests from http://my-domain.com to http://www.my-domain.com. There are several benefits from doing that: Solution: Applied to: Linux apache. Log on your server and tries on website folder the .htaccess file and edit it: RewriteEngine On RewriteCond %{HTTP_HOST} !^www\. RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] Well done! Best Regards, ITquadro – specialized Blog ITquadro sistemisti specializzati …

How to redirect non-www to www with .htaccess – Come redirigere non-www to www tramite .htaccessLeggi altro »

Show user grant/permissions on MySQL – Visualizza i permessi di un utente mysql

First, log into the mysql shell as a privileged user: root@localhost:~# mysql -u root -p Now, execute the follow command to view permission of the USER on localhost: mysql> SHOW GRANTS FOR USER@”localhost”; Well done! Best Regards, ITquadro – specialized Blog ITquadro sistemisti specializzati su Bologna ed Emilia-Romagna esperti in installazione e configurazione di MySQL ed …

Show user grant/permissions on MySQL – Visualizza i permessi di un utente mysqlLeggi altro »

How to reset root password on debian (linux) – Come resettare la password di root su linux debian

Solution: Reboot machine. On Grub screen press “e” to edit boot. On “Loading linux kernel” add in the end init=/bin/bash or init=/bin/sh (see the screenshot) mount -n -o remount,rw / if it didn’t work, you can try: mount -n -o remount-rw / passwd (insert new password twice) reboot Best Regards, ITquadro – specialized Blog ITquadro consulenti informatici …

How to reset root password on debian (linux) – Come resettare la password di root su linux debianLeggi altro »

Create MySQL database via command line – Creazione database MySQL da riga di comando

First, log into the mysql shell as a privileged user: root@localhost:~# mysql -u root -p Now, create your database: mysql> CREATE DATABASE databasename; Now, add your user and his access: mysql> GRANT ALL PRIVILEGES ON databasename.* TO user@localhost IDENTIFIED BY ‘user_pass’; Well done! Best Regards, ITquadro – specialized Blog ITquadro sistemisti specializzati su Bologna ed …

Create MySQL database via command line – Creazione database MySQL da riga di comandoLeggi altro »