Error installing WordPress

Maybe that (Named Pipes) is the problem. When I re-installed MySQL, I put a check mark on “Named Pipes.” I thought it might be handy, since Windows also supports named pipes–or, I thought it did?

Anyway, I’ll try to either disable that feature–or re-install MySQL if necessary. I’ll let you know if that does it. It will probably be tomorrow before I do that.

Thanks,

Bob F

I re-installed MySQL with named_pipe = OFF.

Still no luck.

I downloaded a PHP script that checks the MySQL database mysqli_select_db() and it works–I am able to query the database. So, I don’t think MySQL is the problem.

I also re-installed WordPress, just to be sure.

I do believe that the issue is that PHP.ini is not configured correctly. Either that, or I’m missing some software related to PHP.

There are a lot of options under the [MySQLi] header in PHP.ini, and I have to believe that the problem could be there.

Also, what about mysqlnd? Remember, I’m on a Windows 10 computer.

Here’s what mine looks like:

[MySQLi]

; Maximum number of persistent links. -1 means no limit.
; https://php.net/mysqli.max-persistent
mysqli.max_persistent = -1

; Allow accessing, from PHP’s perspective, local files with LOAD DATA statements
; https://php.net/mysqli.allow_local_infile
;mysqli.allow_local_infile = On

; Allow or prevent persistent links.
; https://php.net/mysqli.allow-persistent
mysqli.allow_persistent = On

; Maximum number of links. -1 means no limit.
; https://php.net/mysqli.max-links
mysqli.max_links = -1

; Default port number for mysqli_connect(). If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
; https://php.net/mysqli.default-port
mysqli.default_port = 3306

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
; https://php.net/mysqli.default-socket
mysqli.default_socket =

; Default host for mysqli_connect() (doesn’t apply in safe mode).
; https://php.net/mysqli.default-host
mysqli.default_host =

; Default user for mysqli_connect() (doesn’t apply in safe mode).
; https://php.net/mysqli.default-user
mysqli.default_user =

; Default password for mysqli_connect() (doesn’t apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run ‘echo get_cfg_var(“mysqli.default_pw”)
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
; https://php.net/mysqli.default-pw
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off

[mysqlnd]
; Enable / Disable collection of general statistics by mysqlnd which can be
; used to tune and monitor MySQL operations.
mysqlnd.collect_statistics = On

; Enable / Disable collection of memory usage statistics by mysqlnd which can be
; used to tune and monitor MySQL operations.
mysqlnd.collect_memory_statistics = Off

; Records communication from all extensions using mysqlnd to the specified log
; file.
; https://php.net/mysqlnd.debug
;mysqlnd.debug =

; Defines which queries will be logged.
;mysqlnd.log_mask = 0

; Default size of the mysqlnd memory pool, which is used by result sets.
;mysqlnd.mempool_default_size = 16000

; Size of a pre-allocated buffer used when sending commands to MySQL in bytes.
;mysqlnd.net_cmd_buffer_size = 2048

; Size of a pre-allocated buffer used for reading data sent by the server in
; bytes.
;mysqlnd.net_read_buffer_size = 32768

; Timeout for network requests in seconds.
;mysqlnd.net_read_timeout = 31536000

; SHA-256 Authentication Plugin related. File with the MySQL server public RSA
; key.
;mysqlnd.sha256_server_public_key =

Thanks,

Bob F

If php.ini was configured incorrectly, then your test script would have failed as well.

What value did you use for hostname in the test script? Does it match the value of DB_HOST in your wp-config.php file? Did your test script use the same DB user/password that is specified in your wp-config.php file?

Well I did verify that /php74/php.ini is being used by my test script.

How about .htaccess? I don’t have an htaccess file under my htdocs directory.

See below:

;;;;;;;;;;;;;;;;;;;;
; php.ini Options  ;
;;;;;;;;;;;;;;;;;;;;
; Name for user-defined php.ini (.htaccess) files. Default is ".user.ini"
;user_ini.filename = ".user.ini"

I’m puzzled as to why wp-db.php is still using mysql_connect() instead of mysqli_connect(). Mysql_connect() was no longer available in PHP since PHP7.

Bob F.

Well, I think I’ve found the problem. I had cut and pasted the PHPIniDir in httpd.conf from someone’s recommendation, and I had placed double-quotes around “C:/php74” . Apparently, the quotes should not be there.

So now, I am able to see the install.php screen. I am still having some other issues, but I believe that they are related to the fact that I have empty tables in the WordPress database.

Thanks for your help. I am hoping that I can get the rest of the problems ironed out myself.

Thanks,

Bob F.