启动phpMyAdmin的问题
redhat9+apache2.0.49+php4.0.20环境下启动phpMyAdmin的问题Apache和PHP配置正常,mysql在命令行测试正常.但是链接到http://shaw/phpMyAdmin/出现如下错误:(shaw是我本机名称)
Welcome to phpMyAdmin 2.5.6
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, uname and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
#1130 - Host 'shaw' is not allowed to connect to this MySQL server
请教了!
Host 'shaw' is not allowed to connect to this MySQL server
You should check the host, uname and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
已经说得很清楚啦 我这里其实已经反复改过几次了,原来config.inc.php中server config部分为:
$i++;
$cfg['Servers'][$i]['host'] = '127.0.0.1';
g['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'tiren';
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['verbose'] = '';
$cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$cfg['Servers'][$i]['bookmarktable'] = ''; // 'pma_bookmark'
$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'
$cfg['Servers'][$i]['verbose_check'] = TRUE;
$cfg['Servers'][$i]['AllowDeny']['order']
= '';
$cfg['Servers'][$i]['AllowDeny']['rules']
= array();
现在把$cfg['Servers'][$i]['host'] 改为 = 'localhost';
运行,出现以下提示:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, uname and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said:
#2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
我又做了以下工作,出现以下提示:
# mysqladmin ping
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
# mysqld
0406107:30:36Warning: Asked for 196608 thread stack, but got 126976
0406107:30:36Can't start server: Bind on TCP/IP port: Address already in use0406107:30:36Do you already have another mysqld server running on port: 3306 ?
0406107:30:36Aborting
0406107:30:36mysqld: Shutdown Complete
# mysqld
0406107:37:55Warning: Asked for 196608 thread stack, but got 126976
0406107:37:55Can't start server: Bind on TCP/IP port: Address already in use0406107:37:55Do you already have another mysqld server running on port: 3306 ?
0406107:37:55Aborting
0406107:37:55mysqld: Shutdown Complete
看起来肯定是我的密码有些问题,但是做如下操作:
# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.20-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
又没有问题.请教问题到底在哪里?我要晕倒了
040610 7:30:36 Warning: Asked for 196608 thread stack, but got 126976
040610 7:30:36 Can't start server: Bind on TCP/IP port: Address already in use040610 7:30:36 Do you already have another mysqld server running on port: 3306 ?
040610 7:30:36 Aborting
看来 MySQL 已经启动了………………
#2002 - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
不能连接到MySQL？！
页:
[1]