distal-attribute
distal-attribute
distal-attribute
distal-attribute

how to set pass on new db

vrob posted 2 years ago in General
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 posted 2 years ago
A password can only applied to a user, not to a db.
vrob posted 2 years ago
How do I set up Wordpress, then, which asks for define('DB_PASSWORD', 'mypassword');

in the config file?
jfalch posted 2 years ago
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.
vrob posted 2 years ago
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 posted 2 years ago
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.
vrob posted 2 years ago
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 posted 2 years ago
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.