给mysql的root设密码

grant all on mysql.* to 'root'@'localhost' identified by 'password';
最后那个password即是你要修改的root用户的密码
在phpmyadmin下的config.inc.php中修改配置文件如下：
/*
 * Generated configuration file
 * Generated by: phpMyAdmin 2.11.10 setup script by Michal Čihař
 * Version: $Id: setup.php 13149 2009-12-07 13:09:09Z nijel $
 * Date: Wed, 28 Jul 2010 10:35:13 GMT
 */

/* Servers configuration */
$i = 0;

/* Server localhost (config:root) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'rootwxl';

$cfg['Servers'][$i]['AllowDeny']['order'] = '';

$cfg['Servers'][$i]['AllowDeny']['rules'] = array();



/* End of servers configuration */

$cfg['UploadDir'] = '/var/www/upload';
$cfg['SaveDir'] = '/var/www/upload';
$cfg['AllowAnywhereRecoding'] = false;
$cfg['DefaultCharset'] = 'gb2312';
$cfg['RecodingEngine'] = 'iconv';
$cfg['IconvExtraParams'] = '//TRANSLIT';
?>