linux（RHEL5.6）安装pdo_mysql出错。提示mysql_querry missing[已解决]

chenyx

检查下你的mysql有没有phpmyadmin数据库,没有的话,在phpmyadmin的目录下找create_tables.sql,用mysql命令执行sql语句,就可以生成phpmyadmin数据库了

smallstarli

我也改不动·······用户名跟密码都没填错，凭什么说连不上
话说那个mysqluser不是填登陆mysql时候用的root么，为什么他们有人说是phpmyadmin

chenyx

那个是phpmyadmin自己的数据库,root可以赋权给phpmyadmin用户,当然root用户也可以.
这个就涉及到mysql的用户管理和权限管理了.

smallstarli

两个都没有phpmyadmin的数据库
那个多的是个什么，我也不知道 回复 214# chenyx


   

chenyx

列出来的都是数据库.
你找找吧,phpmyadmin里面肯定有我说的那个sql的

smallstarli

/**
* MySQL control user settings (this user must have read-only
*
* @global string $cfg['Servers'][$i]['controluser']
*/
$cfg['Servers'][$i]['controluser'] = 'root';

/**
* access to the "mysql/user" and "mysql/db" tables). The controluser is also
* used for all relational features (pmadb)
*
* @global string $cfg['Servers'][$i]['controlpass']
*/
$cfg['Servers'][$i]['controlpass'] = '111111';
这两项是不是填写的登陆到安装mysql那台电脑所用的用户名跟密码啊

chenyx

那个用户是mysql所在服务器的mysql用户,和系统账户不是一回事

smallstarli

不懂·······必须填吗，pma是什么意思啊

chenyx

那个是phpmyadmin记录一些数据用的数据库,我让你找的那个sql脚本就是用于生成那个phpmyadmin数据库用的.

chenyx

不行你就注释吧.这个是我的2.11.9.5的config.inc.php

1. <?php
   
2. /* vim: set expandtab sw=4 ts=4 sts=4: */
   
3. /**
   
4. * phpMyAdmin sample configuration, you can use it as base for
   
5. * manual configuration. For easier setup you can use scripts/setup.php
   
6. *
   
7. * All directives are explained in Documentation.html and on phpMyAdmin
   
8. * wiki <http://wiki.phpmyadmin.net>.
   
9. *
   
10. * @version $Id: config.sample.inc.php 12304 2009-03-24 12:56:58Z nijel $
    
11. */
    
12. 
    
13. /*
    
14. * This is needed for cookie based authentication to encrypt password in
    
15. * cookie
    
16. */
    
17. $cfg['blowfish_secret'] = 'chenyx'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
    
18. 
    
19. /*
    
20. * Servers configuration
    
21. */
    
22. $i = 0;
    
23. 
    
24. /*
    
25. * First server
    
26. */
    
27. $i++;
    
28. /* Authentication type */
    
29. $cfg['Servers'][$i]['auth_type'] = 'cookie';
    
30. /* Server parameters */
    
31. $cfg['Servers'][$i]['host'] = 'localhost';
    
32. $cfg['Servers'][$i]['connect_type'] = 'tcp';
    
33. $cfg['Servers'][$i]['compress'] = false;
    
34. /* Select mysqli if your server has it */
    
35. $cfg['Servers'][$i]['extension'] = 'mysql';
    
36. /* User for advanced features */
    
37. // $cfg['Servers'][$i]['controluser'] = 'pma';
    
38. // $cfg['Servers'][$i]['controlpass'] = 'pmapass';
    
39. /* Advanced phpMyAdmin features */
    
40. // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
    
41. // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
    
42. // $cfg['Servers'][$i]['relation'] = 'pma_relation';
    
43. // $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
    
44. // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
    
45. // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
    
46. // $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
    
47. // $cfg['Servers'][$i]['history'] = 'pma_history';
    
48. // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
    
49. 
    
50. /*
    
51. * End of servers configuration
    
52. */
    
53. 
    
54. /*
    
55. * Directories for saving/loading files from server
    
56. */
    
57. $cfg['UploadDir'] = '';
    
58. $cfg['SaveDir'] = '';
    
59. //$cfg['AllowArbitraryServer'] = 1;
    
60. ?>
    

复制代码