|sql error: Access denied for user: username@dns
|Page 1 of 1|
|Author:||avail1now [ 08 Mar 2006, 15:40 ]|
|Post subject:||sql error: Access denied for user: username@dns|
Looks like a powerful product, eager to see it work.
installed: osComm Product Manager 0.1.2.436
1) unable to connect for the very first time. I am admin for my mysql oscommerce database with ALL Priviliges. Why do I get message Access denied? How do I connect?
2)your http://www.mariovaldez.net/software/osc ... nstall.php serverside script install instructions show: The page should display a message like osCommerce Product Manager, server-side script 0.1.2.. but my host/oscpm1_upload.php says: osCommerce Product Manager (OSCPMWin), server-side script 0.1.15
Do I have most recent version of osComm Product Manager ?
|Author:||avail1now [ 08 Mar 2006, 15:47 ]|
I changed configure > Network > database options Host:
from : www.sitedomain.com
Error while connecting to database (username@localhost).
SQL Error: Can't connect to Mysql server on 'localhost' (10061)
|Author:||avail1now [ 08 Mar 2006, 18:07 ]|
reverted back to:
and went into mysql configuration and added wildcard % to host access
that got me connected but I believe I will opt for more secure access.
|Author:||mvaldez [ 10 Mar 2006, 01:18 ]|
|Post subject:||Access permission problems...|
> reverted back to: host: www.domainname.com
> and went into mysql configuration and added
> wildcard % to host access that got me
> connected but I believe I will opt for more
> secure access.
Hi. If you always connect from the same IP address, you can use that in the Host field of the MySQL permissions table. If you always connect from the same network (for example, the same IP ranges of your ISP provider) then you can add a Host definition like "68.201.215.%".
If you have a SSH account in the server you can use the SSH tunnel feature of the OSCPMWin application, and leave the Host field of the MySQL permissions table as "localhost". That would be the safest approach.
Mario A. Valdez-Ramirez.
|Page 1 of 1||All times are UTC - 7 hours|
|Powered by phpBB® Forum Software © phpBB Group