msql Error #2002 following upgrade to 2.5
Posted by: mulegoat (---.range86-134.btcentralplus.com)
Date: March 13, 2015 12:16PM

Hi there


Having issues with mysql connection following the upgrade to wamp 2.5 (32bit) on Windows 7.

I followed all the steps on the sticky post by RiggsFolly on this forum and created a virtual host for a new project which i can link to via localhost 'my projects'. When I start wamp the icon is green. After moving my data folder from my old wamp install i can browse my sites in localhost, log in to wordpress installs and modify posts without any issues (at least I'm not getting errors). I can log into phpMyadmin and create a new database, however, when I try to add a new user the green icon goes orange and I get the mysql #2002 error message 'No connection could be made because the target machine actively refused it.

The server is not responding (or the local server's socket is not correctly configured).'

I have read all posts on this forum regarding this issue and any changes made have not resolved the issue. These are my settings:

config.inc.php

<code>
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['verbose'] = 'mysql wampserver';
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock';
/* Server parameters */
$cfg['Servers'][$i]['host'] = '127.0.0.1';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

</code>

testmysql.php
<code>
<?php
//$link = mysql_connect('hostname','dbuser','dbpassword');
$link = mysql_connect('127.0.0.1','root','root');
if (!$link) {
die('Could not connect to MySQL: ' . mysql_error());
}
echo 'Connection OK'; mysql_close($link);
?>

</code>

httpd-vhosts.conf

<code>

#
# Virtual Hosts
#
# Use name-based virtual hosting.
#
#NameVirtualHost *:80

#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
# The first VirtualHost section is used for all requests that do not
# match a ServerName or ServerAlias in any <VirtualHost> block.
#

<VirtualHost *:80>
DocumentRoot "c:/wamp/www"
ServerName localhost
ServerAlias localhost
<Directory "c:/wamp/www">
AllowOverride All
Require local
</Directory>
</VirtualHost>

<VirtualHost *:80>
DocumentRoot "c:/wamp/www/bedrock-boilerplate"
ServerName bedrock-boilerplate
<Directory "c:/wamp/www/bedrock-boilerplate">
AllowOverride All
Require local
</Directory>
</VirtualHost>


</code>

hosts file from system32 / drivers / etc/

<code>
# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost

127.0.0.1 localhost
127.0.0.1 bedrock-boilerplate

::1 localhost
::1 bedrock-boilerplate


</code>

This is my mysql error log:
Version: '5.6.17' socket: '' port: 3306 MySQL Community Server (GPL)
2015-03-13 10:31:37 8728 [Note] Plugin 'FEDERATED' is disabled.
2015-03-13 10:31:37 8728 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-13 10:31:37 8728 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-13 10:31:37 8728 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-13 10:31:37 8728 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-13 10:31:37 8728 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-13 10:31:37 8728 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-13 10:31:37 8728 [Note] InnoDB: Completed initialization of buffer pool
2015-03-13 10:31:37 8728 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-13 10:31:37 8728 [Note] InnoDB: The log sequence numbers 65309078 and 65309078 in ibdata files do not match the log sequence number 65309088 in the ib_logfiles!
2015-03-13 10:31:37 8728 [Note] InnoDB: Database was not shutdown normally!
2015-03-13 10:31:37 8728 [Note] InnoDB: Starting crash recovery.
2015-03-13 10:31:37 8728 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-03-13 10:31:38 8728 [Note] InnoDB: Restoring possible half-written data pages
2015-03-13 10:31:38 8728 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 24862556, file name .\mysql-bin.001210
2015-03-13 10:31:38 8728 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-13 10:31:38 8728 [Note] InnoDB: Waiting for purge to start
2015-03-13 10:31:38 8728 [Note] InnoDB: 5.6.17 started; log sequence number 65309088
2015-03-13 10:31:38 8728 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-13 10:31:38 8728 [Note] IPv6 is available.
2015-03-13 10:31:38 8728 [Note] - '::' resolves to '::';
2015-03-13 10:31:38 8728 [Note] Server socket created on IP: '::'.
2015-03-13 10:31:38 8728 [ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
2015-03-13 10:31:38 8728 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2015-03-13 10:31:38 8728 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2015-03-13 10:31:38 8728 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2015-03-13 10:31:38 8728 [Note] Event Scheduler: Loaded 0 events
2015-03-13 10:31:38 8728 [Note] wampmysqld: ready for connections.
Version: '5.6.17' socket: '' port: 3306 MySQL Community Server (GPL)

I have a TeamViewer account setup and any help would be awesome.

Many thanks in advance

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: RiggsFolly (---.as43234.net)
Date: March 13, 2015 02:14PM

Yea it looks like you have moved the \data folder from an old version of MySQL to the new version.

Guess what old version of MySQL and new versions of MySQL are not necessarily totally compatible.



See this document for a better upgrade mechanism.


I would start by uninstalling 2.5 and then manually deleting all reference to C:\wamp assuming that where you put it.

Then follow this upgrade mechanism Installing a new release of WAMPServer

I assume you have a copy of the old installed version of WAMPServer somewhere

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: mulegoat (---.range86-134.btcentralplus.com)
Date: March 13, 2015 02:28PM

When you say manually deleting all reference to wamp do you mean simply removing this directory completely from C drive?

I don't have the older copy of wamp but i know the versions were apache 2.2.11, msql 5.1.36 and php 5.3.0. Was this wampserver 2.0i ? If so I can find this on sourceforge or somewhere.

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: RiggsFolly (---.as43234.net)
Date: March 13, 2015 05:07PM

When you say manually deleting all reference to wamp do you mean simply removing this directory completely from C drive?

Yes but dont do that yet until you have made a backup of your old \data folder.


I guess you will have to install the old version. Copy the \data folder to that.
THEN DO A PROPER BACKUP OF YOUR DATABASES
Then you can just restire the backups to the new version of WAMPServer


I don't have the older copy of wamp but i know the versions were apache 2.2.11, msql 5.1.36 and php 5.3.0. Was this wampserver 2.0i ? If so I can find this on sourceforge or somewhere.


You will have to try it, I dont remember or have a list of version in installs

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: mulegoat (---.range86-134.btcentralplus.com)
Date: March 13, 2015 06:40PM

I have all the old files in a 'wamp_old' directory. Am I able to simply uninstall 2.5, install 2.0 and then replace all contents of new wamp directory with what's in 'wamp_old'? Or is it just the mysql data folder i should be taking from the old directory?

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: mulegoat (---.range86-134.btcentralplus.com)
Date: March 17, 2015 11:30AM

Hello again

Ok, having followed your instructions my old localhost sites are working fine. However I cannot seem to get vhosts running properly. I have followed all the instructions but when i try to view the site via the 'my virtual hosts' link in the wamp menu i get the following error: Warning: mysqli_real_connect(): php_network_getaddresses: getaddrinfo failed: No such host is known. Also, on the list of available virtual hosts I get the following:

# match a ServerName or ServerAlias in any VirtualHost block.
localhost
bedrock-biolerplate

Here is my httpd-vhosts.conf file:

# Virtual Hosts
#
# Required modules: mod_log_config

# If you want to maintain multiple domains/hostnames on your
# machine you can setup VirtualHost containers for them. Most configurations
# use only name-based virtual hosts so the server doesn't need to worry about
# IP addresses. This is indicated by the asterisks in the directives below.
#
# Please see the documentation at
# <URL:[httpd.apache.org];
# for further details before you try to setup virtual hosts.
#
# You may use the command line option '-S' to verify your virtual host
# configuration.

#
# VirtualHost example:
# Almost any Apache directive may go into a VirtualHost container.
# The first VirtualHost section is used for all requests that do not
# match a ServerName or ServerAlias in any VirtualHost block.
#
<VirtualHost *:80>
DocumentRoot "c:/wamp/www"
ServerName localhost
ServerAlias localhost
<Directory "c:/wamp/www">
AllowOverride All
Require local
</Directory>
</VirtualHost>
#
<VirtualHost *:80>
DocumentRoot "c:/wamp/www/bedrock-boilerplate/web/"
ServerName bedrock-boilerplate
<Directory "c:/wamp/www/bedrock-boilerplate/web/">
Options FollowSymlinks
AllowOverride All
Require local
</Directory>
</VirtualHost>

When I run httpd -t command I get 'syntax OK' so not really sure what's going on here?

Hosts file:

# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost

127.0.0.1 localhost
127.0.0.1 bedrock-boilerplate

::1 localhost
::1 bedrock-boilerplate

Is there anything else i can check to debug this issue?

Many thanks in advance

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: RiggsFolly (---.as43234.net)
Date: March 17, 2015 12:23PM

That error is a MYSQL error, nothing to do with your Virtual Hosts

Is MySQL running?

Is the correct MySQL running that contains the database for the project you are trying to execute?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: mulegoat (---.range86-134.btcentralplus.com)
Date: March 17, 2015 01:02PM

Yes, mysql is running. Log reads:

2015-03-17 10:52:06 10484 [Note] Giving 0 client threads a chance to die gracefully
2015-03-17 10:52:06 10484 [Note] Event Scheduler: Purging the queue. 0 events
2015-03-17 10:52:06 10484 [Note] Shutting down slave threads
2015-03-17 10:52:06 10484 [Note] Forcefully disconnecting 0 remaining clients
2015-03-17 10:52:06 10484 [Note] Binlog end
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'partition'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_METRICS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_CMP'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'INNODB_TRX'
2015-03-17 10:52:06 10484 [Note] Shutting down plugin 'InnoDB'
2015-03-17 10:52:06 10484 [Note] InnoDB: FTS optimize thread exiting.
2015-03-17 10:52:06 10484 [Note] InnoDB: Starting shutdown...
2015-03-17 10:52:07 10484 [Note] InnoDB: Shutdown completed; log sequence number 1653133
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'BLACKHOLE'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'ARCHIVE'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'MRG_MYISAM'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'MyISAM'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'MEMORY'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'CSV'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'sha256_password'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'mysql_old_password'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'mysql_native_password'
2015-03-17 10:52:07 10484 [Note] Shutting down plugin 'binlog'
2015-03-17 10:52:07 10484 [Note] wampmysqld: Arrêt du serveur terminé

2015-03-17 10:52:12 7500 [Note] Plugin 'FEDERATED' is disabled.
2015-03-17 10:52:12 7500 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-03-17 10:52:12 7500 [Note] InnoDB: The InnoDB memory heap is disabled
2015-03-17 10:52:12 7500 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-03-17 10:52:12 7500 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-03-17 10:52:12 7500 [Note] InnoDB: Not using CPU crc32 instructions
2015-03-17 10:52:12 7500 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-03-17 10:52:12 7500 [Note] InnoDB: Completed initialization of buffer pool
2015-03-17 10:52:12 7500 [Note] InnoDB: Highest supported file format is Barracuda.
2015-03-17 10:52:12 7500 [Note] InnoDB: 128 rollback segment(s) are active.
2015-03-17 10:52:12 7500 [Note] InnoDB: Waiting for purge to start
2015-03-17 10:52:12 7500 [Note] InnoDB: 5.6.17 started; log sequence number 1653133
2015-03-17 10:52:12 7500 [Note] Server hostname (bind-address): '*'; port: 3306
2015-03-17 10:52:12 7500 [Note] IPv6 is available.
2015-03-17 10:52:12 7500 [Note] - '::' resolves to '::';
2015-03-17 10:52:12 7500 [Note] Server socket created on IP: '::'.
2015-03-17 10:52:13 7500 [Note] Event Scheduler: Loaded 0 events
2015-03-17 10:52:13 7500 [Note] wampmysqld: ready for connections.
Version: '5.6.17' socket: '' port: 3306 MySQL Community Server (GPL)

My testmysql file reads:

<?php
$link = mysql_connect('localhost','root','');
if (!$link) {
die('Could not connect to MySQL: ' . mysql_error());
}
echo 'Connection OK'; mysql_close($link);
?>

When i run this file i get:

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\testmysql.php on line 2

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: RiggsFolly (---.as43234.net)
Date: March 17, 2015 01:10PM

Ok so replace that file 'testmysql.php' with this code :-


<?php
/*    Using "mysqli" instead of "mysql" that is obsolete.
*     Utilisation de "mysqli" à la place de "mysql" qui est obsolète.
* Change the value of parameter 3 if you have set a password on the root userid
* Changer la valeur du 3e paramètre si vous avez mis un mot de passe à root
*/
$mysqli = new mysqli('127.0.0.1', 'root', '');

if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}
echo 'Connection OK';
$mysqli->close();
?>

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: msql Error #2002 following upgrade to 2.5
Posted by: mulegoat (---.range86-134.btcentralplus.com)
Date: March 17, 2015 02:14PM

Brilliant! Many thanks. This issue can be closed now

Options: ReplyQuote


Sorry, only registered users may post in this forum.