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
- Ctrl + Alt + T to launch terminal
- sudo dpkg-reconfigure phpmyadmin
- Connection method for MySQL database for phpmyadmin: unix socket
- Name of the database's administrative user: root
- Password of the database's administrative user: mysqlsamplepassword
- MySQL username for phpmyadmin: root
- MySQL database name for phpmyadmin: phpmyadmin
- Web server to reconfigure automatically: apache2
- ERROR 1045
- ignore
- sudo dpkg-reconfigure mysql-server-5.5
- New password for the MySQL "root" user: mysqlsamplepassword
- Repeat password for the MySQL "root" user: mysqlsamplepassword
- After all this run following command on terminal to secure your mysql server. sudo mysql_secure_installation
- Enter current password for root (enter for none): mysqlsamplepassword
- Change the root password? [Y/n] n
- Remove anonymous users? [Y/n] y
- Disallow root login remotely? [Y/n] y
- Remove test database and access to it? [Y/n] y
- Reload privilege tables now? [Y/n] y
"ln -sf /usr/share/phpmyadmin/ /var/www/phpmyadmin"