database - Command for granting Access on MySQL -

-

what command granting access mysql database new users want connect?

consider statement: 

create user 'java'@'localhost' identified 'password'; grant on javabase.* 'java'@'localhost' identified 'password';

here localhost able connect database. can write '*' instead of 'localhost'?

grant on javabase.* 'java'@'%' identified 'password'; work hosts


Comments

Post a Comment

Popular posts from this blog

c++ - list<myClass<int> * > sort -

-
i cannot sort list contains pointers objects of template class. template class node{ public: node(void){} node(t choice, vector<t> & data); node(t choice, vector<t> & data, player p, int level, int pos, node<t> *pred, side); void addnodes(void); static list<node<t> * > nodes; friend class mybinomialtree<node<t>, t>; bool sorter(const node<t> * lhs, const node<t> * rhs);// * &lhs doesn't work private: node<t> * left; node<t> * right; t chosen_; vector<t> data_; bool isleaf; //... }; outside class: template<class t> bool node<t>::sorter(const node<t> * lhs, const node<t> * rhs){ if((*lhs).level_==(*rhs).level_){ return (*lhs).pos_<(*rhs).pos_; }else{ return (*lhs).level_<(*rhs).level_; } } and want sort before print, have template<class t> void node<t>::print(void){ ...
Read more

c - Defining floating point constants, how many digits are useful? -

-
when define constants in c cannot accurately represented in decimal system, example π , how many digits taken account compiler creating float or double in memory? for example: /* overkill? */ const float pi_f = 3.1415926535897932384626433832795f; /* few digits? */ const double pi_d = 3.14159; assuming ieee 754 standard floating point numbers , commonplace nowadays, 7.22 digits of accuracy float , 15.95 double , aim 7 digits after decimal point float π constant , 15 double on safe side. 128-bit long double gives 34.02 precision, 33 positions after decimal point in π.(*) however, excess precision won't hurt, compiler cut off. (*) note long double quite not ieee format; x86-32 typically has 80-bit, not 128-bit, long double . in msvc, it's apparently synonym double , 64-bit.
Read more