Perhaps phrasing the request more generally will help them clue in. “How do I create and access a MySQL database?”
Thanks for your suggestion. I’ve written them using your pharsing.
~dL
It is unlikely that a host who supplies mysql does not already furnish the necessary info. The WP install only needs four variables that any mysql user on that host would need anyway. A good hunt through the host admin interface and your hosting docs / emails might produce the necessary parameters. They are there somewhere.
My host wrote, “we do not officially tech support the creation of of MySQL databases.”
I got these settings from my cpanel:
define(‘DB_NAME’, ‘willneea_agbook1’);
define(‘DB_USER’, ‘willneea_agbook1’);
define(‘DB_PASSWORD’, ‘password’);
define(‘DB_HOST’, ‘localhost’);
Do I use the same password as my host username/password, or create a new one?
I found http://www.freewebmasterhelp.com/tutorials/phpmysql/ on Google. Installation of PHPMyAdmin (or a similar program) is suggested, if I understand it correctly, for creation of the database. Is this the way to go?
My son seems to think I need to know what server my MySQL is on, and what port it uses. If this is true, where can I find this info?
I am a designer type– the technical end really floors me, so any help will be gratefully appreciated.
~dL
what kind of backend your host provide? cpanel directadmin or plesk? ur settings look fine to me otherwise… u can choose any password.
I don’t know what “backend”, or “plesk” mean. Since I can access the cpanel, I *assume* the “backend is cpanel directadmin.
The cpanel reads:
Databases:
willneea_agbook1
Users in agbook1
willneea_agbook1 (Privileges: ALL PRIVILEGES)
Connection Strings
Perl $dbh = DBI->connect(“DBI:mysql:willneea_agbook1:localhost”,”willneea_agbook1″,”<PASSWORD HERE>”);
PHP $dbh=mysql_connect (“localhost”, “willneea_agbook1”, “<PASSWORD HERE>”) or die (‘I cannot connect to the database because: ‘ . mysql_error());
mysql_select_db (“willneea_agbook1”);
User: willneea_ag_book1 Db: willneea_ag_book1
I tried my host/password first, and then a newly created password. Either way I get:
http://www.dlaakso.com/test.php
Warning: mysql_connect(): Access denied for user: ‘inspers_minh@localhost’ (Using password: YES) in /home/willneea/public_html/test.php on line 5
If it’s of any value in resolving this, my php/mysql info can be seen here:
http://www.dlaakso.com/phpinfo.php
Thanks…
~dL
I am using these settings with my host account password:
define(‘DB_NAME’, ‘willneea_agbook1’);
define(‘DB_USER’, ‘willneea_agbook1’);
define(‘DB_PASSWORD’, ‘pass*******word’);
define(‘DB_HOST’, ‘localhost’);
I get a 404 on this URL:
http://www.dlaakso.com/wp-admin/install.php
(The numeric chmod value of file wp-config.php is 644)
What can the matter be?
Anonymous
tried this?
http://www.dlaakso.com/wordpress/wp-admin/install.php
u have a database connection problem…
Okay got it — forgot to add the wordpress directory in the address…
This just too frustrating. Are there host services that provide MySQL tech support?
Finally! Got it up and running…
Many thanks to all who helped out, and didn’t give up on me.
http://www.dlaakso.com/wordpress/