how to set pass on new db

[expired user #6732]'s profile image [expired user #6732] posted 11 years ago in General Permalink
New-to-Heidi question: when I create a new db, I can set the name and encoding but where do I set the password?

I'm sure it's obvious, but I've searched and looked all over.
ansgar's profile image ansgar posted 11 years ago Permalink
A password can only applied to a user, not to a db.
[expired user #6732]'s profile image [expired user #6732] posted 11 years ago Permalink
How do I set up Wordpress, then, which asks for define('DB_PASSWORD', 'mypassword');

in the config file?
jfalch's profile image jfalch posted 11 years ago Permalink
you must have a database user name and a corresponding password to access the database server (which contains the database ro be used by your Wordpress).
these should be known to you (if its your onw server), or been told to you by your server / hosting provider - if not, ask there.
these are the username and password which you would also enter into heidisql´s session manager.
[expired user #6732]'s profile image [expired user #6732] posted 11 years ago Permalink
ok--so wordpress db_password is not the user pass or a pass associated with the individual database (that I created with HS) but it's the database server's password (which I entered into the session manager).

Is that correct?

Thanks!
jfalch's profile image jfalch posted 11 years ago Permalink
i think so; try it. you would probably have to specify the database user name as well somewhere in the config file; these two are always used together.
[expired user #6732]'s profile image [expired user #6732] posted 11 years ago Permalink
Thanks--I got my dns configured so I can test it and to set up each database for wordpress, you use the USER's pass in the DB_PASSWORD in the config.

That doesn't make sense to me, as the user is independent of each database, but there you go. If it makes Wordpress happy, I'm happy.

Thanks for your help!
ansgar's profile image ansgar posted 11 years ago Permalink
Yes, "DB_PASSWORD" is wrong phrasing. WordPress and other tools use the word "Database" as a synonym for the *server*. E.g. "My database is secured against attacks". Then, in MySQL, a database is something which other DBMS call "schema", or "catalog".

Please login to leave a reply, or register at first.