phpMyAdmin Authentication method

• Authentication Method — for single-user (root or trusted) environment…
  • Method 1: Prompt client for MySQL user/password…
    $cfg['Servers'][$i]['auth_type'] = 'http';
  • Method 2: Store MySQL user/password under config.ini.php…
    $cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root-password'; [Note password 'root-password'; substitute in set password for MySQL user 'root'; if no password set, leave as is (blank)]
• Authentication Method — for multi-user (untrusted) environment (this step is also required for enabling phpMyAdmin’s relational features)…
  $cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass'; [Note password 'pmapass']
• Create MySQL controluser user ‘pma@localhost’ with password ‘pmapass’, with the proper permissions set…
  C:\www\mysql\bin> mysql -u root -p
mysql> GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; [Note password 'pmapass']
  mysql> GRANT SELECT (Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv) ON mysql.user TO 'pma'@'localhost'; [Note that this query is too large to be pasted into the mysql command line in its entirety; select half, copy/paste, press enter, copy/paste other half]
  mysql> GRANT SELECT ON mysql.db TO 'pma'@'localhost';
mysql> GRANT SELECT ON mysql.host TO 'pma'@'localhost';
mysql> GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost';
mysql> quit

regards,

tolahtoleh.com™

554 email error message

554 email error message: “reason: 554 mail server permanently rejected message”: When you send an email, error message comes back with “reason: 554 mail server permanently rejected message”. Why does this happen? Usually, the “reason: 554 mail server permanently rejected message” email is received because the mail server thought your email is spam. Did you send an attachment – BINGO, that’s your problem! Even though the email server return message “reason: 554 mail server permanently rejected message” sounds severe, what you should do is change the extension of your attachment. 554 mail error: solution: Let’s say you sent an ‘.htm’ file to a friend. You got a “reason: 554 mail server permanently rejected message” error. I’d suggest using WINZIP to zip the file, therefore changing the extension and sending it again – and you’re all set and should not get 554 mail server permanently rejected message (#5.3.0) error again. sample “reason: 554 mail server permanently rejected message” The original message was received at Mon, 18 Jul 2005 14:10:32 -0400 (EDT) from xyz.com [***.***.***.***] —– The following addresses had permanent fatal errors —– <***@xyz.com> (reason: 554 mail server permanently rejected message (#5.3.0)) —– Transcript of session follows —– … while talking to smtp.***.net.: >>> DATA <<< 554 mail server permanently rejected message (#5.3.0) 554 5.0.0 Service unavailable