Install PhpMyAdmin, MySQL dan CodeIgniter di Fedora 17

Setelah beberapa hari Install Fedora 17 rasanya masih ada beberapa yang mesti ditambahkan, dan hasilnya saya akan share di sini. Pertama instalasi PhpMyAdmin, untuk instalasi PhpMyAdmin masuk ke mode root pada terminal dan ketik

[root@localhost ~]#yum -y install phpMyAdmin php-mysql php-mcrypt

Setelah itu Masuk ke

[root@localhost ~]#vi /etc/httpd/conf.d/phpMyAdmin.conf
Cari pada baris ke 23
Allow from 127.0.0.1

Setelah itu ketikkan http://127.0.0.1/phpmyadmin untuk masuk ke dalam phpmyadmin, jangan lupa pastikan Webserver anda sudah terinstall setelah PhpMyAdmin terinstall jangan lupa restart webserver anda

[root@localhost ~]# systemctl restart httpd.service

dan untuk mengakses phpmyadmin diperlukan username dan password MySql. Lalu tahap berikutnya Instalasi MySql

[root@localhost ~]# yum -y install mysql-server

Setelah proses instalasi jalankan MySql dengan menggunakan perintah

[root@localhost ~]# systemctl start mysqld.service
[root@localhost ~]# systemctl enable mysqld.service
ln -s ‘/usr/lib/systemd/system/mysqld.service’ ‘/etc/systemd/system/multi-user.target.wants/mysqld.service’

Masuk ke dalam MySql

[root@localhost ~]# mysql -u root

Cek User

mysql> select user,host,password from mysql.user;
+——+———————–+———-+
| user | host | password |
+——+———————–+———-+
| root | localhost | |
| root | localhost.localdomain | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | localhost.localdomain | |
+——+———————–+———-+
6 rows in set (0.00 sec)

Set password untuk masing-masing user

mysql> set password for root@localhost=password(‘password_anda’);
Query OK, 0 rows affected (0.00 sec)

mysql> set password for root@localhost.localdomain=password(‘password_anda’);
Query OK, 0 rows affected (0.00 sec)

mysql> set password for root@127.0.0.1=password(‘password_anda’);
Query OK, 0 rows affected (0.00 sec)

Hapus user Anonymous ::1

mysql> select user,host,password from mysql.user;
+——+———————–+——————————————-+
| user | host | password |
+——+———————–+——————————————-+
| root | localhost | *3D02DB0B3868870A598CE8360FEDB28C9C85A4D5 |
| root | localhost.localdomain | *3D02DB0B3868870A598CE8360FEDB28C9C85A4D5 |
| root | 127.0.0.1 | *3D02DB0B3868870A598CE8360FEDB28C9C85A4D5 |
| root | ::1 | |
| | localhost | |
| | localhost.localdomain | |
+——+———————–+——————————————-+
6 rows in set (0.00 sec)

mysql> delete from mysql.user where user=’root’ and host=’::1′;
Query OK, 1 row affected (0.00 sec)

Dan terakhir keluar dari MySql

mysql> exit
Bye

Test hasil konfigurasi MySql anda

[root@localhost ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.24 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> exit
Bye

Jika hasilnya seperti diatas maka MySql anda sudah berjalan dengan normal, selanjutnya Instalasi CodeIgniter, tahap awal unduh CodeIgniter setelah itu copykan ke direktori /var/www/html/

[root@localhost /]# cp /[Folder Download Anda]/CodeIgniter_2.1.0.zip /var/www/html/

Lalu Unzip

[root@localhost html]# unzip CodeIgniter_2.1.0.zip

lalu ganti nama folder CodeIgniter Anda

[root@localhost html]# mv -i /var/www/html/CodeIgniter_2.1.0 /var/www/html/CodeIgniter

Setelah selesai buka Browser anda dan ketikkan 127.0.0.1/CodeIgniter untuk mengakses CodeIgniter yang telah anda install

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s