<1> CD: F \ xampp \ mysql \ bin
<2> F:
<3> Mysql - h localhost -u root -p
<4> Press enter
<5> The create user 'guest' @ '%' identified by '123456.';
<6 & gt; Grant select on *. * to 'guest' @ '%' identified by '123456.';
<7 & gt; flush privileges;
And then in the browser input phpmyadmin background check, have set up this account also has the authority to query,
The question now is: I send the user name and password to other team members, he can only view the data, then he has been even navicat, always prompt:
Aborted connection to 1904092 db: 'unconnected user:' guest 'host:' XX. XX. XX. X '(init_connect command failed) -- -- -- -- -- -- -- -- this error is what problem?
I'm online to find a similar problem, as if said init_connect='SET NAME utf8', so it is ok to change, but I was looking for, my my. Ini, not like that, but
:
8 # UTF Settings
Init - connect=\ 'SET NAMES utf8 \'
Collation_server=utf8_unicode_ci
Character_set_server=utf8
Skip - character - set - the client - handshake
Character_sets - dir="/xampp/mysql/share/charsets"
If so, version of the problem, or what problem, urgent, thanks!
CodePudding user response:
Xampp is specific version of xampp - portable - win32 - - VC14 7.0.9-1