Page 1 of 1

unable to access phpmyadmin with localhost

PostPosted: 17. October 2012 13:21
by samuelwktang
Hi,

I have removed the xampp v1.8.1 and re-insllated it in Windows 7. During the uninstall process, I have already deleted c:\xampp folder.
After the re-installation, I can go to the frontpage with "localhost" in url. But I cannot access the phpmyadmin page to create the database.

I found that I can access phpmyadmin with "127.0.0.1"

I have added the line "127.0.0.1 localhost" in the "hosts" file. I still doesn't work.

Can anyone help me to solve this problem?

Samuel

Re: unable to access phpmyadmin with localhost

PostPosted: 18. October 2012 11:06
by JonB
But I cannot access the phpmyadmin page to create the database.


On the assumption you are typing http://localhost/phpmyadmin to access phpMyAdmin:

What error do you get?

I should point out it probably does not matter to the functionality of MySQL how you access phpMyAdmin. It's just a shell interface for MySQL.

Good Luck
8)

Re: unable to access phpmyadmin with localhost

PostPosted: 22. October 2012 11:28
by samuelwktang
Hi JonB,

I got the following message:

Database Error: Unable to connect to the database:Could not connect to MySQL

I think you are right, it is not the problem of MySQL itself.

When I do something like delete the website folder inside c:\xampp\htdocs and restart the computer and set up a new website folder inside htdocs. the phpmyadmin will not work and display same error message. So I can't even access the mySQL.

I stop the Mysql in xampp control panel and restart it again. It still doesn't work. Same error message appears.

Is there anything wrong on my installation or something else to cause this problem?

Thanks.
Samuel

Re: unable to access phpmyadmin with localhost

PostPosted: 30. October 2012 20:00
by mrfdes
I have the same problem.
The error message (in my browser) I am getting is:
Code: Select all
Not Found

The requested URL /phpmyadmin/ was not found on this server.



And this is what it says at the bottom of my XAMPP Control Panel:
Code: Select all
17:16:18  [main]    Initializing Control Panel
17:16:18  [main]    Windows Version: Windows 7 Ultimate SP1 32-bit
17:16:18  [main]    XAMPP Version: 1.8.1
17:16:18  [main]    Control Panel Version: 3.1.0 3.1.0 [ Compiled: September 20th 2012 ]
17:16:18  [main]    You are not running with administrator rights! This will work for
17:16:18  [main]    most application stuff but whenever you do something with services
17:16:18  [main]    there will be a security dialogue or things will break! So think
17:16:18  [main]    about running this application with administrator rights!
17:16:18  [main]    XAMPP Installation Directory: "c:\xampp\"
17:16:18  [main]    Checking for prerequisites
17:16:18  [main]    All prerequisites found
17:16:18  [main]    Initializing Modules
17:16:18  [Apache]    Problem detected!
17:16:18  [Apache]    Port 80 in use by "httpd.exe"!
17:16:18  [Apache]    Apache WILL NOT start without the configured ports free!
17:16:18  [Apache]    You need to uninstall/disable/reconfigure the blocking application
17:16:18  [Apache]    or reconfigure Apache to listen on a different port
17:16:18  [mysql]    Problem detected!
17:16:18  [mysql]    Port 3306 in use by "mysqld.exe"!
17:16:19  [mysql]    MySQL WILL NOT start without the configured ports free!
17:16:19  [mysql]    You need to uninstall/disable/reconfigure the blocking application
17:16:19  [mysql]    or reconfigure MySQL to listen on a different port
17:16:19  [mercury]    Problem detected!
17:16:19  [mercury]    Port 25 in use by "hmailserver.exe"!
17:16:19  [mercury]    Mercury WILL NOT start without the configured ports free!
17:16:19  [mercury]    You need to uninstall/disable/reconfigure the blocking application
17:16:19  [mercury]    or reconfigure Mercury to listen on a different port
17:16:19  [mercury]    Problem detected!
17:16:19  [mercury]    Port 110 in use by "hmailserver.exe"!
17:16:19  [mercury]    Mercury WILL NOT start without the configured ports free!
17:16:19  [mercury]    You need to uninstall/disable/reconfigure the blocking application
17:16:19  [mercury]    or reconfigure Mercury to listen on a different port
17:16:19  [mercury]    Problem detected!
17:16:19  [mercury]    Port 143 in use by "hmailserver.exe"!
17:16:19  [mercury]    Mercury WILL NOT start without the configured ports free!
17:16:19  [mercury]    You need to uninstall/disable/reconfigure the blocking application
17:16:19  [mercury]    or reconfigure Mercury to listen on a different port
17:16:19  [main]    Enabling autostart for module "Apache"
17:16:19  [main]    Enabling autostart for module "MySQL"
17:16:19  [main]    Starting Check-Timer
17:16:19  [main]    Control Panel Ready
17:16:19  [Apache]    Autostart aborted: Apache is already running
17:16:19  [mysql]    Autostart aborted: MySQL is already running


And my error log says:

