mariadb - MySQL - Grant access permissions does not work -

-

i trying give access permissions user specific database in mysql. command not seem take effect.

here's mean:

step 1:

  • create db 'testdb'
  • grant permissions 'dummyuser'@'%' on testbd.*
  • try access mysql testdb user (fails)

root@bnode1 /]# mysql -h 172.22.191.202 -u root -ppassword

mariadb [(none)]>  mariadb [(none)]> create database if not exists testdb; query ok, 1 row affected (0.00 sec)  mariadb [(none)]> grant privileges on testdb.* 'dummyuser'@'%'   identified 'password'; query ok, 0 rows affected (0.00 sec)  mariadb [(none)]> flush privileges; query ok, 0 rows affected (0.00 sec)  mariadb [(none)]> exit bye [root@bnode1 /]#  [root@bnode1 /]# mysql -h 172.22.191.202 -u dummyuser -ppassword error 1045 (28000): access denied user 'dummyuser'@'bnode1' (using   password: yes)

on mysql database can see grant priviliges dummyuser below:

mariadb [(none)]> show grants 'dummyuser'; +-----------------------------------------+ | grants dummyuser@%                                                                                        | +-----------------------------------------+ | grant usage on *.* 'dummyuser'@'%' identified password     '*2470c0c06dee42fd1618bb99005adca2ec9d1e19' | | grant privileges on `testdb`.* 'dummyuser'@'%'                                                   | +-----------------------------------------+ 2 rows in set (0.00 sec)

step 2: tried thing. grant permisson user 'dummyuser'@'bnode1', same commands, , able access.

root@bnode1 /]# mysql -h 172.22.191.202 -u root -ppassword      welcome mariadb monitor.  commands end ; or \g. ...  mariadb [(none)]> grant privileges on testdb.* '**dummyuser'@'bnode1'** identified 'passwor> query ok, 0 rows affected (0.00 sec)  mariadb [(none)]> flush privileges; query ok, 0 rows affected (0.00 sec)  mariadb [(none)]> exit bye [root@bnode1 /]#  [root@bnode1 /]#  [root@bnode1 /]# mysql -h 172.22.191.202 -u dummyuser -ppassword welcome mariadb monitor.  commands end ; or \g. ... type 'help;' or '\h' help. type '\c' clear current input statement.

i not expert in mysql, can explain me doing wrong.

error 1045 (28000): access denied user 'dummyuser'@'bnode1' (using password: yes)

you may need try connect other host see if 'bnode1' restricted 'dummyuser'

or can create fresh user(as didn't show create user command assume it's existing user) , grant command did should work.

not in case, need ensure 'bind=0.0.0.0' in my.cnf.


Comments

Post a Comment

Popular posts from this blog

java - Could not locate OpenAL library -

-
i writing game using slick2d library, uses lwjgl. lwjgl version 2.9.3. using netbeans 8. i tried adding sounds game, example music track on main menu. problem is, exception when run game, despite game still compiling , running except sound of course: sat mar 21 01:23:57 edt 2015 error:could not locate openal library. org.lwjgl.lwjglexception: not locate openal library. @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:156) @ org.lwjgl.openal.al.create(al.java:102) @ org.lwjgl.openal.al.create(al.java:206) @ org.newdawn.slick.openal.soundstore$1.run(soundstore.java:295) @ java.security.accesscontroller.doprivileged(native method) @ org.newdawn.slick.openal.soundstore.init(soundstore.java:292) @ org.newdawn.slick.music.<init>(music.java:156) @ org.newdawn.slick.music.<init>(music.java:75) @ view.mainmenu.init(mainmenu.java:58) i didn't include rest of error states error happens in game code. the...
Read more

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

-
i want check scene image against 2 train images. that, detect features , compute descriptors of both training images. before detecting, computing , matching scene image, delete matches of train1 , train2. because these matches won't facilitate matching of scene image train1 , train2. so, match train1 train2 , vector of matches trainidx , queryidx. how can delete these matches in keypoints-vector , descriptor matrix of train1 , train2? best regards, dwi i have done below: std::vector<cv::keypoint> keypoints[2]; cv::mat descriptor[2]; std::vector< cv::dmatch > matches; /* write code generate keypoints, descriptors , matches here... keypoint[0] -> train image 1 keypoints keypoint[1] -> train image 2 keypoints descriptor[0] -> train image 1 descriptors descriptor[1] -> train image 2 descriptors matches -> matched between train image 1 , 2 */ // logic keep unmatched keypoints , corresponding descriptor...
Read more

sorting - opencl Bitonic sort with 64 bits keys -

-
i used nvidia sdk bitonic sort , works great me. 32 bits (uint) need ulong keys. have typically 2^14 keys @ time , power of 2. searched on not find kernel designed ulong. i tried modified nvidia sdk bitonic sort using ulong keys not work. kernel not crash after de call clenqueuendrangekernel got error : cl_invalid_command_queue can tell me how modify bitonic sort or radixsort, or can sort ulong keys? i running nvidia quadro 4000 opencl 1.1 cuda 6.5.20 full_profile used original nvidia sdk bitonicsort.cl i used"ulong" keys , value input , ouput instead of "uint" thanks helping i made work-around suit need. used 30 bits of key , 18 high bits of value sorting. changed comparators (2 lines): '#define mask 0xffffc000 // suit need from this: if( (*keya > *keyb) == dir ) this: if(((*keya > *keyb)||((*keya == *keyb)&&((*vala & mask)> (*valb & mask)))) == dir ) it works fine. but, still, it's work-a...
Read more