can't use my database

nasatech

Ok, here is my little problem, a couple of days ago, I was working on a page that connected to my database and everything was running nice and smooth....but then I formatted my comp.
I saved the page and database, reinstalled apache, php and MySQL(earlyer I wrotethat I didn't, but I've actually found it now)
and thought that everything would be as it was before but it isn't.

...anyway, I used this to connect to it before:

$starta=mysql_connect (localhost, root, password); 

    mysql_select_db (flameline);

But when I try that now, it doesn't work, I have to connect without any password at all and I don't like that, I'd like to change it but I don't know haw and where to do it, please help me...

OhLordy

Are the username and password still the same?
try

<?
$starta=mysql_connect(localhost,root,password) or die(mysql_error());
?>

to display the error.
HTH
Rob

nasatech

The password an username..that's the problem, I don't know where or how to assign a database a password or a username...is it the ones you write when u start MySQLAdmin for the first time? then I guess it's the same...I'll try that, thanks..

nasatech

allright, I can now connect to and use my database....after a reinstallation of mysql and some other things...

that is, I can, if I don't use any password at all...but I want to have a password...how can do so I have to use the password again?

OhLordy

you have to create a password for mysql. What OS are you running? If you are running nix you can get into mysql at from teh command line using

mysql -uroot -p

first you must create a password with the following

use mysql;
UPDATE user SET password=PASSWORD('password1') WHERE user='root'];
FLUSH PRIVILEGES;

then you can create a new super user with the command

GRANT ALL ON *.* TO username@localhost IDENTIFIED BY 'password';

I'm afraid I'm not sure how to do it on a Windows machine
HTH
Rob

nasatech

Thanks for herlping me out! =)

it works now, although I couldnint do the last thing you wrote...(the one that starts with "GRANT ALL")...

I get an error message saying:

"Access denied for user: '@127.0.0.1' (Using password: NO)"

but now I have to use passwords when I try to access the db with php, wich is good! =)