Code: Select all
120911 22:17:04 [Note] Plugin 'FEDERATED' is disabled.
120911 22:17:05 InnoDB: The InnoDB memory heap is disabled
120911 22:17:05 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120911 22:17:05 InnoDB: Compressed tables use zlib 1.2.3
120911 22:17:05 InnoDB: Initializing buffer pool, size = 16.0M
120911 22:17:05 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist:
InnoDB: a new database to be created!
120911 22:17:05  InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
120911 22:17:05  InnoDB: Log file C:\xampp\mysql\data\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
120911 22:17:06  InnoDB: Log file C:\xampp\mysql\data\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file C:\xampp\mysql\data\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
120911 22:17:07  InnoDB: Waiting for the background threads to start
120911 22:17:08 InnoDB: 1.1.8 started; log sequence number 0
120911 22:17:08 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
120911 22:17:08 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
120911 22:17:08 [Note] Server socket created on IP: '0.0.0.0'.
120911 22:17:08 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
120911 22:17:08 [ERROR] Do you already have another mysqld server running on port: 3306 ?
120911 22:17:08 [ERROR] Aborting

120911 22:17:08  InnoDB: Starting shutdown...
120911 22:17:09  InnoDB: Shutdown completed; log sequence number 1595675
120911 22:17:09 [Note] mysql\bin\mysqld.exe: Shutdown complete

121030 14:39:56 [Note] Plugin 'FEDERATED' is disabled.
121030 14:39:56 InnoDB: The InnoDB memory heap is disabled
121030 14:39:56 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 14:39:56 InnoDB: Compressed tables use zlib 1.2.3
121030 14:39:57 InnoDB: Initializing buffer pool, size = 16.0M
121030 14:39:57 InnoDB: Completed initialization of buffer pool
121030 14:39:57 InnoDB: highest supported file format is Barracuda.
121030 14:39:59  InnoDB: Waiting for the background threads to start
121030 14:40:00 InnoDB: 1.1.8 started; log sequence number 1595675
121030 14:40:00 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121030 14:40:00 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121030 14:40:00 [Note] Server socket created on IP: '0.0.0.0'.
121030 14:40:00 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
121030 14:40:00 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121030 14:40:00 [ERROR] Aborting

121030 14:40:00  InnoDB: Starting shutdown...
121030 14:40:01  InnoDB: Shutdown completed; log sequence number 1595675
121030 14:40:01 [Note] mysql\bin\mysqld.exe: Shutdown complete

121030 14:42:18 [Note] Plugin 'FEDERATED' is disabled.
121030 14:42:19 InnoDB: The InnoDB memory heap is disabled
121030 14:42:19 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 14:42:19 InnoDB: Compressed tables use zlib 1.2.3
121030 14:42:19 InnoDB: Initializing buffer pool, size = 16.0M
121030 14:42:19 InnoDB: Completed initialization of buffer pool
121030 14:42:19 InnoDB: highest supported file format is Barracuda.
121030 14:42:19  InnoDB: Waiting for the background threads to start
121030 14:42:20 InnoDB: 1.1.8 started; log sequence number 1595675
121030 14:42:20 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121030 14:42:20 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121030 14:42:20 [Note] Server socket created on IP: '0.0.0.0'.
121030 14:42:20 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
121030 14:42:20 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121030 14:42:20 [ERROR] Aborting

121030 14:42:20  InnoDB: Starting shutdown...
121030 14:42:21  InnoDB: Shutdown completed; log sequence number 1595675
121030 14:42:21 [Note] mysql\bin\mysqld.exe: Shutdown complete

121030 17:12:33 [Note] Plugin 'FEDERATED' is disabled.
121030 17:12:33 InnoDB: The InnoDB memory heap is disabled
121030 17:12:33 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121030 17:12:33 InnoDB: Compressed tables use zlib 1.2.3
121030 17:12:34 InnoDB: Initializing buffer pool, size = 16.0M
121030 17:12:34 InnoDB: Completed initialization of buffer pool
121030 17:12:34 InnoDB: highest supported file format is Barracuda.
121030 17:12:34  InnoDB: Waiting for the background threads to start
121030 17:12:35 InnoDB: 1.1.8 started; log sequence number 1595675
121030 17:12:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
121030 17:12:35 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
121030 17:12:35 [Note] Server socket created on IP: '0.0.0.0'.
121030 17:12:35 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
121030 17:12:35 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121030 17:12:35 [ERROR] Aborting

121030 17:12:35  InnoDB: Starting shutdown...
121030 17:12:36  InnoDB: Shutdown completed; log sequence number 1595675
121030 17:12:36 [Note] mysql\bin\mysqld.exe: Shutdown complete



Does this show anything that can be used to make XAMPP 1.8.1 work>
Thanks in advance.

Re: unable to access phpmyadmin with localhost

PostPosted: 31. October 2012 17:25
by JonB
@ samuel -

When I do something like delete the website folder inside c:\xampp\htdocs and restart the computer and set up a new website folder inside htdocs. the phpmyadmin will not work and display same error message. So I can't even access the mySQL.


Do you get Control Panel errors starting MySQL?

You realize when you delete everything inside \htdocs you are also deleting the '\htdocs\xampp" folder.

Did you fix your config.inc.php?

Good Luck
:)