Re: phpmyadmin and mysqli vs. mysql php extension

[Mike <mike@xxxxxxxxxxxxxxx>]

Kayvan A. Sylvan schreef:

On Thu, Jul 06, 2006 at 08:50:20AM +0200, Mike wrote:
  

Hey, i am running an AMD Sempron 3400+ system, but i can't imagine that is the 
problem.
What does phpinfo(); tell you about what mysql extension you are using?

- Mike
    

It shows both mysql and mysqli extensions. Here's the output (pasted from
the web browser):

mysql
MySQL Support	enabled
Active Persistent Links 	0
Active Links 	0
Client API version 	4.1.20
MYSQL_MODULE_TYPE 	external
MYSQL_SOCKET 	/var/lib/mysql/mysql.sock
MYSQL_INCLUDE 	-I/usr/include/mysql
MYSQL_LIBS 	-L/usr/lib64/mysql -lmysqlclient

Directive	Local Value	Master Value
mysql.allow_persistent	On	On
mysql.connect_timeout	60	60
mysql.default_host	no value	no value
mysql.default_password	no value	no value
mysql.default_port	no value	no value
mysql.default_socket	no value	no value
mysql.default_user	no value	no value
mysql.max_links	Unlimited	Unlimited
mysql.max_persistent	Unlimited	Unlimited
mysql.trace_mode	Off	Off

mysqli
MysqlI Support	enabled
Client API version 	4.1.20
MYSQLI_SOCKET 	/var/lib/mysql/mysql.sock

Directive	Local Value	Master Value
mysqli.default_host	no value	no value
mysqli.default_port	3306	3306
mysqli.default_pw	no value	no value
mysqli.default_socket	no value	no value
mysqli.default_user	no value	no value
mysqli.max_links	Unlimited	Unlimited
mysqli.reconnect	Off	Off

  

Strange... that is exactly the same my phpinfo shows....

Here is what my config.inc.php has:

/* Server localhost (http) [1] */
$i++;
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'http';

/* End of servers configuration */

$cfg['AllowAnywhereRecoding'] = true;
$cfg['DefaultCharset'] = 'iso-8859-1';
$cfg['RecodingEngine'] = 'iconv';
$cfg['IconvExtraParams'] = '//TRANSLIT';
$cfg['GD2Available'] = 'yes';
$cfg['TextareaCols'] = 40;
$cfg['TextareaRows'] = 7;
$cfg['LongtextDoubleTextarea'] = true;
$cfg['TextareaAutoSelect'] = true;
$cfg['CharEditing'] = 'input';
$cfg['CharTextareaCols'] = 40;
$cfg['CharTextareaRows'] = 2;
$cfg['CtrlArrowsMoving'] = true;
$cfg['DefaultPropDisplay'] = 'horizontal';
$cfg['InsertRows'] = 2;
$cfg['ShowPhpInfo'] = true;

Maybe that helps.
- Mike

-- 
ATN Networks
Dirk de Derdelaan 215
3132 HE VLAARDINGEN
url: www.atn-networks.nl
mail: mike@xxxxxxxxxxxxxxx
mobiel: 06 - 28 11 49 91

Voor al uw hostinggebonden oplossingen