WampServer

I have just installed Wamp v2.2
Apache v2.22
PHP v5.3.113
MySQL v5.5.24

The server is running and if I go to the Wamp Server page and phpinfo under tools works and displays the info. (The server Icon is orange if that means anything)

However when I try to run phpadmin, I get Forbidden
You don't have permission to access /phpmyadmin/ on this server.

I don't understand.

I am an administratir on this computer. The machine is a windows 8 machinr, lots of ram and hard disk space.

How do I get past this?

TIA,
Mike

If wampmanager icon is ORANGE then either the Apache or MySQL service has not started.
As you say you can get to the homepage and phpInfo page, we can assume MySQL has not started.

Do a search for a file called my.ini. If you find any not in the C:\wamp folder structure delete them.

Then try restarting MySQL and then try phpMyAdmin again.

The WAMP icon is now green, however when I try to use phpadmin I still get the original error (403-forbidden)
Any other ideas?

TIA,
Mike

Hi Mike,

I think this may be an IPV4 / IPV6 issue.


Can you change these things please

1. Make sure c:\windows\system32\drivers\etc\hosts contains these 2 references

127.0.0.1 localhost
::1 localhost

2. Change this file c:\wamp\alias\phpmyadmin\phpmyadmin.conf

<Directory "d:/wamp/apps/phpmyadminX.Y.Z/">
Options Indexes FollowSymLinks ExecCGI
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1
Allow from ::1
Allow from localhost
</Directory>

I seem to have a similar problem. I already installed Wamp twice. I checked all the issues mentioned above. My my.ini file is empty.

The server icon is yellow and it says server offline.

I am running Windows 7.

Thanks

Harry

forgot WAMPSERVER 2.4

Where are you looking at he my.ini. Tell me the full path to that file.

Thank you

wamp\bin\mysql5.6.12\

and now it reads

Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:\mysql\data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# 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
key_buffer = 16M
max_allowed_packet = 1M

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.6.12
log-error=c:/wamp/logs/mysql.log
datadir=c:/wamp/bin/mysql/mysql5.6.12/data

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking

# 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';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
# start replication for the first time (even unsuccessfully, for example
# if you mistyped the password in master-password and the slave fails to
# connect), the slave will create a master.info file, and any later
# change in this file to the variables' values below will be ignored and
# overridden by the content of the master.info file, unless you shutdown
# the slave server, delete master.info and restart the slaver server.
# For that reason, you may want to leave the lines below untouched
# (commented) and instead use CHANGE MASTER TO (see above)
#
# 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

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysqld]
port=3306



Edited 1 time(s). Last edit at 07/11/2013 09:51PM by blowntobits.

Does this mean it is now working?

If not check the mysql error log and Windows Event Viewer for messages from MySQL.

No - doesn't work. Here is the mysql log:

2013-07-13 01:00:57 4012 [Note] Giving 0 client threads a chance to die gracefully
2013-07-13 01:00:57 4012 [Note] Event Scheduler: Purging the queue. 0 events
2013-07-13 01:00:57 4012 [Note] Shutting down slave threads
2013-07-13 01:00:57 4012 [Note] Forcefully disconnecting 0 remaining clients
2013-07-13 01:00:57 4012 [Note] Binlog end
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'partition'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_METRICS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_CMPMEM'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_CMP'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_LOCKS'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'INNODB_TRX'
2013-07-13 01:00:58 4012 [Note] Shutting down plugin 'InnoDB'
2013-07-13 01:00:58 4012 [Note] InnoDB: FTS optimize thread exiting.
2013-07-13 01:00:58 4012 [Note] InnoDB: Starting shutdown...
2013-07-13 01:01:00 4012 [Note] InnoDB: Shutdown completed; log sequence number 1626017
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'BLACKHOLE'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'ARCHIVE'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'MRG_MYISAM'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'MyISAM'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'MEMORY'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'CSV'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'sha256_password'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'mysql_old_password'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'mysql_native_password'
2013-07-13 01:01:00 4012 [Note] Shutting down plugin 'binlog'
2013-07-13 01:01:00 4012 [Note] wampmysqld: Shutdown complete

