Yes, I'm able to make a connection from command line (using the password in the 
secrets file):

[root@rhel61 ~]# mysql -u vcluser -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.61 Source distribution


I still get the connection error after making the suggested MySQL grant:

mysql> GRANT ALL ON vcl.* TO 'vcluser'@'localhost';
Query OK, 0 rows affected (0.00 sec)

Thanks,
Clark


-----Original Message-----
From: dcheb...@gmu.edu [mailto:dcheb...@gmu.edu] 
Sent: Monday, February 27, 2012 8:54 PM
To: vcl-user@incubator.apache.org
Subject: Re: failed mysql connection

Clark

Are you able to connect to mysql from command line on rhel61 host, 'mysql -u 
vcluser -p' ?
Can you also try with GRAND ALL ON vcl.* TO 'vcluser'@localhost?

On Feb 27, 2012, at 16:36 , Clark Cooper wrote:

> Still trying to get VCL setup/configured and moving past the php-mcrypt 
> issue, I also receive the following message within my testsetup.php output:
> 
> 
> Testing mysql connection ...
> Error: fsockopen(): unable to connect to localhost:3306 (Permission 
> denied) Could not connect to port 3306 on localhost
> 
> 
> For debugging purposes, I have stopped iptables.  Here is the connection 
> information within my secrets.php file:
> 
> [root@rhel61 .ht-inc]# grep vcl secrets.php $vclhost = 'localhost'; # 
> name of mysql server
> $vcldb = 'vcl';         # name of mysql database
> $vclusername = 'vcluser';      # username to access database
> $vclpassword = 'vcluserpassword';      # password to access database
> 
> 
> 
> Note the following outputs from MySQL:
> 
> mysql> show grants for vcluser@localhost;
> +----------------------------------------------------------------------------------------------------------------+
> | Grants for vcluser@localhost                                                
>                                    |
> +----------------------------------------------------------------------------------------------------------------+
> | GRANT USAGE ON *.* TO 'vcluser'@'localhost' IDENTIFIED BY PASSWORD 
> | '*BC54E34381D07EB1FF25938A2F524C17201FC22F' | GRANT SELECT, INSERT, 
> | UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES ON `vcl`.* TO 
> | 'vcluser'@'localhost' |
> +----------------------------------------------------------------------------------------------------------------+
> 2 rows in set (0.00 sec)
> 
> 
> mysql> select host, user, password from mysql.user;
> +-----------+---------+-------------------------------------------+
> | host      | user    | password                                  |
> +-----------+---------+-------------------------------------------+
> | localhost | root    | *A195277AB4567B2C3C4CDCAF6B5B48409EFE6765 |
> | 127.0.0.1 | root    | *A195277AB4567B2C3C4CDCAF6B5B48409EFE6765 |
> | localhost | vcluser | *BC54E34381D07EB1FF25938A2F524C17201FC22F |
> +-----------+---------+-------------------------------------------+
> 
> 
> Clark Cooper | Senior Systems Engineer
> 1301 Gervais Street, Suite 1800 | Columbia, SC 29201
> (d) 803.978.2699 | (f) 803.733.5888
> clark.coo...@vc3.com | www.VC3.com
> Follow us: 
> 
> 
> 




Thank you.

-----------------
Dmitri Chebotarov
dcheb...@gmu.edu
703-993-6175
-----------------


Reply via email to