New User, Help with an error please
Posted by: Man-O-Leisure (---.206.233.220.exetel.com.au)
Date: May 07, 2008 03:50PM

I just downloaded and installed wampserver, its running, and when i try to CREATE DATABASE; i get the following error:


ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'

Can anyone help with this? i dont recall any username or password setup during the installation, and i am the admn on my pc where i have wampserver running.

Thanks

Options: ReplyQuote
Re: New User, Help with an error please
Posted by: stevenmartin99 (---.b-ras1.blp.dublin.eircom.net)
Date: May 07, 2008 05:26PM

open up c:/wamp/apps/phpmyadmin.10/config.inc.php

find this


$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed


and chnage it to

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed


then save it and try again

once your in , you should set a password in mysql by pressng privledges.

then go bac into the file above and key in ur password

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.