timski Posted April 11, 2009 Share Posted April 11, 2009 hi there peeps :-) i need a bit of help setting up phpmyadmin on windows 2000 installed apache 2.2.11 tested that on localhost got the "it works" page installed and configured perl 5.10.0.1004 tested that and got the "hello world" installed php version 5.2.9-2 created a phpifo.php file and wen to localhost/myinfo.php and i get the php list installed the MySQl mysql-essential-5.1.33-win32 looks ok when i test it from cmd line ... mysql> status -------------- C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe Ver 14.14 Distrib 5.1.33, for Win32 (ia32) Connection id: 3 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 5.1.33-community MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 TCP port: 3306 Uptime: 3 hours 12 min 9 sec Threads: 1 Questions: 16 Slow queries: 0 Opens: 15 Flush tables: 1 Open tab les: 0 Queries per second avg: 0.1 -------------- that looks like its working... downloaded the phpmyadmin 3.1.3.1 english unzipped it to the htdocs folder and renamed it to phpMyAdmin now this is where is all goes wrong followed the information about going to localhost/phpMyAdmin/index.php and i get an error mesg "phpMyAdmin - Error Cannot load mysql extension. Please check your PHP configuration. - Documentation" no i didi the normal google searches to get the infomation and i see lots explaining this to do this cfg['Servers'][$i]['auth_type'] = 'config'; And change the line so that it reads: $cfg['Servers'][$i]['auth_type'] = 'cookie'; **** cant see this in my php.ini file anywhere**** also this advice to remove the ";" from ;php_mysql.dll but that was not there either and other one "You might want to enable mbstring and curl modules as well by uncommenting the following lines on your php.ini file. extension=php_mbstring.dll extension=php_curl.dll " ********* i dont have this line***** another one about moving the libmySQL.dll to system32 folder but i dont have that except in C:\Program Files\MySQL\MySQL Server 5.1\bin here is come bit from my php.ini file Paths and Directories ; ;;;;;;;;;;;;;;;;;;;;;;;;; ; Windows: "\path1;\path2" ;include_path = ".;c:\php\includes" ; Directory in which the loadable extensions (modules) reside. extension_dir = "C:\php\ext" ;;;;;;;;;;;;;;;;;;;;;; ; Dynamic Extensions ; ;;;;;;;;;;;;;;;;;;;;;; ; ; If you wish to have an extension loaded automatically, use the following ; syntax: ; ; extension=modulename.extension ; ; For example, on Windows: ; ; extension=msql.dll ; ; ... or under UNIX: ; ; extension=msql.so ; ; Note that it should be the name of the module only; no directory information ; needs to go here. Specify the location of the extension with the ; extension_dir directive above. ; Windows Extensions ; Note that ODBC support is built in, so no dll is needed for it. ; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5) ; extension folders as well as the separate PECL DLL download (PHP 5). ; Be sure to appropriately set the extension_dir directive. so its not the advice out there also i have noticed that when i run the myinfo.php file nothing there shows mysql any help really appriciated pulling me hair out on this one thanks tim :-) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.