[vexim] Trouble connecting to db

[Andreas Westvik]

That one worked! 
But I still get the: Access denied for user 'www-data'@'localhost' (using password: NO) in the logs, and DB Error: connect failed on the page.
Anyways, I just remembered, I havent moved the /var/lib/mysql dir before, so I just went and did :D So now Its more equal :)

-Andreas 

From: odhiambo at gmail.com
Date: Tue, 23 Feb 2010 20:13:03 +0300
To: vexim at silverwraith.com
Subject: Re: [vexim] Trouble connecting to db



On Tue, Feb 23, 2010 at 8:04 PM, Andreas Westvik <andreas_westvik at hotmail.com> wrote:







Hi again Odhiambo

Really disturbing to see that you dont know! :D

Anyways, I tried the syntax and that one gave me some errors of course:

mysql> GRANT ALL ON vexim.* TO www-data at localhost IDENTIFIED BY 'thebigsecret';


ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-data at localhost IDENTIFIED BY 'thebigsecret'' at line 1


quote the www-data, as in:
mysql> GRANT ALL ON vexim.* TO "www-data"@localhost IDENTIFIED BY 'thebigsecret';

Query OK, 0 rows affected (0.06 sec)
mysql> quitBye[wash at FreeBSD-8 ~]$ mysql -uwww-data -pthebigsecret veximWelcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 69193Server version: 5.1.41 FreeBSD port: mysql-server-5.1.41
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>
-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254733744121/+254722743223
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
"If you have nothing good to say about someone, just shut up!."


               -- Lucky Dube

 		 	   		  
_________________________________________________________________
Windows 7: Se direkte-TV fra den bærbare PCen. Finn ut mer.
http://windows.microsoft.com/windows-7
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://silverwraith.com/pipermail/vexim/attachments/20100223/5890a44b/attachment.htm>