Senin, 09 September 2013

Mengatur Ulang mysql dan phpmyadmin

Terkadang untuk penginsatalan web server di linux Blankon pengaturan mysql dan phpmyadminya tidak dilakukan secara otomatis setelah kita instal web server tersebut, nah untuk itu kita perlu mensetting sendiri username, password secara manual, untuk mengatur ulang pasword dan setingan mysql dan phpmyadmin maka ikutilah langkah2 berikut dengan benar secara berurutan

  1. Ctrl + Alt + T to launch terminal
  2. sudo dpkg-reconfigure phpmyadmin
  3. Connection method for MySQL database for phpmyadmin: unix socket
  4. Name of the database's administrative user: root
  5. Password of the database's administrative user: mysqlsamplepassword
  6. MySQL username for phpmyadmin: root
  7. MySQL database name for phpmyadmin: phpmyadmin
  8. Web server to reconfigure automatically: apache2
  9. ERROR 1045
  10. ignore
  11. sudo dpkg-reconfigure mysql-server-5.5
  12. New password for the MySQL "root" user: mysqlsamplepassword
  13. Repeat password for the MySQL "root" user: mysqlsamplepassword
  14. After all this run following command on terminal to secure your mysql server. sudo mysql_secure_installation
  15. Enter current password for root (enter for none): mysqlsamplepassword
  16. Change the root password? [Y/n] n
  17. Remove anonymous users? [Y/n] y
  18. Disallow root login remotely? [Y/n] y
  19. Remove test database and access to it? [Y/n] y
  20. Reload privilege tables now? [Y/n] y
 kemudian setelah selesai dan phpmyadmin belum bisa diakses maka ketikan perintah di bawah ini
"ln -sf /usr/share/phpmyadmin/ /var/www/phpmyadmin"

thanks

Selasa, 29 Januari 2013

Repo Lokal Fedora 17



Berikut saya ulas sedikit tentang cara pembuatan repo lokal fedora 17
sebelumnya download dulu reponya
gunakan perintah
#yum install httpd rysnc createrepo

#reposync --repoid=fedora --download_path=/run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/fedora
#reposync --repoid=rpmfusion-free --download_path=/run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/rpmfusion-free

#reposync --repoid=rpmfusion-nonfree --download_path=/run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/rpmfusion-nonfree
#rsync -avrt rsync://kambing.ui.ac.id/fedora/updates/17/i386/ /run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/updates/
Disini saya meletakkan file reponya di "/run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/"

baiklah langsung saja kita create reponya menggunakan perintah "createrepo"


[root@pure noer]# createrepo /run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/
Spawning worker 0 with 31106 pkgs
Workers Finished
Gathering worker results

Saving Primary metadata
Saving file lists metadata
Saving other metadata
Generating sqlite DBs
Sqlite DBs complete
[root@pure noer]#

prosesnya untuk createrepo memang agak lama, karena dia aka membuat repodata dari semua paketan yang telah di download / menggunakan CD?DVD tersebut

setelah selesai edit file #nano /etc/yum.repos.d/fedora.repo
sebelum itu terlebih dahulu backup file aslinya supaya jaga2 agar tidak repot dikemudian hari jika ingin menggunakan internet lagi

kemudian hapus semua isi file fedora.repo dan ganti dengan

[fedora]
name=Fedora $releasever - $basearch
baseurl=file:///run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/
#mirrorlist=https://mirrors.fedoraproject.org/metalink?repo=fedora-$releasever&arch=$basearch
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-fedora-$basearch

ganti
baseurl=file:///run/media/noer/Noer_Pramono/repo_fedora_core_17/fedora/i386/

dengan base url milik anda, dimana anda meletakkan file repo tersebut

kemudian # yum update
unutk mengecek apakah sudah berjalan dengan benar, jika tidak ada errror maka anda sudah berhasil membuat repo lokal fedora 17

Minggu, 27 Januari 2013

Install Web Server Di Fedora 17




Untuk instalasi apache, mysql dan php di Fedora 17 ada baiknya instalasi melalui paket rpm ataupun source code, agar lebih mudah untuk mengupgrade di kemudian hari.

Instalasi Apache Web Server

buka terminal, login sebagai root dan ketik perintah
yum install httpd
setelah proses instalasi selesai, jalankan Apache
service httpd start

Instalasi MySQL

yum install mysql mysql-server
jalankan mysql setelah selesai instalasi
service mysqld start

Instalasi PHP

yum install php php-mysql
disini kita menginstall php-mysql agar script PHP bisa berkomunikasi dengan MySQL. Setelah selesai restart apache dan mysql
service httpd restart; service mysqld restart

Seteah itu install phpmyadmin

yum install phpmyadmin
disini digunakan untuk mempermudah user interface ketika mengakses database

kemudian edit file config.inc.php
#nano /etc/phpMyAdmin/config.inc.php

rubah $cfg['Servers'][$i]['auth_type']     = 'htttp';
menjadi
$cfg['Servers'][$i]['auth_type']     = 'cookie';

