WampServer

Hello

i'm running wamp 2.2 with
apache 2.4.2
php 5.4.3
mysql 5.5.24

i have a webpage that uses a sql data base
everything was runnig fine until i tried to update the Page for what i need to connect to database during installation.
But it's impossible to connect

first i got this

______________________________mysql log__________________________________
130122 11:30:07 [Note] Plugin 'FEDERATED' is disabled.
130122 11:30:07 InnoDB: The InnoDB memory heap is disabled
130122 11:30:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130122 11:30:07 InnoDB: Compressed tables use zlib 1.2.3
130122 11:30:07 InnoDB: Initializing buffer pool, size = 128.0M
130122 11:30:07 InnoDB: Completed initialization of buffer pool
130122 11:30:07 InnoDB: highest supported file format is Barracuda.
130122 11:30:09 InnoDB: Waiting for the background threads to start
130122 11:30:10 InnoDB: 1.1.8 started; log sequence number 3625280
130122 11:30:10 [Note] Server hostname (bind-address): '(null)'; port: 3306
130122 11:30:10 [Note] - '(null)' resolves to '::';
130122 11:30:10 [Note] - '(null)' resolves to '0.0.0.0';
130122 11:30:10 [Note] Server socket created on IP: '0.0.0.0'.
130122 11:30:10 [Note] Event Scheduler: Loaded 0 events
130122 11:30:10 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)


Event Scheduler: Purging the queue. 0 events
130122 11:41:44 InnoDB: Starting shutdown...
130122 11:41:44 InnoDB: Shutdown completed; log sequence number 3625280
130122 11:41:44 [Note] wampmysqld: Shutdown complete
_________________________________________________________________________________

Then uninstalled wamp and installed it new
also installed mysql 5.1.41 and using this right now

now i get this

__________________________mysql log__________________________________
130122 12:31:52 [Note] Plugin 'FEDERATED' is disabled.
130122 12:31:52 InnoDB: The InnoDB memory heap is disabled
130122 12:31:52 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130122 12:31:52 InnoDB: Compressed tables use zlib 1.2.3
130122 12:31:52 InnoDB: Initializing buffer pool, size = 128.0M
130122 12:31:52 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130122 12:31:53 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130122 12:31:53 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130122 12:31:53 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130122 12:31:53 InnoDB: Waiting for the background threads to start
130122 12:31:54 InnoDB: 1.1.8 started; log sequence number 0
130122 12:31:54 [Note] Server hostname (bind-address): '(null)'; port: 3306
130122 12:31:54 [Note] - '(null)' resolves to '::';
130122 12:31:54 [Note] - '(null)' resolves to '0.0.0.0';
130122 12:31:54 [Note] Server socket created on IP: '0.0.0.0'.
130122 12:31:54 [Note] Event Scheduler: Loaded 0 events
130122 12:31:54 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130122 12:40:55 [Note] wampmysqld: Normal shutdown

130122 12:40:55 [Note] Event Scheduler: Purging the queue. 0 events
130122 12:40:55 InnoDB: Starting shutdown...
130122 12:40:56 InnoDB: Shutdown completed; log sequence number 1595675
130122 12:40:56 [Note] wampmysqld: Shutdown complete

130122 12:41:03 [Note] Plugin 'FEDERATED' is disabled.
130122 12:41:03 InnoDB: The InnoDB memory heap is disabled
130122 12:41:03 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130122 12:41:03 InnoDB: Compressed tables use zlib 1.2.3
130122 12:41:03 InnoDB: Initializing buffer pool, size = 128.0M
130122 12:41:03 InnoDB: Completed initialization of buffer pool
130122 12:41:03 InnoDB: highest supported file format is Barracuda.
130122 12:41:03 InnoDB: Waiting for the background threads to start
130122 12:41:04 InnoDB: 1.1.8 started; log sequence number 1595675
130122 12:41:04 [Note] Server hostname (bind-address): '(null)'; port: 3306
130122 12:41:04 [Note] - '(null)' resolves to '::';
130122 12:41:04 [Note] - '(null)' resolves to '0.0.0.0';
130122 12:41:04 [Note] Server socket created on IP: '0.0.0.0'.
130122 12:41:04 [Note] Event Scheduler: Loaded 0 events
130122 12:41:04 [Note] wampmysqld: ready for connections.
Version: '5.5.24-log' socket: '' port: 3306 MySQL Community Server (GPL)
130122 12:41:08 [Note] wampmysqld: Normal shutdown

130122 12:41:08 [Note] Event Scheduler: Purging the queue. 0 events
130122 12:41:08 InnoDB: Starting shutdown...
130122 12:41:09 InnoDB: Shutdown completed; log sequence number 1595675
130122 12:41:09 [Note] wampmysqld: Shutdown complete

130122 12:41:09 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
130122 12:41:09 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130122 12:41:09 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130122 12:41:10 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130122 12:41:10 InnoDB: Started; log sequence number 0 0
130122 12:41:10 [Note] Event Scheduler: Loaded 0 events
130122 12:41:10 [Note] wampmysqld: ready for connections.
Version: '5.1.41-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
130122 12:42:53 [Note] wampmysqld: Normal shutdown

130122 12:42:53 [Note] Event Scheduler: Purging the queue. 0 events
130122 12:42:53 InnoDB: Starting shutdown...
130122 12:42:54 InnoDB: Shutdown completed; log sequence number 0 44233
130122 12:42:54 [Note] wampmysqld: Shutdown complete

130122 12:42:55 [Note] Plugin 'FEDERATED' is disabled.
130122 12:42:55 InnoDB: Started; log sequence number 0 44233
130122 12:42:55 [Note] Event Scheduler: Loaded 0 events
130122 12:42:56 [Note] wampmysqld: ready for connections.
Version: '5.1.41-community-log' socket: '' port: 3306 MySQL Community Server (GPL)
130122 13:27:22 [Note] wampmysqld: Normal shutdown
___________________________________________________________________



_______________________my.ini_____________________________________
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir="c:/wamp/bin/mysql/mysql5.1.41"
log-error="c:/wamp/logs/mysql.log"
datadir="c:/wamp/bin/mysql/mysql5.1.41/data"

# Disable Federated by default
skip-federated

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# binary logging format - mixed recommended
binlog_format=mixed

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id = 2
#
# The replication master for this slave - required
#master-host = <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user = <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password = <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port = <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Point the following paths to different dedicated disks
#tmpdir = /tmp/
#log-update = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = C:\mysql\data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = C:\mysql\data/
#innodb_log_arch_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
_________________________________________________________________


I can access Data base via php admin but cannot connect with my website installation
i created an extra user with pw, all privileges and have a root user with pw



Edited 1 time(s). Last edit at 01/22/2013 01:56PM by Sinista.

Federated is not your problem. Thats an extension that alows you to access external databases via MySQL.

Look somewhere else.

Post the code you used to do the mysql_connect