Hello,
Can someone who has successfully created a MySQL database for a virtual
hosting account show me how to connect! I can always
connect as root ... but when I try to connect as the user its get a
permission error. I went to the database and gave the user of that virtual
account all premisions in the USER table in the MYSQL database. But that did
not help. Here is the error I get:
mysql> use bcwdb;
ERROR 1044: Access denied for user: '@localhost' to database 'bcwdb'
I tried two ways.
by the shell. This is what I get:
[lindab lindab]$ mysql -u lindab -p
Enter password:
ERROR 1045: Access denied for user: 'lindab@localhost' (Using password: YES)
and via my VBB install script .. which gives the same type error
I looked in the Mysql database and I think I have each required record
ie
user table
| localhost | lindab | ....
host table
| localhost | bcwdb | Y | Y | Y | Y ...
db table
| localhost | bcwdb | lindab | Y ...
and the above does not seem to work .... I am loosing my mind
thanks
David
--
Systematic Software
[EMAIL PROTECTED]
(513) 241 3331 ext. 9
http://www.systware.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
