Database connect

**konetch** · 07-03-2009, 01:01 PM

Well, I've decided I would start seriously learning PHP. I've decided to mess with some pre-made scripts to get a feeling of how to build my own. My goal is to build a very simple CMS which will basically only have functions for adding new articles and editing them.

Right now I am building a login script which is copied exactly from this tutorial http://www.evolt.org/php_login_scrip...ber_me_feature

I'm running everything from my local machine on a xampp server. This is what I have in the database.php file

PHP Code:


			
<?

/**
 * Connect to the mysql database.
 */
$conn = mysql_connect("localhost", "akon", "aKon") or die(mysql_error());
mysql_select_db('akon', $conn) or die(mysql_error());

?>

On the main.php page it comes up with the error Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'akon'@'localhost' (using password: YES) in C:\xampp\htdocs\konetcms\database.php on line 6
Access denied for user 'akon'@'localhost' (using password: YES)

I've checked the passwords and everything is correct. I'm not sure why I've got this error and I've tried searching google for an answer with no help.

If you could tell me why I'm getting this it would be great.

Thanks

**techbongo** · 07-06-2009, 02:53 AM

At first stop using XAMPP server. This is the worst one, I've ever used with thousands of bugs. Try using Apache2Triad, which is also open source server.

And you password is not given correctly. I guess. Because xampp doesn't accept 4 digit passwords. Please recheck.

Two possible reasons for the error are:
1. You password is incorrect for the username.
2. The MySQL server is not running (because of the buggy xampp server) and thus no localhost database server is there. Check the list of processes from Task Manager. If mysqld.exe is not running there, be sure, MySQL server is not running.

**konetch** · 07-06-2009, 04:52 PM

Sorry, actually I got it running. Since it is on my local machine there is no password for the mysql databases. The correct code is

PHP Code:


			
 <?

/**
 * Connect to the mysql database.
 */
$conn = mysql_connect("localhost", "root") or die(mysql_error());
mysql_select_db('akon', $conn) or die(mysql_error());

?>

Thanks though for your help. So far I haven't had problems with the server. Do you know of any major bugs I'd have to watch out for?

</span> </span>

**colbyt** · 07-06-2009, 08:12 PM

I have experienced no problems with xampp.

You should consider adding a password for root and mysql if you leave it running all the time. That will break some of the "goodies" they include in the distribution until you modify the config files.

You will also need to change your file for this script to include the password if you create one.

**konetch** · 07-07-2009, 04:01 PM

For some reason you can't add a password to root with xampp. I tried creating one and you couldn't log into the phpmyadmin, so I had to re-install the entire server. Does anybody know how to get around this?

Thanks

**colbyt** · 07-07-2009, 05:27 PM

Are you using Vista or XP?

Did you create a new folder for each site you want to play with?

If I try to browse to localhost a password is required. If I go to localhost/sitefolder none is required.

All I did was follow the security reccomendations that came with the distribution.

I have a password on localhost and for mysql.

**konetch** · 07-07-2009, 06:50 PM

I'm using vista.

Yeah, I do have a folder for each site I'm working with, but when I go to http://localhost no password is required.

When I installed it I used the istaller and it didn't prompt me to enter a password or anything, but since it is an apache server, I could create a htaccess file that would protect certain folders, right?