Apr 23
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we’ll need the current
password for the root user. If you’ve just installed MySQL, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none): <– ENTER
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] <– ENTER
New password: <– yourrootsqlpassword
Re-enter new password: <– yourrootsqlpassword
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] <– ENTER
… Success!
Normally, root should only be allowed to connect from ’localhost’. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] <– ENTER
… Success!
By default, MySQL comes with a database named ’test’ that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] <– ENTER
- Dropping test database…
… Success!
- Removing privileges on test database…
… Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] <– ENTER
… Success!
Cleaning up…
All done! If you’ve completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Apache default document root pada Fedora adalah /var/www/html dan konfigurasi file pada /etc/httpd/conf/httpd.conf. Konfigurasi tambahan ada pada direktori /etc/httpd/conf.d/ directory.
- buat file info.php pada /var/www/html
-buka pada browser :
http://localhost/info.php
yum -y install phpMyAdmin php-mysql php-mcrypt
2. Lihat konfigurasi-ny :
vi /etc/httpd/conf.d/phpMyAdmin.conf
Lihat d’bagian ini :
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
3. Trz buka d’browser http://localhost/phpmyadmin
username : root
password : password mysql
Install MySQL 5
1. Install MySQL$ yum install mysql mysql-server2. Trz bwt system startup links untuk MySQL dan start MySQL :
$ chkconfig --levels 235 mysqld on $ /etc/init.d/mysqld start3. Trz run :
$ mysql_secure_installationto set a password for the user root (otherwise anybody can access your MySQL database!):[root@server1 ~]# mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we’ll need the current
password for the root user. If you’ve just installed MySQL, and
you haven’t set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none): <– ENTER
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] <– ENTER
New password: <– yourrootsqlpassword
Re-enter new password: <– yourrootsqlpassword
Password updated successfully!
Reloading privilege tables..
… Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] <– ENTER
… Success!
Normally, root should only be allowed to connect from ’localhost’. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] <– ENTER
… Success!
By default, MySQL comes with a database named ’test’ that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] <– ENTER
- Dropping test database…
… Success!
- Removing privileges on test database…
… Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] <– ENTER
… Success!
Cleaning up…
All done! If you’ve completed all of the above steps, your MySQL
installation should now be secure.
Thanks for using MySQL!
Install Apache2
1. Apache2sudah ada dalam paket Fedora, kita cuma harus install seperti ini :$ yum install httpd2. Konfigurasi system agar start Apache saat boot time :
$ chkconfig --levels 235 httpd on.3. Start Apache :
$ /etc/init.d/httpd startBuka d’browser http://localhost/ :
Apache default document root pada Fedora adalah /var/www/html dan konfigurasi file pada /etc/httpd/conf/httpd.conf. Konfigurasi tambahan ada pada direktori /etc/httpd/conf.d/ directory.
Install PHP5
1. Install PHP5, dependenciesnya dan Apache PHP5 module :$ yum install php mysql-php2. Trz restart Apache :
$ /etc/init.d/httpd restart3. Tes working atau gk-ny :
- buat file info.php pada /var/www/html
$ vi /var/www/html/info.php- isi dengan :
-buka pada browser :
http://localhost/info.php
Install phpMyAdmin
1. Install phpMyAdmin :yum -y install phpMyAdmin php-mysql php-mcrypt
2. Lihat konfigurasi-ny :
vi /etc/httpd/conf.d/phpMyAdmin.conf
Lihat d’bagian ini :
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
3. Trz buka d’browser http://localhost/phpmyadmin
username : root
password : password mysql
No comments:
Post a Comment
Terima kasih atas komentarnya