I installed xampp for windows 1.7.7 and php-5.4.1RC2-Win32-VC9-x86 on windows 7 x64.

After starting apache and mysql, I opened phpmyadmin, but not logged in.

I:\xampp\mysql\bin>mysql -uroot -p
Enter password: ************

After 10 minutes, the prompt is not answered.

There is no clues at "mysql/data/mysql_error.log" file and "apache/logs".

Any helpful comment would be appreciated.

Thanks in advance.

    At "phpmyadmin" at 'http://localhost:8080/phpmyadmin/index.php", this error message is shown.

    Error

    MySQL said:

    Cannot connect: invalid settings.
    phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

    And "my.ini" file is this.

    [client] 
port            = 3306 
socket          = "I:/xampp/mysql/mysql.sock"
[mysqld]
port= 3306
socket= "I:/xampp/mysql/mysql.sock"
basedir="I:/xampp/mysql" 
tmpdir="I:/xampp/tmp" 
datadir="I:/xampp/mysql/data"
pid_file="mysql.pid"
skip-external-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
log_error="mysql_error.log"
skip-federated
server-id	= 1
innodb_data_home_dir = "I:/xampp/mysql/data"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "I:/xampp/mysql/data"
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_use_sys_malloc =0

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[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

      Hmm. mysql.sock is a UNIX socket; I'm not aware that you can actually have one on a Windows system. I could be wrong, though. I might try commenting out all the configuration lines that refer to it, and restarting the MySQL server (or possibly the whole XAMPP stack), then verify that MySQL is listening on port 3306 with "netstat" from the command-line, and then try again.

      Can't definitively say that's what's up, but it's worth looking into during your troubleshooting.

        dalecosp/ Thanks, I'll check.

        And tak a look at phpmyadmin's "config.inc.php" file.

        <?php
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$i = 0;
$i++;
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
?>

          It sounds like the MySQL server isn't even running. Have you checked that it is?

            bradgrafelman/

            This is netstat -ant, I think mysqld works.

            netstat -ant
            TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING InHost

            TCP 127.0.0.1:3306 127.0.0.1:23375 FIN_WAIT_1 InHost

            TCP 127.0.0.1:3306 127.0.0.1:26340 FIN_WAIT_1 InHost

            TCP 127.0.0.1:3306 127.0.0.1:26349 FIN_WAIT_1 InHost

            TCP 127.0.0.1:3306 127.0.0.1:26356 FIN_WAIT_1 InHost

            TCP 127.0.0.1:3306 127.0.0.1:26359 FIN_WAIT_1 InHost

            TCP 127.0.0.1:3306 127.0.0.1:26422 FIN_WAIT_1 InHost

            TCP [::]:3306 [::]:0 LISTENING InHost

              Have it tried it with your firewall turned off?

                There are chances that host name makes mess. '127.0.0.1' works but 'localhost' may not. Have you tried changing it in config.inc.php?

                  Write a Reply...