Configuring MySQL on XAMPP

PHP
1

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.

2

The phpMyAdmin configuration doesn’t set the MySQL login(s), what you need to do is load phpMyAdmin and click the “Privileges” tab. Next click Add a new User or edit the already created login which is root by default and has no password. So by default you can use this in your PHP instead…

mysql_connect('localhost', 'root', '');