PhpMyAdmin installation Configuration

I set up an nginx and mysql platform. I just created it and it was inconvenient for mysql not to use phpmyadmin. I took the previous source code and thought it would be okay to modify the database user and password.

The phpMyAdmin page displays: Wrongpermissionsonconfigurationfile, shouldnotbeworld writable
Cause: This is none of the XAMPP issues. It is a problem with phpmyadmin directory permission settings. If you set chmod 777 for all phpmyadmin files, this prompt will appear.
Solution: you only need to modify the file attributes. phpmyadmin must run under the 755 permission,
Run sudo chmod-R 755/opt/lampp/phpmyadmin on the terminal

It turned out that phpmyadmin permissions for 777, to all the files in the group and other users write permissions all removed, http://www.bkjia.com permissions to 755 after all normal.

There is no way to restore the original phpmyadmin database to this end. After a try, it will not work. If pma users cannot access the database, check it.

4. Create a MySQL user. The name is "pma", which grants it the select, insert, update, and delete permissions on the "phpmyadmin" database.

# Mysql-u root-p
Mysql> grant select, insert, update, delete on phpmyadmin. *
-> Pma @ localhost identified by 'Password ';
Mysql> quit;
Replace password with the password you specified.