philtronics

I got the Success page, saying WordPress was installed, and prompting me for a username and pw. But I can’t log on using the stuff I told it!

I feel like I must be doing this the hard way.

That did the trick!

Now do I need to undo the other GRANT commands somehow, or can I leave it alone?

Thank you,
Phil

Well, now we’re starting to get somewhere. I had already created the wordpress database, but didn’t realize it needed a different user. I’m running MySQL 4.something, so it doesn’t take the Create User command. Therefore I tried the following: GRANT ALL PRIVILEGES ON wordpress TO ‘wordpress’@’localhost’IDENTIFIED BY ‘******etc’ WITH GRANT OPTION. Now it works better, the error message is Can’t Select Database, which means the user and pw are ok. It says to be sure the wordpress database exists, but it already does exist. From the mysql prompt I can Use wordpress and it says Database Changed.

Next I tried a second command with the wildcard, i.e., GRANT ALL PRIVILEGES ON wordpress TO ‘wordpress’@’%’IDENTIFIED BY ‘******etc’ WITH GRANT OPTION, but I get the same error message.

Well, this gets more interesting. I can get it to log on from a command window with “mysqladmin variables -u root -p”. It prompts me for the password, then dumps the status.

Don’t have phpMyAdmin, I can access MySQL from the command line using \\MySQL Server 4.1\bin\mysql –user=root –password=*********, or access it programatically. I cut and pasted the from my C# program where it works fine, into the wp-config.php file – I guess this is what you’re referring to – but no luck!

Yes, extremely sure. I built this huge web site using MySQL but I don’t even have the MS version installed. It’s very puzzling.

Thanks, but I am the host.