momo12 Posted September 11, 2016 Share Posted September 11, 2016 ODBC 5.1 Driver Access denied for user 'momo29_user2'@'xxx.xx.xxx.xxx' (using password :YES)attached is my ODBC settingmomo29_user2 is a user added to my db momo29_cars with full privilegesi have read from other thread that in the remote mysql on cpanel i should add my ip address with %, this is what i don't get?should i put my ip address like this : %xxx.xx.xxx.xxx or like this : %xxx%xx%xxx%xxxxxx.xx.xxx.xxx <--- this ip address im using is fromt the cpanel "last login from" 1 Quote Link to comment Share on other sites More sharing options...
wolstech Posted September 11, 2016 Share Posted September 11, 2016 Just % sign, no IP address at all. You don't need to enter the IP if you use %, since it means "any IP". 1 Quote Link to comment Share on other sites More sharing options...
momo12 Posted September 12, 2016 Author Share Posted September 12, 2016 thx sir!its now working!! XD Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.