[REQ] connexion with htaccess

[GoogleCodeExporter]

Hi guys, 

it would be great if sequel pro could establish the connection with a database 
protected by htaccess (by typing the password required directly in sequel pro)

Original issue reported on code.google.com by romain.a...@gmail.com on 6 Sep 2013 at 9:24

[GoogleCodeExporter]

Hi Romain,

I'm afraid I don't really understand the support request - how is the database 
protected by htaccess?  Isn't htaccess a web server directory configuration, 
not a MySQL authentication mechanism?

Original comment by rowanb@gmail.com on 7 Sep 2013 at 2:38

• Changed state: WaitingOnUser

[GoogleCodeExporter]

Indeed, in my example the MySQL database is managed via phpmyadmin tool on a 
webserver, but the whole is protected by an htaccess. So i can't connect with 
Sequel Pro, but it's due to web server protection, not MySQL, so i don't know 
if it's possible to implement this thing.

Original comment by romain.a...@gmail.com on 7 Sep 2013 at 9:31

[GoogleCodeExporter]

Hi Romain,

Sequel Pro is a manager much like phpmyadmin - as such it needs a connection to 
the underlying database itself.    I'm afraid it can't yet act via a proxy by 
routing via phpmyadmin or a custom script.

You can typically find the MySQL server details in the phpmyadmin 
config.inc.php script, and you may be able to use those with Sequel Pro if 
external access is permitted, or if you can use a SSH tunnel to the server.

Hope that helps...

Original comment by rowanb@gmail.com on 8 Sep 2013 at 10:34

• Changed state: Invalid

[GoogleCodeExporter]

Ok,

I will ask FTP access to see the config.inc.php file and I will try to connect 
to MySQL server with login informations.

Tanks a lot for your replies ;)

Original comment by romain.a...@gmail.com on 9 Sep 2013 at 8:28