Afternoon Folks,
I'm new to mySQL but have experience with Oracle and SQL Server.
Currently I'm trying to install Wordpress on Ubuntu Linux and have hit
a bit of a brick wall.
Basically, I have the current mysql database shipped with Ubuntu
server 8.04 with all the updates applied.
I can connect using:
mysql -u root -p
I have created a new database and user as follows:
create database blog_dave ;
create user wordpress ;
grant all privileges on blog_dave.* to wordpress ;
set password for wordpress=PASSWORD('<your password here>') ;
I have configured wordpress to use the new user rather than root to
connect to the new database.
When I try to run the wordpress config (wp-config.php) through my web
browser (on another machine) I'm given an error of "Error establishing
a database connection".
So I tried to connect to the database directly from the server console
using:
mysql -u wordpress -p
After entering the password,I get:
ERROR 1045 (28000): Access denied for user
'wordpress'@'localhost' (using password: YES)
If I change the wordpress config to use the root user, it all works
fine so to me it looks like I have issues with privileges around my
new user.
Can anyone tell me what I'm missing out when I create my new user?
If I can fix this before 4:30 GMT then I'll devote what's left of my
life to championing MySQL!
Thanks,
Dave.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "PHP
& MySQL" group.
To post to this group, send email to [EMAIL PROTECTED]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/phpmysql?hl=en
-~----------~----~----~----~------~----~------~--~---
