Configuring MySQL on XAMPP.

[ask9]

Hi guys

 

This is my first time using XAMPP for development purpose.

 

I created a PHP script that will create a table and I encountered this error message below,

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'admin'@'localhost' (using password: YES) in C:\xampp\htdocs\mysql_create_table.php on line 3
Access denied for user 'admin'@'localhost' (using password: YES)

 

I already configured the username and password of the MySQL.

As you can see under the file of  c:\XAMPP\phpMyAdmin\config.inc.php

/* Authentication type and info */
$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]['user'] = 'admin';
$cfg['Servers'][$i]['password'] = 'asdf1234';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

 

 

What am I missing here?

 

Thanks in advanced.

 

 

 

 

[trq]

I already configured the username and password of the MySQL.

As you can see under the file of  c:\XAMPP\phpMyAdmin\config.inc.php

 

MySQL is NOT phpMyAdmin. they are two completely different things.

[ask9]

@thorpe

 

Have you tried XAMPP for development?

 

So How do I fix this?

 

Thanks in advanced.