我的php.ini中mysql是如下配置的:[MySQL]
mysql.allow_persistent = On ; allow or prevent persistent link
mysql.max_persistent = -1 ; maximum number of persistent links. -1 means no limit
mysql.max_links = -1 ; maximum number of links (persistent+non persistent). -1 means no limit
mysql.default_port = ; default port number for mysql_connect(). If unset,
; mysql_connect() will use the $MYSQL_TCP_PORT, or the mysql-tcp
; entry in /etc/services, or the compile-time defined MYSQL_PORT
; (in that order). Win32 will only look at MYSQL_PORT.
mysql.default_socket = ; default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults
mysql.default_host = ; default host for mysql_connect() (doesn't apply in safe mode)
mysql.default_user = ; default user for mysql_connect() (doesn't apply in safe mode)
mysql.default_password = ; default password for mysql_connect() (doesn't apply in safe mode)对与在linux下:你可以这样试试:
tar xvfz mysql-3.23.22.tar.gz
cd mysql-3.23.22
./configure
make
make install
cd/usr/local/bin
./mysql_install_db
顺利的话,mysql就算编译好了,运行他:
cd/usr/local/share/mysql
chmod +x mysql.server
./mysql.server
cd/usr/local/bin
,/mysql -uroot
应可看到:
>use mysql;
>select * from user;
mysql.allow_persistent = On ; allow or prevent persistent link
mysql.max_persistent = -1 ; maximum number of persistent links. -1 means no limit
mysql.max_links = -1 ; maximum number of links (persistent+non persistent). -1 means no limit
mysql.default_port = ; default port number for mysql_connect(). If unset,
; mysql_connect() will use the $MYSQL_TCP_PORT, or the mysql-tcp
; entry in /etc/services, or the compile-time defined MYSQL_PORT
; (in that order). Win32 will only look at MYSQL_PORT.
mysql.default_socket = ; default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults
mysql.default_host = ; default host for mysql_connect() (doesn't apply in safe mode)
mysql.default_user = ; default user for mysql_connect() (doesn't apply in safe mode)
mysql.default_password = ; default password for mysql_connect() (doesn't apply in safe mode)对与在linux下:你可以这样试试:
tar xvfz mysql-3.23.22.tar.gz
cd mysql-3.23.22
./configure
make
make install
cd/usr/local/bin
./mysql_install_db
顺利的话,mysql就算编译好了,运行他:
cd/usr/local/share/mysql
chmod +x mysql.server
./mysql.server
cd/usr/local/bin
,/mysql -uroot
应可看到:
>use mysql;
>select * from user;
root;为你在mysql的user表中设定的用户名,password为该用户的口令,
你首次安装时默认用户名为root或空,password为空
应为:
mysql_connect("localhost","root","");或
mysql_connect("localhost","","");