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

how to set pass on new db

User, date Message
Written by vrob
2 years ago
Category: General
4 posts since Fri, 21 Dec 12
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.
Written by ansgar
2 years ago
5045 posts since Fri, 07 Apr 06
A password can only applied to a user, not to a db.
Written by vrob
2 years ago
4 posts since Fri, 21 Dec 12
How do I set up Wordpress, then, which asks for define('DB_PASSWORD', 'mypassword');

in the config file?
Written by jfalchMoney, Euro
2 years ago
412 posts since Sat, 17 Oct 09
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.
Written by vrob
2 years ago
4 posts since Fri, 21 Dec 12
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!
Written by jfalchMoney, Euro
2 years ago
412 posts since Sat, 17 Oct 09
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.
Written by vrob
2 years ago
4 posts since Fri, 21 Dec 12
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!
Written by ansgar
2 years ago
5045 posts since Fri, 07 Apr 06
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.