kemudian rubah lagi
$cfg['Servers'][$i]['AllowNoPassword'] 
                                     = FALSE;
menjadi
$cfg['Servers'][$i]['AllowNoPassword']
                                     = true;

kemuadian ctrl+x, y, enter

masuk ke http://localhost/phpmyadmin
masukkan username "root" dan password di kosongkan saja
kemudian setelah masuk phpmyadmin klik change password 
kemudian ganti dengan password yang diinginkan
kemudian coba masuk lagi dengan username "root" dan pssword "password baru yang anda masukkan"

Setelah semua proses instalasi berhasil, buat sebuah file info.php di /var/www/html/ untuk memastikan PHP dan MySQL sudah bisa berkomunikasi.
nano /var/www/html/info.php
isi dengan
<?php
phpinfo();
?>

setelah itu, buka browser anda di alamat http://localhost/info.php


sumber : http://blog.karo.or.id/instalasi-apache-mysql-dan-php-di-fedora-16/

Mengganti Password Xampp linux


xampp defaultnya memang tidak menggunakan password tapi jika anda ingin menggunakan password maka lagkahnya sebagai berikut
edit file config.inc.php 
#nano /opt/lampp/phpmyadmin config.inc.php

kemudian cari text berikut 
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;


gantiu dengan 
/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

kemudian save ctrl+x, y , enter

kemudian ganti securitynya 

#/opt/lampp/lampp security

kemudian ketikan "yes"
dan masukkan password anda untuk diberikan ke
- xampp page
- mysql
-  ftp

setelah itu masuk pertama kali gunakan username "lampp" dan password "password yang anda berikan"
baru kemudian  setelah masuk ke halaman awal xampp gunakan username "root" dan password "root"

Menggunakan Perintah rm (remove) di fedora





Step by step example to delete or remove hidden files, folder or directory on Linux Fedora system using rm command.

Using Linux rm command on the bash shell command prompt to delete or remove file, hidden file, folder, hidden folder and meta character filename and folder name on Linux fedora core with example. This article show the step by step guide on delete file or delete folder on Linux system, make sure that the that you understand the rm command before you execute them.

Linux command name: rm

Command description:
The Linux 'rm' command is used to remove or to delete file and directory.
Command type:
'file' disk file (external command) and alias to rm='rm -i'.



[root@fedora ~]# type -t rm
alias

[root@fedora ~]# alias
alias cp='cp -i'
alias l.='ls -d .* --color=tty'
alias ll='ls -l --color=tty'
alias ls='ls --color=tty'
alias mc='. /usr/share/mc/bin/mc-wrapper.sh'
alias mv='mv -i'
alias rm='rm -i'
alias which='alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde'

[root@fedora ~]# which rm
alias rm='rm -i'
/bin/rm

[root@fedora ~]# type -t /bin/rm
file

How to remove or delete a file?

Remove file from or delete file from Fedora system.

[root@fedora /]# rm install.log
rm: remove regular file `install.log'? y

The command above remove/delete the file called "install.log". Use ls command to confirm the removal/deletion.

How to remove or delete several file?

Remove more that one file in one time.

[root@fedora /]# rm install.log kambing.log secure1.log config.doc passwd
rm: remove regular empty file `install.log'? y
rm: remove regular empty file `kambing.log'? y
rm: remove regular empty file `secure1.log'? y
rm: remove regular empty file `config.doc'? y
rm: remove regular empty file `passwd'? y

rm command also can be used to remove or delete the several file at once, in this example five files ( install.log, kambing.log, secure1.log, config.doc, passwd ) is deleted at one go.

How to remove or delete files that use metacharacter (character that mean something to the shell) as file name?

If you have file or folder name that use metacharacter or characters that mean something to shell, you have to tell the shell prompt so that the shell could interpreted that you want to remove files. Below is some example to remove the metacharacter files:

[root@fedora /]# rm -r ./*important-file*
rm: remove directory `./*important-file*'? y

[root@fedora /]# rm -- -not-important*
rm: remove regular file `-not-important*'? y
[root@fedora /]# rm 'happy rock hacking.mp3'
rm: remove regular file `happy rock hacking.mp3'? y

To remove/delete the file that contains a space or character which is used by the shell, in this example;
*important-file* The filename contain ( * )
-not-important* The filename contain ( - ) in the beginning and ( * )
happy rock hacking.mp3 The file name use space

Put a single quotes around them or force it using the current directory sign ( ./ ) or used rm -- option.

How to remove or delete all files in current directory?

The example below show the rm command use to delete all file in the current directory.

[root@linux hack]# rm ./*
rm: remove regular file `./install.log.syslog'? y
rm: remove regular file `./#interface#'? y
rm: remove regular file `./izes in human readable format (e.g., 1K 234M 2G)'? y
+
+

The rm command above will remove or delete all file except the hidden files in that current directory.

How to remove or delete a directory?

To remove the directory just issue the rm command with the directory name, if the directory is not empty you may get the same massage bellow:

