Before we start I would like to tell few things about this setup: we have mysql server (hostname is mysql1, with IP address 192.168.0.2) which has a httpd installed. In this example we want to give privileges to user someuser to data base testiranje identified by pillow password.
We assumed that you have already install mysql-server and apache package installed on system. Current version of phpmyadmin need to has a php version > 5.2, so we need to install it manually. We will need next packages: php-common, php-cli, php, php-pdo, php-mysql, php-mbstring, sqlite2. All this package are available on next link Required RPM's Install this package with next command:
Download phpMyAdmin from official site: Download phpMyAdmin Unzip downloaded phpmyadmin with next command and move it to proper folder.m
[root@mysql1 ~]# mv /path/to/phpMyAdmin-version-all-languages /var/www/html/phpmyadmin
[root@mysql1 ~]# cd /var/www/html/phpmyadmin/
In this directory you will find a file with name config.sample.inc.php, you should copy this file in file config.inc.php
Open config.inc.php for editing, and change next lines:
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'someuser'; User name for connecting on database
$cfg['Servers'][$i]['password'] = 'pillow';Password to auth
/* Server parameters */
$cfg['Servers'][$i]['host'] = '192.168.0.2';IP adress for server
Add user someuser to mysql identified by password pillow and grant all privileges on data base testiranje.
mysql> grant all privileges on testiranje.* to 'someuser'@'%' identified by 'pillow';
mysql> flush privileges;
Restart http and mysql. Now you can change database testiranje from web. Open your web browser and browse for http://192.168.0.2/phpmyadmin/