Using Mysql With .htaccess, using mySQL with .htaccess
Posted: Thu Aug 23, 2007 1:41 pm
Hello,
i have been learning PHP and starting to ue mySQL i have read and found coding that .htaccess can read username and passwords on mySQL but i can not get it working, below i hae add the coding that i have found if anyone can help me out i would be very greatful
AuthType Basic
AuthName "Restricted Area"
Auth_MYSQLhost mysql.uk.clara.net
Auth_MYSQLusername *****
Auth_MYSQLpassword *****
Auth_MYSQLdatabase database
Auth_MYSQLpwd_table login
Auth_MYSQLuid_field username
Auth_MYSQLpwd_field password
Auth_MYSQL_EncryptedPasswords off
require valid-user
when i upload this to the website to does not bring up and username and password box like it should, i have been using .htaccess with .htpasswd for a few years now and that works correctly.
i have been learning PHP and starting to ue mySQL i have read and found coding that .htaccess can read username and passwords on mySQL but i can not get it working, below i hae add the coding that i have found if anyone can help me out i would be very greatful
AuthType Basic
AuthName "Restricted Area"
Auth_MYSQLhost mysql.uk.clara.net
Auth_MYSQLusername *****
Auth_MYSQLpassword *****
Auth_MYSQLdatabase database
Auth_MYSQLpwd_table login
Auth_MYSQLuid_field username
Auth_MYSQLpwd_field password
Auth_MYSQL_EncryptedPasswords off
require valid-user
when i upload this to the website to does not bring up and username and password box like it should, i have been using .htaccess with .htpasswd for a few years now and that works correctly.