[root@fedora /]# rm fedora/
rm: cannot remove directory `fedora/': Is a directory

If you know that the directory that you want delete (remove) is not empty and you are sure that you want to remove the directory and all of its contents; issue the rm command with the -r option:

[root@fedora /]# rm -r fedora/
rm: descend into directory `fedora/'? y
rm: remove regular empty file `fedora//passwd.kambing'? y
rm: remove regular empty file `fedora//.exploits'? y
rm: remove regular empty file `fedora//.labu'? y
rm: remove regular empty file `fedora//passwd.log'? y
rm: remove regular empty file `fedora//kambing.log'? y
rm: remove regular empty file `fedora//secure1.log'? y
rm: remove regular empty file `fedora//.SELinux'? y
rm: remove regular empty file `fedora//install.log'? y
rm: remove regular empty file `fedora//config.doc'? y
rm: remove directory `fedora/'? y

The rm command above with –r (recursive) option is to remove or delete the fedora directory and all files and directory that contain in the directory that you want to remove.

How to remove or delete everything in current directory without warning?

Remove all files without any warning from the system ( no message output to the screen).

[root@fedora ~]# rm –rf *

or

[root@fedora ~]# rm –rf ./*

The rm command above with –rf (recursively and remove or delete write-protected file without prompting) option will remove or delete everything in the current directory without any warning.

WARNING : “rm –rf *’ command will remove or / delete everything in current directory except hidden file or directory in that current directory. Make sure that you not in the root directory ( / ) before you issue the command or you could end up with empty and broken Linux box. Be careful, rm command can be a dangerous tool if misused.

How to remove or delete all hidden file or directory without warning?

Remove all file and directory without any output to the screen,

[root@fedora /]# rm –rf .??*

With the option –rf and the use " .??* " will remove/delete all hidden files/directory. The initial " . " indicates a 'hidden' file and the " ?? " match at least two characters to exclude the parent-directory which is " .. " and to remove or delete everything the " * " will match all number or characters that used for files or directory name.

How to remove or delete file base on (use) its inode / index number?

The example below show the step to delete or remove the file base on the inode number.

Issue the ls command with the -i option to get the inode number for the file.

[root@fedora /]# ls -i
245242 sysdetails.txt
245243 tat - display file or filesystem status
976527 test
245273 testscript.sh
245274 timate file space usage
245275 uptime.txt
245276 ystem disk space usage

Using the find command to find inode number for the file and then pass to the rm command to delete the file base on their inode number.

[root@fedora /]# find . -inum 245243 -exec rm –i {} \;
rm: remove regular file `./tat - display file or filesystem status'? y

Verify to make sure that the file have been remove by using ls command.

[root@fedora /]# ls
sysdetails.txt
test
testscript.sh
timate file space usage
uptime.txt
ystem disk space usage

From the example above, the ‘ls –i’ command is used to get the inode number of file or directory then the find command used to search for inode number "245243" then give the inode number to rm command to remove or delete the file base on the inode number given..

The following are some of the flags and arguments that can be used with the rm command:
Remove (unlink) the FILE(s).

-d, --directory unlink FILE, even if it is a non-empty directory
(super-user only; this works only if your system
supports `unlink' for nonempty directories)
-f, --force ignore nonexistent files, never prompt
-i, --interactive prompt before any removal
--no-preserve-root do not treat `/' specially (the default)
--preserve-root fail to operate recursively on `/'
-r, -R, --recursive remove the contents of directories recursively
-v, --verbose explain what is being done
--help display this help and exit
--version output version information and exit

Note: if you use rm to remove a file, it is possible to recover the contents of that file. If you want more assurance that the contents are truly unrecoverable, consider using shred.
Note:- On Fedora Core using bash shell, the rm command is alias to rm='rm -i'. The rm is the command to remove files or folder in Linux system but there is no unrm or undelete or unremove command on Linux operating system. So be very careful on what you wish to remove :-)

Warning: The rm command can do many harm thing to your system, make sure that you double check before executing the rm command.
NAME
stat - display file or filesystem status
Usage: rm [OPTION]... FILE...

Need help or need more information use:
# info rm
# man rm
# rm --help

Step-by-step how to procedure above tested on:
Operating System: GNU/Linux Fedora Core 4
Kernel Name: Linux
Kernel Release: 2.6.11-1.1369_FC4
Kernel Version: #1 Thu Jun 2 22:55:56 EDT 2005
Machine Hardware: i686
Machine Processor: i686
Hardware Platform: i386
Shell: GNU bash, version 3.00.16(1)-release (i386-redhat-linux-gnu)
Installation Type: Full Installation (Custom)
SELinux: Disable

Keywords: remove file, remove hidden file, using Linux rm command, rm command, command prompt to delete, remove linux file, delete file, delete hidden file, delete linux folder, delete linux file, remove hidden folder, remove metacharacter filename, remove file using inode number, remove linux, remove directory, remove hidden directory, fedora core, step to remove file.


sumber : http://www.labtestproject.com/linuxcmd/rm.html
 

Linux Copyright © 2011 -- Template created by Predator -- Powered by Aliens