Skip to main content

Posts

Showing posts from July, 2016

Latest Post

Fix Arch [Manjaro] GRUB Bootloader

 Boot to any [Manjaro] live GUI disk. Use manjaro-chroot 1. Start by identifying the partition where your Manjaro installation controlling the active Grub menu resides and needs repairing. If you are in Graphical mode you can use an application called GPartEd , which should be in Menu > System > GPartEd. This will provide a simple visual illustration of the partitions on your hard drive(s). To do the same thing from terminal or TTY you can use this command lsblk -f 2. manjaro-chroot is a tool to easily setup a functional chroot into an installed Linux installation from a live boot of a Manjaro Installation Media. To setup the chroot use the command sudo manjaro-chroot -a You will be presented with a terminal. Wait until it shows a list with the available system partitions on your computer and choose the one you want to repair.    1.) First of all check the partition for the ESP (EFI System Partition). An ESP is a fat32 partition and contains .efi ...
Post a Comment
Read more

MySql;

Update root password; UPDATE user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES Create new user; CREATE USER 'test'@'localhost' IDENTIFIED BY 'password'; Grand all permission to new user; GRANT ALL PRIVILEGES ON * . * TO 'test'@'localhost'; Create new database; CREATE DATABASE dbname; Import database; mysql -u mysqluser -p < file.sql Import tables to database; mysql -u mysqluser -p databasename < file.sql   Export Database to sql file; mysqldump -h host_name -P port_number -u user_name -p database_name > name_of_backup.sql Export Table to sql file; mysqldump -p --user=username dbname tableName > tableName.sql Drop all tables from a database; mysql -u uname dbname -e "show tables" | grep -v Tables_in | grep -v "+" | gawk '{print "drop table " $1 ";"}' | mysql -u uname dbname error solution "error Packets larger than...
Post a Comment
Read more

Import CSV to mysql server!

First Create the table in mysql then. from mysql command line. LOAD DATA LOCAL INFILE 'abc.csv' INTO TABLE abc FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES ( col1 , col2 , col3 , col4 , col5 ...);   or    LOAD DATA LOCAL INFILE 'abc.csv' INTO TABLE abc FIELDS TERMINATED BY ',' IGNORE 1 LINES );
Post a Comment
Read more

Computer Read English Words With Notepad

Hi, Friends, You have any problem to read English words fluently. But your computer speak English very easily. This is a notepad trick ,So you no need to download other software’s. Our computer is a perfect engine. Computer can do anything, but it works with some commands. This command turns computer to a Robot. This trick is a command to read English words. This is not a virus. Trust me. If you want to learn more. Follow this post.. Note Pad Help To Speek English Computer Tricks (www.masterhacksindia.blogspot.com) First Open Notepad. Copy and Paste below code into Notepad. Dim speaks, speech speaks=" YOUR – ENGLISH – PARAGRAPH - HERE " Set speech=CreateObject("sapi.spvoice") speech.Speak speaks Change RED color with your English paragraph. Save it with .vbs extension (Example: Yourname.vbs). Close Notepad and Run saved file.
Post a Comment
Read more

Execute python Scripts in apache

Install libapache2 module with apt sudo apt-get install libapache2-mod-python then in configuration file of apache add these lines. <Directory /var/www/>     AddHandler mod_python .py     PythonHandler mod_python.publisher </Directory> If it works Great!. if not rename PythonHandler mod_python.publisher to PythonHandler mod_python.cgihandler Then you can run Python as CGI.
Post a Comment
Read more