Skip to content

{ Tag Archives } mysql

Centos下安装Nginx 0.8.30 + PHP 5.3.1+MySQL 5.5.0

首先在安装完CentOS后，先”yum -y update”，升级下CentOS。然后运行以下命令，以便安装所需要的程序以及开发库。 ?View Code BASHyum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers libmcrypt libmcrypt-devel pcre-devel 进入/usr/local/src目录，下载程序源代码。 ?View Code BASHcd /usr/local/src wget http://nginx.org/download/nginx-0.8.30.tar.gz wget [...]

Also tagged , , ,
2010 01 10 icemanpro IT Comments (9)

phpmyadmin中显示“链接表的额外特性尚未激活”的解决办法

安装了phpmyadmin，登录后，显示错误信息“链接表的额外特性尚未激活问题”,网上查询，解决办法是先建个名为”phpmyadmin”的数据库，再将scripts/create_tables.sql导入，最后将config.inc.php文件按下面内容修改。 $cfg['Servers'][$i]['pmadb'] = ‘phpmyadmin’; $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]['designer_coords'] = ‘pma_designer_coords’; 但按如上操作后，依然出现“链接表的额外特性尚未激活”的提示，网上也找不到其它的解决办法。 经研究后，发现是需要将config.inc.php中的['controluser']和['controlpass']按如下显示方式设置： $cfg['Servers'][$i]['controluser']=’pma’; $cfg['Servers'][$i]['controlpass']=’pmapass’; 其中，pma和pmapass可改为对’phpmyadmin’数据库有权限的MySQL的帐户名和帐户密码。 如果要使用pma和pmapass的话，需新建个’pma’帐户。在创建了’phpmyadmin‘数据库之后，执行如下SQL语句即可。 ?View Code MYSQLGRANT USAGE ON mysql.* TO ‘pma’@'localhost’ IDENTIFIED BY ‘pmapass’; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, [...]

Also tagged ,
2009 12 14 icemanpro IT Comments (1)