compbrat75
09-30-2004, 05:13 PM
Hello fellow forumites,
I am attempting to connect to MySQL using PHP through Dreamweaver MX 2004 from behind a powerful firewall that uses a proxy server. After working out all of the tricky details of server security that will allow me to access the MySQL database, I am now getting a 401 Unauthorized Error.
I believe this has to do with access to the MySQL database itself and setting up the users table to allow me or my multiple and ever-changing IP addresses to access the database through privileges. I looked at the Knowledge Base on the Hard Hat website and tried granting privileges to my username regardless of IP address since I may work on this site from home and work (which assigns me a different IP each time I access the web).
I still cannot get through. :confused: This is what I typed
mysql> GRANT ALL PRIVILEGES ON *.* TO "usernamehere@%" IDENTIFIED BY "passwordhere";
mysql> FLUSH PRIVILEGES;
This seemed to work. The user table now has a user: usernamehere@% user.
I still cannot get through. :confused:
My goal is to be able to develop this site from any IP.
Also, forgive my naivety, but if I get this to work, will it limit my web visitors from gaining access to data driven pages or is it just for my user to use for development and to pull data for those pages for the web viewing public?
Any help would be greatly appreciated! :D
I am attempting to connect to MySQL using PHP through Dreamweaver MX 2004 from behind a powerful firewall that uses a proxy server. After working out all of the tricky details of server security that will allow me to access the MySQL database, I am now getting a 401 Unauthorized Error.
I believe this has to do with access to the MySQL database itself and setting up the users table to allow me or my multiple and ever-changing IP addresses to access the database through privileges. I looked at the Knowledge Base on the Hard Hat website and tried granting privileges to my username regardless of IP address since I may work on this site from home and work (which assigns me a different IP each time I access the web).
I still cannot get through. :confused: This is what I typed
mysql> GRANT ALL PRIVILEGES ON *.* TO "usernamehere@%" IDENTIFIED BY "passwordhere";
mysql> FLUSH PRIVILEGES;
This seemed to work. The user table now has a user: usernamehere@% user.
I still cannot get through. :confused:
My goal is to be able to develop this site from any IP.
Also, forgive my naivety, but if I get this to work, will it limit my web visitors from gaining access to data driven pages or is it just for my user to use for development and to pull data for those pages for the web viewing public?
Any help would be greatly appreciated! :D