Since phpMyAdmin is an easy target for attackers, the next recommended task is to secure phpyMyAdmin. Next give the appropriate privileges to the 'phpmyadminuser' using command: GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION įrom now on, you can manage your databases via phpMyAdmin web interface. The password for phpmyadminuser is password. Here, phpmyadmin is the new user for accessing phpmyadmin dashboard. You will now be in mysql shell.Įnter the following command to create a new dedicated user for phpmyadmin: CREATE USER IDENTIFIED BY 'password' To do so, login to mysql shell using command: $ mysql -u root -pĮnter your mysql root password. However, it is recommended to create a dedicated user to manage databases via phpMyAdmin web interface. You can login to phpmyAdmin dashboard using 'phpmyadmin' user or mysql root user. Once phpMyAdmin is installed, a database user named 'phpmyadmin' will be automatically created with the administrative password you set during the installation. Create dedicated user to access phpMyAdmin dashboard You can now verify if mbstring extension is enabled or not by loading into info.php file from the web browser.Īs you can see in the above screenshot, mbstring module is enabled. $ sudo phpenmod mbstring $ sudo systemctl restart apache2
#Install phpmyadmin ubuntu 12.04 server update
Once phpmyadmin is installed, enable mbstring php extension and restart Apache service o update the changes as shown below. Provide mysql application password phpmyadmin. Configure phpMyAdmin with Apache web serverĬhoose Yes to configure database for phpmyadmin:
0 kommentar(er)
