PHP Snippet 1:
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';
PHP Snippet 2:
$cfg['Servers'][$i]['port'] = '3307';
PHP Snippet 3:
sudo mysql -p -u root
PHP Snippet 4:
CREATE USER 'pmauser'@'%' IDENTIFIED BY 'password_here';
PHP Snippet 5:
GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;
PHP Snippet 6:
$cfg['Servers'][$i]['controluser'] = 'pmauser';
$cfg['Servers'][$i]['controlpass'] = 'password_here';
PHP Snippet 7:
$cfg['Servers'][$i]['controluser'] = 'root';
$cfg['Servers'][$i]['controlpass'] = '';
PHP Snippet 8:
$cfg['Servers'][$i]['port'] = '8111';
PHP Snippet 9:
$dbuser='pma';
$dbpass='my_pass';
$basepath='';
$dbname='phpmyadmin';
$dbserver='localhost';
$dbport='3306';
$dbtype='mysql';
PHP Snippet 10:
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'you_password';
PHP Snippet 11:
# The MySQL server
[mysqld]
skip-grant-tables
port= 3306
...
PHP Snippet 12:
sudo /Applications/XAMPP/xamppfiles/xampp security
PHP Snippet 13:
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'you_password';
PHP Snippet 14:
$cfg['Servers'][$i]['host'] = '127.0.0.1';
PHP Snippet 15:
$cfg['Servers'][$i]['host'] = 'localhost';
PHP Snippet 16:
$cfg['Servers'][$i]['host']
PHP Snippet 17:
sudo cp /usr/share/phpmyadmin/libraries/sql.lib.php /usr/share/phpmyadmin/libraries/sql.lib.php.bak
PHP Snippet 18:
sudo vi /usr/share/phpmyadmin/libraries/sql.lib.php
PHP Snippet 19:
sudo nano /usr/share/phpmyadmin/libraries/sql.lib.php
PHP Snippet 20:
mysql> CREATE USER 'pmauser'@'%' IDENTIFIED BY 'MyPasswordHere!';
Query OK, 0 rows affected (0.07 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;
Query OK, 0 rows affected (0.02 sec)
PHP Snippet 21:
/* PMA User advanced features */
//////////$cfg['Servers'][$i]['controluser'] = 'pma';
//////////$cfg['Servers'][$i]['controlpass'] = $password;
$cfg['Servers'][$i]['controluser'] = 'pmauser';
$cfg['Servers'][$i]['controlpass'] = 'MyPasswordHere!';
PHP Snippet 22:
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'yourPassword of server;
$cfg['Servers'][$i]['host'] = 'localhost:yourPort';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'yourPassword of server';
PHP Snippet 23:
$cfg['Servers'][$i]['port'] = '8111';
