Displaying 2 results from an estimated 2 matches for "uproftpd".
Did you mean:
proftpd
2015 Mar 30
5
mysql can't connect from localhost -strange behavior
...9A3A36961511B387E74A9 |
+---------+-----------+-------------------------------------------+
1 row in set (0.00 sec)
And here's my attempt to connect with the password shown. Which is
something I don't usually do, but am doing now to demonstrate what's going
on:
[root at ops:~] #mysql -uproftpd -ptestpattern -h localhost
ERROR 1045 (28000): Access denied for user 'proftpd'@'localhost' (using
password: YES)
OK, so as I've said this should work!
The database I'm trying to give the user access to does also exist:
mysql> show databases like 'ftp';
+-----...
2011 Aug 26
1
mysql authentication in proftpd
...proftpd
#AuthOrder mod_auth_pam.c* mod_auth_unix.c
AuthOrder mod_sql.c
This is my sql login section:
# SQL login
SQLConnectInfo ftpdb at db1 proftpd secret
Which I have verified does work from the ftp server:
[root at VIRTCENT08:~] #mysql -uproftpd -psecret -h db1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3354
Server version: 5.5.15-log MySQL Community Server (GPL) by Remi
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use ftpdb
Reading table inform...