Help with MySQL!

rIkLuNd

I'm new to scripting php and have just installed MySQL and PHP on my testing server (Apache) that is installed on my machine. The question is: How do I find out what the user name and password for MySQL is, or do I have to set them from somewhere?! I also have phpMyAdmin installed!
Please help me!

Thanks!

NYSiRacer

If you haven't set it, try login with root without a password

JAPH

how would i enter the password? i've been working w/o one, but it might be a good idea to get one......

NYSiRacer

Use phpMyAdmin to setup users & passwords

rIkLuNd

how do I do that?!

rIkLuNd

I'm also having trouble connecting to the database. I've installed phpBB forum, and that's working perfectly, but when I'm gonna connect to the db, and uses the following code, then I get the message "Cannot connect to database". This is the code I've used:

$link = mysql_connect("localhost","","");
if(!$link)
die("Cannot connect to database");

I'm new to writing php, and please tell me if there is some errors in the code above!

Thanks!

frog

you need to specify your username and password for the mysql database i.e.

$link = mysql_connect("localhost","root","password");

if(!$link)

die("Cannot connect to database");

I am very much a newbie at all this and have found "Beginning PHP4" published by Wrox press very useful for both PHP and mysql

janhouse00

By default there is no password given to the root user in MySQL. So if you are trying to connect to your database, say "test", try the following coding:

$host="127.0.0.1";
$username="";
$password="";
$dbname="test";

mysql_connect($host,$username,$password);
mysql_select_db($dbname);
mysql_query("blah blah blah");

Sometimes when you apply the username and password directly into the mysql_connect function, you might get certain error like"cannot connect to database blah using password=YES" due to the sake of database's security. Plus you might want to move your database to somewhere else in the future. So it's better for you to use variables to cover some critical and sensitive info like password, username.

rIkLuNd

YES, now it worked! Thanx for the tips! WoHoo! 😃

frog

Yes, I should have mentioned mysql_select_db and the use of variable to set parameters. Here is the include file that I use for my database access (as recommended by "Beginning PHP"

?php
//common_db.inc
//Mark Beal 21/10/02
//This script performs the connection to the database and passes back any errors

//Set here the database parameters
$dbhost = 'localhost';
$dbusername = 'root';
$dbuserpassword = 'monkey';
$default_dbname = 'resourceplanner';

$MYSQL_ERRNO = '';
$MYSQL_ERROR = '';

function db_connect() {
global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
global $MYSQL_ERRNO, $MYSQL_ERROR;

//test for invalid username or password
$link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
if(!$link_id) {
$MYSQL_ERRNO = 0;
$MYSQL_ERROR = "Connection failed to the host $dbhost.";
return 0;
}
//test for invalid/empty $dbname
else if(empty($dbname) && !mysql_select_db($default_dbname)) {
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else return $link_id;
}

function sql_error() {
//if the global variable $MYSQL_ERROR is empty then output the error messages defined above
global $MYSQL_ERRNO, $MYSQL_ERROR;

						if(empty($MYSQL_ERROR)) {
									$MYSQL_ERRNO = mysql_errno();
									$MYSQL_ERROR = mysql_error();
						}
						return "$MYSQL_ERRNO: $MYSQL_ERROR";

}
?>

the file is then used in a .php script thus:

global $default_dbname;//used in function db_connect - must be available to this script

include "common_db.inc";
error_reporting(0);

//connect to mysql database resourceplanner
$link_id = db_connect();
if(!$link_id) die(sql_error());

Hope this may be of help to people