Maybe the you have something wrong with the actual database name.
In the PHP My Admin it said I couldn’t create a new database.
That’s right. You never create the DB in phpMyadmin. You create it in cPanel (or whatever site admin tool they have).
Thread Starter
jpcstl
(@jpcstl)
Moshu, right, I realized that the other day. So at the site admin tool, the data base is there, I see it. I might just delete it and start over and see if I can create it again, that should give me more control on the install that I’m used to (rather than using the screwing online thing).
Had the same problem, seems that with some installs of Fantastico, it forgets to add the “user” info to the database, which therefore blocks data getting into the database.
In cpanel click on the “mysql database” button, then it should list the databases you have within your acct. In my case the WP install showed no user info.
Simply look down the page a bit more, till you see the table of current users. You will see that the user is listed there.
Just above that table are two dropdowns with the heading “add user to database”
Select the user in the frist box, then assign them to the database in the next box, then click submit.
Next screen is to set permissions, i normally select all as it is for me the admin 😉
Hope that makes sense and saves someone the hassle of an hour or two trying to sort it out…
fred fred
thankyou thankyou. I was having the same problem and I thought I had done what you had said already but when I did in the second time it worked a treat. At least now I can get in!!!!
Thanks again
Lisa
Hi neillisa
Glad it helped you. We have used wordpress for a few years as a personal blog but only lately rediscovered the amazing things it can do.
With the “right” plugins installed for what you do it can work wonders and so easy for clients to learn.
We plan to transfer over many of our small biz clients to wordpress v2.3 when it is released next week.
I am having the same problem. Could any of you please explain better how to do this. My host runs Cpanel, I tried to create a database in the mysql administrator but I didnt know what I was doing at all.
I need the name of the database, what is this name?
Fredfred This is great advice…really saved my day!
I just had this same problem with a manual install of WP on my server, and ended up discovering two things that I didn’t find elsewhere:
- When specifying Username/Password in wp-config.php, you *must* enter the combo you set up for the user you added to the database you created in your control panel. It will not work if you use the Master User’s username/password.
- When specifying Host you must check to see where your web host has their MySQL installation. If they are running multiple MySQL versions (as mine was), you *must* enter the correct host location. For example, my host was running MySQL 4 databases under “localhost” and MySQL 5 databases under “localhost:/tmp/mysql5.sock”.
EMC2, A thousand thank youzzzzzzz for the tip on the user name and password. May you live the life that other’s only dream of. Thanks again, Kim
