getting started with mysql

[perj]

"Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole."

I get this message in php myadmin. Obviously i haven't set a password in php.ini, however i can't find exactly where im supposed to do this in the config file. can some1 tell me? thanks.

[Jessii]

Where it says password? lol

This is the basic structure for the config file.

$dbhost = 'hostname';
$dbname = 'database name';
$dbuser = 'user name';
$dbpasswd = 'password';

[DFox]

If you're logged in as the default user, can't you just modify the MySQL user info via PHPMyAdmin?

I don't believe you would set that in the mysql config file. I think you can use PHPMyAdmin, or run a query.

[perj]

yeh i dont see it. I'm using wamp, if that matters.

The php.ini file is here: kuniforms.com/php.txt

I just found something with username and stuff called ingres.default_user, is that it?

[DFox]

At 12/5/06 09:47 PM, perj wrote: yeh i dont see it. I'm using wamp, if that matters.

The php.ini file is here: kuniforms.com/php.txt

I just found something with username and stuff called ingres.default_user, is that it?

Just as I thought... In PHPMyAdmin:
Privileges -> Edit privileges on root, and there is the login info...

[perj]

At 12/5/06 09:49 PM, DFox wrote:

At 12/5/06 09:47 PM, perj wrote: yeh i dont see it. I'm using wamp, if that matters.

The php.ini file is here: kuniforms.com/php.txt

I just found something with username and stuff called ingres.default_user, is that it?

Just as I thought... In PHPMyAdmin:
Privileges -> Edit privileges on root, and there is the login info...

i changed the password and now I can't even get into phpmyadmin, it says

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

[DFox]

At 12/5/06 10:15 PM, perj wrote: MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

That's supposed to happen. Now just configure the correct login in the phpmyadmin file config.inc.php to match the username and password.

[perj]

sweet! i got it, thanks a lot sons