Connecting to remote mysql works in terminal, not via PHP PDO script -

-

i facing weird problem here have server app files stored , b server database

tried connect via command prompt server b using command 

mysql -h xx.xx.xx.xx -u root -p password - , worked

now tried create php script in server connect server b command 

$this->db=new pdo('mysql:host=xx.xx.xx.xx;dbname=databasename','root','password');

connection failed: sqlstate[hy000] [2003] can't connect mysql server on 'xx.xx.xx.xx' (13) fatal error: uncaught exception 'exception' message 'sqlstate[hy000] [2003] can't connect mysql server on 'xx.xx.xx.xx' (13)'

unable find solution on this.

can on this?

thank you

i got working running command in database server :)

setsebool httpd_can_network_connect_db=1

thanks replies yycdev


Comments

Post a Comment

Popular posts from this blog

How to check data type in C++? -

-
i'm new c++, i've been using python. i'm trying check type of variable of value stored in objects i'm working on. remember in python there comand isinstance use condition run commands, if next value string, a, , if it's int b. is there way check what's data type on variable in c++? example: in python had array math operation, each character in field [3,"+",2] as read array separate ints strings isinstance command if isinstance(list[0],int): aux1.append(list[0]) list=list[1:] else: if isinstance(lista[0],str): aux2.append(list[0 list=list[1:] now in c++ need similar, time each character in node linked list , again, need separate them, ints in linked list, , strings in linked list what seem struggling c++ statically , (relatively) typed language. discussion each of these terms mean refer this other question , it's explained there better could. first of should sure need...
Read more

javascript - Is getTimezoneOffset() stable during daylight saving transition? -

-
i have date time below conversion logic in javascript converting utc time passed timezone's local time. wondering logic work fine during daylight transition? if not remedy that? can't use third party library. have use pure javascript or angular js. function mytime() { var d1= document.getelementbyid("txtdate").value; var zoffset = document.getelementbyid("txtoffset").value; console.log("date1",d1); var d2 = new date(d1.replace(/ /g,'t')); var d3= d2.gettime()+(d2.gettimezoneoffset()*60000); console.log("date2",d2); console.log("date3",d3); var d4 = new date(d3 + (3600000 * zoffset)); console.log("date3",d3); console.log("date 4",d4); var d5 = d4.tolocaletimestring(); console.log("date 5",d5); ...
Read more

formula - R: how to pass in a reference to the variable in glm or lm? -

-
so let's have named vector: sorted = c(1,2,3) names(sorted) = c("a","b","c") and it'll following: > sorted b c 1 2 3 so vector named a,b,c, , has value 1,2,3 respectively. and have sample data: data.ex = as.data.frame(matrix(rep(c(1,2,3,4),3), nrow = 3, ncol = 3)) colnames(data.ex) = c("a","b","c") so data frame has 3 columns named a,b,c well. i want predict c using value in glm(): fit.ex = glm(formula = c ~ names(sorted)[2], data = data.ex, family = binomial(link = "logit")) but then, i'll keep getting following error message: error in model.frame.default(formula = c ~ names(sorted)[2], data = data.ex,: variable lengths differ (found 'names(sorted)[2]') i read article here , found as.name() function, still not working: http://www.ats.ucla.edu/stat/r/pages/looping_strings.htm and cannot find else thats similar problem. please, if the...
Read more