C:\mysql\bin\mysql mysql
mysql> UPDATE user SET password=PASSWORD('your password') WHERE user='root';
mysql> QUIT
mysql> UPDATE user SET password=PASSWORD('your password') WHERE user='root';
mysql> QUIT
调试欢乐多
c:\mysql\bin\mysqladmin -u root reload
没有任何提示
之后,提示:no database selected
接着我输入use mydb;之后,提示:acess denied for user :“@localhost” to database mydb;
这是怎么回事?
谢谢
mysql> UPDATE user SET password=PASSWORD('root帐户的密码') WHERE user='root';
mysql> QUIT==========================================================
关于$cfg['PmaAbsoluteUri'] 在设定档案:
根据phpmyadmin目录下scripts/create_tables.sql的内容创建数据库.phpmyadmin的config.inc.php文件中:
---------------------------------------------------------
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['booktable'] = 'pma_book';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
----------------------------------------------------------
难道只能重装了吗?
c:\...> mysql -uroot
mysql>mysql -u root
怎么都没反映啊?
上面的语句对大小写有区别吗?
$cfgServers[1]['user'] = '用户名';
$cfgServers[1]['password'] = '密码';