[dag]
name=DAG RPM Repository
baseurl=http://apt.sw.be/redhat/el$releasever/en/$basearch/dag
gpgcheck=1
enabled=1
rpm --import http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt
Step # 1 : Stop mysql service
# /etc/init.d/mysqld stop
Output:
Stopping MySQL database server: mysqld.
Step # 2: Start to MySQL server w/o password:
# mysqld_safe --skip-grant-tables &
Output:
[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started
Step # 3: Connect to mysql server using mysql client:
# mysql -u root
Output:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Step # 4: Setup new MySQL root user password
secara default, setelah instalasi, phpmyadmin hanya bisa diakses melalui localhost, sehingga tidak bisa diakses dari jaringan lain. Untuk itu kita harus mengatur konfigurasi akses agar phpmyadmin bisa dibuka dari mana saja.
lokali file konfigurasi : /etc/httpd/conf.d/phpMyAdmin.conf
edit file konfigurasi :
- - - - - start edit - - - - - -
Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin
<Directory /usr/share/phpMyAdmin/>
order deny,allow
deny from all
allow from all
allow from ::1
</Directory>
- - - - - stop edit - - - - - -