Afraid that does not help much, it looks like a normal clean shutdown as far as I can see.

Have you checked Windows Event Viewer for messages from MySQL?

Thanks - the following errors come up in the event viewer:

- System

- Provider

[ Name] Service Control Manager
[ Guid] {555908d1-a6d7-4695-8e1e-26931d2012f4}
[ EventSourceName] Service Control Manager

- EventID 7024

[ Qualifiers] 49152

Version 0

Level 2

Task 0

Opcode 0

Keywords 0x8080000000000000

- TimeCreated

[ SystemTime] 2013-07-15T10:47:15.689291600Z

EventRecordID 28782

Correlation

- Execution

[ ProcessID] 688
[ ThreadID] 7076

Channel System

Computer HG-PC

Security


- EventData

param1 wampapache
param2 %%1

and 8 sec later

+ System

- Provider

[ Name] Service Control Manager
[ Guid] {555908d1-a6d7-4695-8e1e-26931d2012f4}
[ EventSourceName] Service Control Manager

- EventID 7024

[ Qualifiers] 49152

Version 0

Level 2

Task 0

Opcode 0

Keywords 0x8080000000000000

- TimeCreated

[ SystemTime] 2013-07-15T10:47:23.371506800Z

EventRecordID 28785

Correlation

- Execution

[ ProcessID] 688
[ ThreadID] 7076

Channel System

Computer HG-PC

Security


- EventData

param1 wampapache
param2 %%1

I cannot pick the bones out of that.

Install TeamViewer and I will troubleshoot for you.

Install TV, then run it.

Do this before attempting a connection.

How to Configure Team Viewer so it does not require port 80 or 443

Run TV
Extras -> Options -> Advanced -> Press the Advanced Button -> Advanced Network Connections

Check the checkbox saying [ Dont use incomming port 80 (recommended for web servers only ) ]
Stop and restart TV.

Then
Send me a Private Message containing the TV ID and PASSWORD so I can connect.
Leave TV running as it will change the password each time you restart it.

Thanks again - map server fine. Great job done.

created new database lwith local phpMyAdmin, had exported the SQL from live web and tried to import. Errors message - this file is too big (max 2,048 KiB -

zipped it, still received error message:

SQL query:

--
-- Datenbank: `db2992201`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `kp4oaw2q_bwps_lockouts`
--
CREATE TABLE IF NOT EXISTS `kp4oaw2q_bwps_lockouts` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`type` int( 1 ) NOT NULL ,
`active` int( 1 ) NOT NULL ,
`starttime` int( 10 ) NOT NULL ,
`exptime` int( 10 ) NOT NULL ,
`host` varchar( 20 ) default NULL ,
`user` bigint( 20 ) default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =9;

MySQL said: Documentation
#1046 - No database selected

Any thought

Harry

For large databases dont use phpMyAdmin to restore them, it is limited by the time allowed for a PHP job to run.

Instead use the command line processor

wampmanager -> MySQL -> MySQL Console

that runs the mysql.exe in a command window. It will ask for a password, if you have not changed the password on the 'root' userid just hit enter when it asks for a password else enter your 'root' password.

Then keyin the following 2 lines in at the command prompt

use TheDatabaseNameYouWantToLoad;
source the_Filename_containing_the_backup;


This shoudl work

when trying that the following error pops up:

error 1049 <42000>: Unknown database 'db2992201.sql'

You still need to create the Database, to hold the tabels you are restoring, using phpMyAdmin.

I did create the database with phpMyAdmin

i find the following users in phpMyAdmin for that database:


User Host Type Privileges Grant Action
root 127.0.0.1 global global Yes Edit
root ::1 global global Yes Edit
root Localhost global global Yes Edit

in the console i put in

mysql> use db2992201.sql;source c:\db2992201.sql; (the name of the SQl database file)


and receive:

ERROR 1049 <42000>: Unkonown database 'db29992201.sql'

Nearly !

[No .sql required this is the name of the database not the file name
mysql> use db2992201;

mysql> source c:\db2992201.sql;


Have another try

well thanks - in the cmd window it now said:

Database changed

however when I open phpMyAdmin and click on that database it is empty, no tables........