how to set pass on new db

User, date Message
Written by vrob
5 months 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
5 months ago
3951 posts since Fri, 07 Apr 06 		A password can only applied to a user, not to a db.
Written by vrob
5 months 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 jfalch
5 months ago
222 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
5 months 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 jfalch
5 months ago
222 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
5 months 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
5 months ago
3951 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.